Connection to SqlServer

  • Thread starter Thread starter Zanna
  • Start date Start date
Z

Zanna

Hi,

Someone knows why when I do for the first time a SqlConnection.Open in my
app I got the exception of SQL server not found?

Then I retry the Open and all works...

What's happening?

Thanks
 
William said:
Does this happen all of the time? If so, please post the code, this sound
peculiar indeed.
Click to expand...

Yes, quite always.

Simply the SqlConnection fails the .Open() the first and sometimes also
the second time.

The connection string is a simply with server name, db name, user id,
password and I put also a time-out of 15 secs.

Tomorrow I will test if this is too few for the first connection, but I
have some dubts :(

Thanks!
 
William said:
Definitely post the CS - someone else is having a problem connection to SQL
Server but I haven't experienced this problem, very curious about it though.
Click to expand...

Protected dbSql As System.Data.IDbConnection
Private connectionString As String = "Server=MyServer;DataBase=MyDB;User
ID=sa;Password="
....
dbSql = New System.Data.SqlClient.SqlConnection(connectionString)
dbSql.Open() ' here fails with the SqlException "Server SQL not found"
 
I would suspect you have a network problem.
Try pinging server by name from device and see if it works all the time.
You can use this utility: http://www.cam.com/vxutil_pers.html

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
 
Ilya said:
I would suspect you have a network problem.
Try pinging server by name from device and see if it works all the time.
You can use this utility: http://www.cam.com/vxutil_pers.html
Click to expand...

I think I found the problem (please don't beat me :) it's not my fault)

If I do it on the winCE 4.1 emulator I got the problem (it's like if
others app that uses TCP-IP such as e-mail clients or so intherfere with
the emulator)

If I do it on the device all sims ok.

I hope this will help someone else.

Thanks
 
Back
Top