2 computers (1-MsSQL, 2-VB.NET application) - doesn't work :-(

[chreo]

I have problem.
I have application which is connected to MS SQL base on my computer.
It works perfectly.

I tried to move application on other computer and it says that server
doesn't exist or acces denied :-(

http://img259.echo.cx/my.php?image=baza4qk.jpg

What is the best method to connect to SQL base with VB.NET Windows
Application using IP?

 

[Cor Ligthert]

Chreo,

Have a look at the top of this page SQLClient using IP
http://www.connectionstrings.com/

I hope this helps,

Cor

 

[chreo]

Great page!
but...
Still the same....server doesn't exist or access denied.

When I open Query analyzer it works when I give IP addres as SQL Serwer,
LOGIN and PASSWORD.

The same values are used in application:
Me.SqlConnection1.ConnectionString = "Data Source=62.179.xx.xx, 1433;
Network Library=DBMSSOCN; Initial Catalog=market; User ID=market;
Password=market;"

I don't know where is the problem - in database or application?
But database opens when I give that values...
So maybe something more to add in connection string?

 

[chreo]

Is it possible that i don't have DBMSSOCN.DLL?
I can't find It on my disc...
Is it part of MS SQL or .NET?
Where can I find it?

 

[chreo]

I found something:

Everywhere I see that I should use
DBMSSOCN.dll

But I have MS SQL 2000 and it uses: DBNETLIB.dll to TCP IP connections.

But I can't set Network Library to : DBNETLIB in VB.NET because it is not
valid value :-(