MSDE getting dumber and dumber

[hog]

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?

 

I've have tried using Data Connections and SQL Servers within the .NET IDE with no joy. Is there some special way to do it?

[jfackler]

Hog,

 

If you come to some conclusion on this, please post it.

 

http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm

 

Is a source whose instructions I've experimented with (specifically tcp/ip connection) but I can't

make it work.

[hog]

Not sure this is what I'm after, thanks. I already know how to connect to databases using a connection string, what I can't do is create a connection to the MSDE instance running on the PC from my laptop as .NET retports it can't 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

[jfackler]

I've got server service running on my laptop and I still can't access the msde.

[hog]

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

[Shandy]

Don't know if it's 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;"