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:[email protected]] 
Sent: 25 December 2010 15:49
To: 'Vic Spainhower'; [email protected]
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:[email protected]] 
Sent: Saturday, December 25, 2010 6:41 AM
To: [email protected]
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/[email protected]