Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tom Saddul
  Where is Tom Saddul?
 Paranaque
 Philippines
 Tom Saddul
 To: joe Degorio
  Where is joe Degorio?
 Tacloban City
 Philippines
 joe Degorio
 Tags
Subject: RE: ODBC Connector driver (64bit)
Thread ID: 395445 Message ID: 395451 # Views: 94 # Ratings: 2
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Wednesday, January 15, 2014 4:14:16 AM         
   


> Hello everyone,
> I have an application running on windows 7 (32bit). Now I'm trying to install it to a windows 7 64bit machine. I download the driver and configure it.. and have the following result.
>
>
>
> But when running the following code in vfp...
>
>
> PUBLIC h,lcStringConn,lcSQLScript1
> lcServer="localhost"
> lcDatabase="pharmacy"
> lcUser = "root"
> lcPassword = ""
> lcStringConn="Driver={MySQL ODBC 5.2 Unicode Driver};Port=3306"+;
>              ";Server="+lcServer+;
>              ";Database="+lcDatabase+;
>              ";Uid="+lcUser+;
>              ";Pwd="+lcPassWord
> *** Don't prompt for login
> SQLSETPROP(0,"DispLogin",3)
> 
> h = SQLSTRINGCONNECT(lcStringConn)
> 
> IF h > 0
>   WAIT WINDOW "System v0.1 is now Connected!" nowait
>   
> ELSE
> *   =AERROR(laError)
>    MESSAGEBOX("Error at Connecting"+chr(13)+"Please contact the Administrator to fix the error...",48," Pharmacy System V.01")
> *              "Description:"+laError[2])
> 				*quit
> ENDIF
> return
> 
> 

> it displays connection failed. What do you think I'm doing bad?
>
> Thanks in advance,
> joe

You should use the 32-bit ODBC driver.

http://www.digisoftph.com/

ENTIRE THREAD

ODBC Connector driver (64bit) Posted by joe Degorio @ 1/15/2014 1:48:27 AM
RE: ODBC Connector driver (64bit) Posted by Tom Saddul @ 1/15/2014 4:14:16 AM
RE: ODBC Connector driver (64bit) Posted by David Mustakim @ 1/15/2014 4:16:14 AM
RE: ODBC Connector driver (64bit) Posted by Dany Eid @ 1/17/2014 8:25:13 AM
RE: ODBC Connector driver (64bit) Posted by joe Degorio @ 1/18/2014 3:36:19 PM
RE: ODBC Connector driver (64bit) Posted by Cetin Basoz @ 1/17/2014 1:50:56 PM
RE: ODBC Connector driver (64bit) Posted by joe Degorio @ 1/18/2014 3:27:42 PM