OLEDB Provider was not specified in the connection string
Posted: Tue 22 Mar 2005 00:18
I'm trying to connect to a MySQL database on a Linux system so I can retrieve data for a ComponentOne C1Report control in my VB.NET program. However, I keep getting the following error message:
"Cannot get schema for this connection because:
An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'."
What would the provider be for MySQLDirect.NET?
Also, I was told by their tech support the following below regarding the ComponentOne C1Report control:
"Another thing to note is that currently, ComponentOne's C1Report uses an OleDbConnection internally, to get the schema and data. This allows it to handle Access and all Sql data providers. However, the OleDb data classes do not support ODBC, so you cannot use DSNs in connection strings."
"Cannot get schema for this connection because:
An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'."
What would the provider be for MySQLDirect.NET?
Also, I was told by their tech support the following below regarding the ComponentOne C1Report control:
"Another thing to note is that currently, ComponentOne's C1Report uses an OleDbConnection internally, to get the schema and data. This allows it to handle Access and all Sql data providers. However, the OleDb data classes do not support ODBC, so you cannot use DSNs in connection strings."