Why o why

[phrozeman]

Last week, i finally had my SQL server running, and i could connect to it, retrieve records, etc.
But 2 days later my whole system crashed, i lost all my partitions :/
So i reinstalled Win2K server + MSSQL 2000 server (same passes)

But now i cant connect to it anymore, i still use the same connection code as before:

Dim CN As New ADODB.Connection
CN.ConnectionString = "Driver=SQL SERVER;server=217.121.161.0\CC200392-B,1433;" & _
"Database=MB;User ID=testuser;Password=test"
CN.Open

This code works when i run it on the pc SQL is installed on, but why aint it work on an remote anymore?

[Grimfort]

Dont suppose you have changed the IP address ?

If you create a file on your desktop (remote pc) called

test.udl then open it you can create the string using the MS editor thing.

Then open the file in notepad and you can see the conneciton string, you can then see what the differences are.

[kleinma]

how is your network setup? a domain? or work group? it is probably something to do with your connection between machines