Generate Dataset: retrieving schema failed

  • Thread starter Thread starter dwlawren
  • Start date Start date
D

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
 
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).
 
Back
Top