MSDE getting dumber and dumber

hog

hog

Well-known member
Joined
Mar 17, 2003
Messages
984
Location
UK
Here is the situation:

One PC with MSDE running but not the Windows 2000 server service.

Visual Studio .NET running on my laptop on the same network as the PC above.

Question: How do I create/connect to the PC from my laptop to create or connect to a database on the PC?

Ive have tried using Data Connections and SQL Servers within the .NET IDE with no joy. Is there some special way to do it?
 
Not sure this is what Im after, thanks. I already know how to connect to databases using a connection string, what I cant do is create a connection to the MSDE instance running on the PC from my laptop as .NET retports it cant find the PC on the network probably cos the server service is not running on it. But other posts say you do not need the server service running in ordero make use of MSDE
 
I can runn the MSDE ok on my laptop the problem I have is trying to connect to an instance of the MSDE running on another machine
 
Dont know if its any help but I came across this thread when searching for help on connecting to MSDE via the internet and I came up with the following connectionstring which worked but only on the default port of 1433.

"Network Library=DBMSSOCN;" _
& "Server=xxx.xxx.xxx.xxx\myMSDEInstance;" _
& "Initial Catalog=mydatabase;" _
& "User ID=myuserid;" _
& "Password=mypassword;"
 
Back
Top