FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour FiveDBU with ADO support
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: FiveDBU with ADO support
Posted: Wed May 08, 2013 12:02 PM
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: FiveDBU with ADO support
Posted: Wed May 08, 2013 12:06 PM

Antonio,

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

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: FiveDBU with ADO support
Posted: Wed May 08, 2013 12:12 PM

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

Please try it again :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: FiveDBU with ADO support
Posted: Wed May 08, 2013 12:26 PM

Now I can see it :D

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?

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 3022
Joined: Fri Oct 07, 2005 01:45 PM
Re: FiveDBU with ADO support
Posted: Wed May 08, 2013 03:43 PM

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 ?

Tim Stone
http://www.MasterLinkSoftware.com
http://www.autoshopwriter.com
timstone@masterlinksoftware.com
Using: FWH 23.10 with Harbour 3.2.0 / Microsoft Visual Studio Community 2022-24 32/64 bit
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: FiveDBU with ADO support
Posted: Wed May 08, 2013 06:36 PM

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 :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: FiveDBU with ADO support
Posted: Wed May 08, 2013 06:38 PM

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) :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: FiveDBU with ADO support
Posted: Thu May 09, 2013 09:32 AM
Antonio Linares wrote: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.
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: FiveDBU with ADO support
Posted: Thu May 09, 2013 10:17 AM
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)
regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 842
Joined: Mon Oct 10, 2005 01:29 PM
Re: FiveDBU with ADO support
Posted: Thu May 09, 2013 10:24 AM

Antonio

is possible connect to MySql ?

Maurizio

Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: FiveDBU with ADO support
Posted: Fri May 10, 2013 08:26 AM
Maurizio wrote: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.
Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: FiveDBU with ADO support
Posted: Fri May 10, 2013 08:37 AM

Antonio,

I just tested it on my laptop with a VMWARE-WIN7/32bit, and there it's working without any problem :D
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?

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: FiveDBU with ADO support
Posted: Fri May 10, 2013 09:28 AM

Antonio,

I found the problem :D

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? :D
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?

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
Re: FiveDBU with ADO support
Posted: Fri May 10, 2013 01:41 PM
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.

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: FiveDBU with ADO support
Posted: Fri May 10, 2013 03:18 PM

Antonio,

Now it's working!!! :D

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!!

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite