FiveDBU with ADO support

[Marc Vanzegbroeck]

Antonio,

Thank you for the updated version.
The database-structure is not directly open after entering the connection-string. Therefore, I can't check it with MySQL.
The problem with empty fields in SQLite is still there.

I will send you a SQLite-database + ADO-connector.

[Antonio Linares]

Marc,

Many thanks for your files. I have installed the SQLite ODBC driver on Windows 8 64 bits, and when I try to connect from FiveDBU I get this:



Any hints ?

[Marc Vanzegbroeck]

Antonio,

You have to use
Driver={SQLite3 ODBC Driver};Database=c:\test\ef.db
instead of
Driver={SQLite3 ODBC Driver};Database="c:\test\ef.db"

[Antonio Linares]

Marc,

Now I get this:

[Marc Vanzegbroeck]

Antonio,

Did you installed the ADO-Connector that I have send you?

[Antonio Linares]

Marc,

I am testing now from a Windows 8 32 bits and it seems to be connecting, but I don't get the list of tables from ef.db

Do you get them ?

[Marc Vanzegbroeck]

Antonio,

I get the list, but only after entering the connection-string AND selecting then the file with 'Select a file'

That's why I'm telling you that it is better direcly open the database after entering the connection-string, or add a button like 'Browse the selected database'.

This is what I get

[Antonio Linares]

Marc,

I have just published an enhanced version that offers the tables after the connection and also allows to edit empty fields:

https://code.google.com/p/fivewin-contributions/downloads/detail?name=fivedbu_20130506_2.zip

Many thanks for your feedback

[Marc Vanzegbroeck]

Antonio,

Thank you for the latest modification.
I have try it, and now I can connect to both SQLite and MySQL.
Also the editing is working!
I will try it to see if everything is working with both databases.

[Marc Vanzegbroeck]

Antonio,

It would be nice to have also a "Recent ADO-connection Strings " menu item that is saved in the ini-file.

Sended with Tapatalk

[Antonio Linares]

Marc,

A much enhanced ADO connections management and recently used connections support

https://code.google.com/p/fivewin-contributions/downloads/detail?name=fivedbu_20130508.zip

[Marc Vanzegbroeck]

Antonio,

It's looking very nice, the only problem that I can't open a database

After selecting ODBC-drivers, and selecting SQLite 3, I can test the connection with success, but how do I select the database?
It show me directly an empty table-list.

How can I select my MySQL-driver?

[Antonio Linares]

Marc,

You have to create a datasource from "Control Panel", "Administrative tools", "ODBC DataSources 32":



Then you select if from FiveDBU:

[Antonio Linares]

Here you have a video showing how to use FiveDBU + ADO

Select to reproduce it in HD from Facebook or it will look ugly
https://www.facebook.com/video/video.php?v=590319987653068&notif_t=video_processed

No sound yet, sorry. Trying to fix it...

[Marc Vanzegbroeck]

Antonio,

The link doesn't work.

If a go to ODBC Datasource, I don's see my SQLite or my MySQL driver.
Maybe because I see the 64bit datasource.
Where do I find the 'ODBC DataSources 32' in Win7?