Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: joe Degorio
  Where is joe Degorio?
 Tacloban City
 Philippines
 joe Degorio
 Tags
Subject: ODBC Connector driver (64bit)
Thread ID: 395445 Message ID: 395445 # Views: 76 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Wednesday, January 15, 2014 1:48:27 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

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