×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

VFP 9 doesn't connect to MySQL on Win Server 2012 R2 64 bit through ODBC 8.0 32 bit version

VFP 9 doesn't connect to MySQL on Win Server 2012 R2 64 bit through ODBC 8.0 32 bit version

VFP 9 doesn't connect to MySQL on Win Server 2012 R2 64 bit through ODBC 8.0 32 bit version

(OP)
Hi Team,

I have already searched many threads here concerning MySql connection and tried the suggestions also but I am not getting my connection through. So, apologies for creating this, one more thread on same subject.

1. MySql is installed as a part of installation of a Finger Print machine's Web UI. This is in Windows Server 2012 R2 in Azure. My interface is running and data also is updated from devices at remote locations in MySql smoothly.

2. When I check MySql from command line (after running MySql -h localhost -u root), I can query database names, tables of a database etc.

3. I have installed MySql ODBC 8.0 32 bit version downloaded from MySql website in the same machine.
(Had installed the 64 bit version earlier but when I had this connection problem, installed the 32 bit version)

4. Now, from the same machine, I am trying to connect to MySql from VFP9 using

CODE -->

hnd = SQLSTRINGCONNECT("driver={MySQL ODBC 8.0 Driver};server=localhost;uid=root;database=adms_db;") 
But, it gives me -1 in hnd and the AERROR() shows, "[Microsoft][ODBC Driver Manager]Data Source name not found and no default driver specified"

My checking with 127.0.0.1 also failed. There is no password for user 'root'.

So, what I am missing or wrong I am doing?
I don't think MySql need to be configured for Remote access. Otherwise also, I have read that by default MySql allows remotes.

Could you guide me, please ?
Thanks in advance,
Rajesh

RE: VFP 9 doesn't connect to MySQL on Win Server 2012 R2 64 bit through ODBC 8.0 32 bit version

(OP)
Dear all,

The problem in the Azure server is solved for local connection!

I checked with installation of ODBC 8.0 both 64 & 32 bit versions. But it was not working. Then I uninstalled everything and installed the ODBC 5.1.13 (it shows as 5.1) 32 bit version and the following connection string did the job.

CODE -->

SQLSTRINGCONNECT('Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;User=root;Database=adms_db;Port=83306;') 

However, I am not able to access it from my system (ie connect remotely) using the same method, it doesn't work!

Any clue/suggestions?

Thanks
Rajesh

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close