FiveDBU with ADO support

[Antonio Linares]

Marc,

Please try with this video link:
https://www.facebook.com/photo.php?v=590319987653068&set=o.139428242870007&type=2&theater

[Marc Vanzegbroeck]

Antonio,

Maybe the reason that I can't access the link is that I don't have a Facebook-account...

[Antonio Linares]

I have turned it into a public link so there should be np problem to show it,

Please try it again

[Marc Vanzegbroeck]

Now I can see it

The problem is that in the list my SQLite-connector or MySQL-connector is not displayed like in the video
Only DBase,Excel and MS access. It's strange, since I can use it in my programs (and the previous version of FiveDBU)

Did you just installed the connector I have send you, or did you install something else?

[TimStone]

I just downloaded, and tested, the latest version. I see that you can only do one record at a time. Thus, you can't highlight and select a group of records to delete or restore.

How about filters and find/replace ?

[Antonio Linares]

Marc,

I only installed what you sent me.

From the "control panel", "Administrative tools", "ODBC datasources" click on "User DSN at the top", then click on "Add", there you will see all your installed drivers and you can select yours

[Antonio Linares]

Tim,

We will be including all the needed features, for now we are focused on solving the basic funcionality (I am now working with indexes)

[Marc Vanzegbroeck]

Marc,

I only installed what you sent me.

From the "control panel", "Administrative tools", "ODBC datasources" click on "User DSN at the top", then click on "Add", there you will see all your installed drivers and you can select yours

Antonio,

This is the only I see when I press 'Add'



I will try it also on another laptop.

[Antonio Linares]

Marc,

See what I get here:



I have Several Visual Studios installed on this computer, but I only installed your SQLite driver (unless it was already there)

[Maurizio]

Antonio

is possible connect to MySql ?

Maurizio

[Marc Vanzegbroeck]

Antonio

is possible connect to MySql ?

Maurizio

Maurizio,

Normaly it's possible, because in the previous version where you could enter a connection string, I can connect to both SQLite and MySQL databases.
In this version, I can't do it yet, but it's probably a problem on my laptop. I will look why there is a problem is on my laptop.

[Marc Vanzegbroeck]

Antonio,

I just tested it on my laptop with a VMWARE-WIN7/32bit, and there it's working without any problem
My laptop is a Win7/64bit. I will now install a VMWARE-WIN7/64bit to see if it's running then.
Antonio, is you system running on a 32bit, or a 64bit PC?

[Marc Vanzegbroeck]

Antonio,

I found the problem

On a 64bit/PC you have 2 types of ODBC-setups. One for 32bit-apprlications, and one for 64bit...

To setup an ODBC link for 32bit application you must use
C:\Windows\SysWOW64\odbcad32.exe

To setup an ODBC link for 64bit application you must use
C:\Windows\System32\odbcad32.exe

So on SysWOW64 is the 32bit-version and in path System32 the 64bit-version This is Microsoft-logic?
If I run the 32-bit, I see the SQLite and MySQL connectors. The problem is that FiveDBU is launching the 64bit version, where I can't configure it because it's a 32bit-program.
Can you change it?

[Antonio Linares]

Marc,

Here it is working fine on Windows 8 64 bits. I have also noticed that there are two ODBC settings in "Administrative tools", but see what the 64 bits says regarding SQLite:





In fact, I create the test datasource from the 32 bits ODBC panel and automatically shows on the 64 bits one (images above).

And FiveDBU is working fine on Windows 8 64, selects the datasource and the ADO connection works. Please review your settings compared with my screenshots.

[Marc Vanzegbroeck]

Antonio,

Now it's working!!!

What I do is start the 'ODBC link for 32bit application' and add a SQLite and a MySQL connection, and than start FiveDBU.
Then I can select the connection in the 64bit ODBC application.

I can both browse the SQLite and MySQL/MariaDB databases!!