Generate Dataset: retrieving schema failed

[dwlawren]

Hi,

I get the following error: "Retrieving the schema for
MyOleDbDataAdapter failed. The connection string is invalid."

I get this error when I:
1) In Visual Studio 2003, I right click (in design view) the
dataAdapter and choose Generate Dataset.

2) The DataAdpater's OleDbConnection connectionString : under
DynamicProperties ->ConnectionString is refering to a <appSettings> in
the Web.config.

I rebuilt my solution/dataAdapters/datasets and still get the same
problem.

I do have a work around: the problem goes away when I click on any
textbox property field (in design view) of the dataAdapter.
Thanks
--Dietrich

 

[Ross Donald]

I guess your database is MySQL. Which OLEDB provider are you using?

I have found that using MySQL through OLEDB does not seem work very well (at
least with the providers I have tried).