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

--
Ross Donald
..NET Code Generation - http://www.radsoftware.com.au/codegenerator

<dw******@uiuc.edu> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

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