Connector 6.2.2 connection error with VS 2008
Posted by: Eldrick Trees
Date: April 06, 2010 03:06PM

I'm trying to use a SqlDataSource to connect to a Mysql db from VS 2008. I first got the error: SELECT command denied to user 'xxxxx' for table 'proc'. After reading up on a related thread, I added "Use Procedure Bodies=false" to my connection string. Then after trying to configure the SqlDataSource, I got this error:

Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and that the database is online.

Object reference not set to an instance of an object.
at VSDataObjectSupport(120,6)

Here's my connection string:

Server=192.168.10.1;User ID=root;Password=password;Database=mydb;Use Procedure Bodies=true;

Any ideas on why I'm getting this error?



Edited 1 time(s). Last edit at 04/06/2010 03:07PM by Eldrick Trees.

Options: ReplyQuote


Subject
Written By
Posted
Connector 6.2.2 connection error with VS 2008
April 06, 2010 03:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.