Greetings.

I have a Visual Studio.NET Solution with a bunch of VB.NET and C# data
access components. I'm seeing very weird behavior with the Properties viewer
of the System.Data.SqlClient.SqlDataAdapter.

When I expand SelectCommand, the first time I click the "..." next to
CommandText, I get a "The Connection String is Invalid" message box.
Subsequent clicks of the "..." result in ... a brief screen flash, then
nothing.

The Connection is set to a valid, SQL Server Authentication connection
string. The SqlDataAdapter works to get data when I test the project on my
dev system (the same system on which I'm running VS.NET).

Has anyone else seen this? I'm coming up empty on Google.

Regards,

Jonathan

Well, it turns out the sqloledb.dll somehow got... deleted... on my system.
(For the boring details, see
http://kerblog.com/earlyedition/arch...9/16/172.aspx).

I have no idea where it went, or why reinstalling SQL Server client tools,
or MDAC, or Windows 2000 SP4 didn't fix this... grr...

"Jonathan Levine" wrote:

I use the msjet provider in my oledbconnection and have a simalar
problem. Everything okay, until I close and reopen the project. After
reopening I get errors when using the connection because the
connectionstring "is invalid". Cut and paste the connectionstring in
the oledbconnection object is enough to get it started again... Can't
explain why yet; looks like a bug to me but when I find out I'll let
you know

Jonathan Levine <myfoo (AT) nospam (DOT) nospam> wrote

"TheAd" wrote:
You know, I still get the "is invalid" error the first time I try to edit
the query. But now that I've fixed the OLE DB problem, subsequent times it
works fine.