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?
U¿ytkownik "Cor Ligthert" <no************@planet.nl> napisa³ w wiadomo¶ci
news:eh*************@TK2MSFTNGP15.phx.gbl...

Chreo,

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

I hope this helps,

Cor

[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? :)
U¿ytkownik "chreo" <ch***@gazeta.pl> napisa³ w wiadomo¶ci
news:d5**********@inews.gazeta.pl...

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?
U¿ytkownik "Cor Ligthert" <no************@planet.nl> napisa³ w wiadomo¶ci
news:eh*************@TK2MSFTNGP15.phx.gbl...

Chreo,

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

I hope this helps,

Cor

[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 :-(

[M. Posseth]

what a strange connection string do you have

i use this

Private strMvarConnect As String =
"server=192.168.1.2;database=mydatabase;uid=john;p wd=doe;"

and this works flawless

in my situation ( SQL SERVER 2000 ENTERPRISE EDITION on a TCP network )

regards

the client only needs MDAC for this to function ( no sql tools or what so
ever )

M. Posseth [MCP Developer]




"chreo" <ch***@gazeta.pl> wrote in message
news:d5**********@inews.gazeta.pl...

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 :-(