List:MySQL ODBC« Previous MessageNext Message »
From:Al McNicoll Date:January 5 2011 9:59am
Subject:RE: Using odbc driver 5.1 on a Virtual Machine
View as plain text  
Sounds like you're missing a semi-colon on the end...

Al


-----Original Message-----
From: Vic Spainhower [mailto:vic@stripped] 
Sent: 25 December 2010 15:49
To: 'Vic Spainhower'; myodbc@stripped
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@stripped] 
Sent: Saturday, December 25, 2010 6:41 AM
To: myodbc@stripped
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

 




Thread
Using odbc driver 5.1 on a Virtual MachineVic Spainhower25 Dec
  • RE: Using odbc driver 5.1 on a Virtual MachineVic Spainhower25 Dec
    • RE: Using odbc driver 5.1 on a Virtual MachineAl McNicoll5 Jan