Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Doug Hennig
  Where is Doug Hennig?
 Winnipeg
 Canada
 Doug Hennig
 To: Kayode Adeniyi
  Where is Kayode Adeniyi?
 Lagos
 Nigeria
 Kayode Adeniyi
 Tags
Subject: RE: MySQL ODBC Connector
Thread ID: 345600 Message ID: 345603 # Views: 61 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Windows 7 and VFP
Date: Thursday, May 24, 2012 8:57:42 PM         
   


Hi Kayode.

> I have a Win 7 PC. Installed on it is VFP 9 SP2. Also, I recently installed MySQL 5.5. When I installed MySQL ODBC connector 64-bit 5.1.11, I am unable to connect to MySQL from VFP. I attempted to connect by issuing (? sqlconnect 'wisedata') where 'wisedata' is the DSN name. I received the -1 response.

Did you use the default ODBC administrator to create the DSN? If so, that's the 64-bit one, so VFP can't see the DSN. Instead, use C:\Windows\SysWOW64\odbcad32.exe to create the DSN.

If that doesn't resolve the problem, use AERROR() after SQLCONNECT() to see what the problem is.

Doug

ENTIRE THREAD

MySQL ODBC Connector Posted by Kayode Adeniyi @ 5/24/2012 7:49:04 PM
RE: MySQL ODBC Connector Posted by Doug Hennig @ 5/24/2012 8:57:42 PM
RE: MySQL ODBC Connector Posted by Kayode Adeniyi @ 5/25/2012 1:15:08 AM
RE: MySQL ODBC Connector Posted by Kayode Adeniyi @ 5/25/2012 2:58:08 AM