Groups | Blog | Home
all groups > dotnet compact framework > december 2007 >

dotnet compact framework : Database connectivity


deepak_ssoft@yahoo.co.in
12/19/2007 9:58:23 PM
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
Ginny Caughey [MVP]
12/20/2007 7:46:14 AM
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.

--
Ginny Caughey
Device Application Development MVP


[quoted text, click to view]
AddThis Social Bookmark Button