By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,694 Members | 1,348 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,694 IT Pros & Developers. It's quick & easy.

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

P: n/a
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?
Nov 21 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Chreo,

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

I hope this helps,

Cor
Nov 21 '05 #2

P: n/a
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

Nov 21 '05 #3

P: n/a
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


Nov 21 '05 #4

P: n/a
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 :-(
Nov 21 '05 #5

P: n/a
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 :-(

Nov 21 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.