connection timeout problem

[Anti-Rich]

hi,

i was wondering if anyone could explain how to fix this problem for me. im creating an application which is verifying a connection... now ive changed the Connection Timeout (within ConnectionString) to 5, and later on 1 as i was getting desperate. but it still doesnt seem to work, it takes FOREVER for it to respond...

here is the string i am using (the part in bold is where i think something is wrong)

ConnectionString = _
"packet size=4096;" & _
"user id=theusername;password=thepassword;" & _
"data source=" & webserver & _
";persist security info=false;Connection Timeout=1;initial catalog=RowingDB"

any help would be much appreciated
cheers
adam

 

[ManicCW]

I think here is the problem:

"data source=" & webserver & _

 

[Anti-Rich]

whats wrong with it? i need to do it that way because im grabbing the webserver from an xml file. if you could elaborate it would be great

cheers
adam