Connection Problem

Hello, using the VS.Net to configure my dataAdapter, Dataset and connection
with the intent of using the "connection string" generated to build my own
dataset, dataAdapter and connection.

Using the IDE, I am able to successfully preview the data extracted just
fine, so I know that I must have a good connection string.

I cut and paste that connection string into my program, but when I run, it
tries to use my internet connection to find the server and then generates
and exception saying that "SQL Server does not exist or access denied.".
How can this be? My server is local on my machine, why would it be trying
to go out on the internet to resolve the address? Here is my connection
string that I paster in....

data source=fred\vsdotnet;initial
catalog=SkatingResults;password=XXXX;persist security info=True;user
id=YYYYYYY;workstation id=FRED;packet size=4096

Miha
Sat Dec 20 15:43:43 CST 2003

Hi Jim,

Try omitting data source and see what happens.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Jim Heavey" <JimHeavey@nospam.com> wrote in message
news:Xns94579A60FB2C8JimHeaveyhotmailcom@207.46.248.16...
> Hello, using the VS.Net to configure my dataAdapter, Dataset and
connection
> with the intent of using the "connection string" generated to build my own
> dataset, dataAdapter and connection.
>
> Using the IDE, I am able to successfully preview the data extracted just
> fine, so I know that I must have a good connection string.
>
> I cut and paste that connection string into my program, but when I run, it
> tries to use my internet connection to find the server and then generates
> and exception saying that "SQL Server does not exist or access denied.".
> How can this be? My server is local on my machine, why would it be trying
> to go out on the internet to resolve the address? Here is my connection
> string that I paster in....
>
> data source=fred\vsdotnet;initial
> catalog=SkatingResults;password=XXXX;persist security info=True;user
> id=YYYYYYY;workstation id=FRED;packet size=4096

Jim
Sat Dec 20 16:59:58 CST 2003


Now that give me an exception when I instatiate the SqlCommand object.

Jim
Sat Dec 20 23:03:03 CST 2003

Jim Heavey <JimHeavey@nospam.com> wrote in
news:Xns9457ACEED2FADJimHeaveyhotmailcom@207.46.248.16:

>
> Now that give me an exception when I instatiate the SqlCommand object.
>
>

The problem appears to be that my connection string has a "\" in the
string. I changed this to "\\" and then it worked just fine.