Using odbc driver 5.1 on a Virtual Machine

------=_NextPart_000_00E8_01CBA3FE.AB6FC280
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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




------=_NextPart_000_00E8_01CBA3FE.AB6FC280--

RE: Using odbc driver 5.1 on a Virtual Machine

I think the problem is that I need to grant privileges and I've tried
issueing the following command from a MySQL command prompt:

Grant all privileges on *.* to vic@% identified by password (where password
is replaced with my actual password)

When doing this I'm not receiving any kind of confirmation it just display
-> and the only way out is a control/break

What am I doing wrong?


Thanks,

Vic


-----Original Message-----
From: Vic Spainhower [mailto:vic@perfected.com]
Sent: Saturday, December 25, 2010 6:41 AM
To: myodbc@lists.mysql.com
Subject: Using odbc driver 5.1 on a Virtual Machine

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





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Using odbc driver 5.1 on a Virtual Machine

Sounds like you're missing a semi-colon on the end...

Al


-----Original Message-----
From: Vic Spainhower [mailto:vic@perfected.com]
Sent: 25 December 2010 15:49
To: 'Vic Spainhower'; myodbc@lists.mysql.com
Subject: RE: Using odbc driver 5.1 on a Virtual Machine

I think the problem is that I need to grant privileges and I've tried
issueing the following command from a MySQL command prompt:

Grant all privileges on *.* to vic@% identified by password (where password
is replaced with my actual password)

When doing this I'm not receiving any kind of confirmation it just display
-> and the only way out is a control/break

What am I doing wrong?


Thanks,

Vic


-----Original Message-----
From: Vic Spainhower [mailto:vic@perfected.com]
Sent: Saturday, December 25, 2010 6:41 AM
To: myodbc@lists.mysql.com
Subject: Using odbc driver 5.1 on a Virtual Machine

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







--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org