Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Kayode Adeniyi
  Where is Kayode Adeniyi?
 Lagos
 Nigeria
 Kayode Adeniyi
 To: Doug Hennig
  Where is Doug Hennig?
 Winnipeg
 Canada
 Doug Hennig
 Tags
Subject: RE: MySQL ODBC Connector
Thread ID: 345600 Message ID: 345616 # Views: 46 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Windows 7 and VFP
Date: Friday, May 25, 2012 2:58:08 AM         
   


> 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



Dear Doug,

Please disregard my last response. Your solution had worked. Many thanks.

Best Regards,

Kayode

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