Using odbc driver 5.1 on a Virtual Machine

"Vic Spainhower" <[email protected]> Sat, 25 Dec 2010 06:40:49 -0800
Newsgroups gmane.comp.db.mysql.odbc
Message-ID <00e701cba441$b9930280$2cb90780$@com>
I am trying to run a VB6 program on a Virtual machine in Windows 7  and it
seems the ODBC Driver is not supported, could this be true?   The first time
I tried it I got an error the data source name was not found and I installed
the 5.1 driver and  thengot this error when trying to connect.  I can run
this program on the Windows 7 machine without a problem.

 

 

This is the error I get: [MySQL][ODBC 5.1 Driver]Host 'VIRTUALXP-19744' is
not allowed to connect to this MySQL server

[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

 

Connection String: cn1 = "Driver={MySQL ODBC 5.1
Driver};Server=Vic-Win7;Database=spcc_oil and gas;User=***;
Password=*****;Option=3;"

 

 

Thanks for any ideas!

 

Vic