Database connectivity

D

deepak_ssoft

Rspected sir,

I am using Sql Server 2005 Enterprise Edition with VB.Net
2003, but I am not able to connect it . Please will you give me the
code for connecting it.

Thanx and regards
Deepak
20th December
 
G

Ginny Caughey [MVP]

Deepak,

The most common cause of connection problems is that the SQL Server doesn't
have tcp/ip enabled. Assuming you're attempting to connect from a device and
not a desktop computer, ifyou're using integrated security, you must also
provide the user credentials and password in the connection string unlike on
the desktop. And since most devices can't resolve the name of a host, you
need to use the ip address of the SQL Server rather than its name.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top