sqlconnection question

[00eric claption]

I define the following code in a button click event:

Dim cn As New SqlConnection( _

"Server=(DBTEST\DBTEST;DataBase=pubs" _

& "Integrated Security=SSPI")

************************************************** *************************************************

I got this error when I trigger the button click event and error stop at the
code:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll

Additional information: Invalid delimiter = found in the connection option
value. "

************************************************** *************************************************

Can anyone please help me? Thanks.

[Cor Ligthert [MVP]]

Hi,

Your first opening ( is for sure wrong. Has not even to be there.

www.connectionstrings.com

I hope this helps,

Cor

"00eric claption" <[e-mail]> schreef in bericht
news:uw**************@TK2MSFTNGP11.phx.gbl...

I define the following code in a button click event:

Dim cn As New SqlConnection( _

"Server=(DBTEST\DBTEST;DataBase=pubs" _

& "Integrated Security=SSPI")

************************************************** *************************************************

I got this error when I trigger the button click event and error stop at
the code:

"An unhandled exception of type 'System.ArgumentException' occurred in
system.data.dll

Additional information: Invalid delimiter = found in the connection option
value. "

************************************************** *************************************************

Can anyone please help me? Thanks.

[Andrew Morton]

00eric claption wrote:

I define the following code in a button click event:
Dim cn As New SqlConnection( _
"Server=(DBTEST\DBTEST;DataBase=pubs" _
& "Integrated Security=SSPI")

You're missing a semi-colon between pubs and Integrated.

And as Cor pointed out, it's unlikely the server's name starts with (.

Andrew