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
[quoted text, click to view] Jonathan Levine <myfoo@nospam.nospam> wrote in message news:<7C6E5572-246C-4424-96E4-BB6C64124346@microsoft.com>...
> 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,
>
[quoted text, click to view] "TheAd" 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
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
