ADO.NET Error

[Guest]

Hi,

Iam having a windows form which connects to SQL Server 2000 database which
is in local network.This Works fine. Iam using framework 1.1. I have SQL
Server Database which is in outside our network. when i ping this machine it
pings and works fine. when i try to connect the remote machine it gives
"General Network Error".

I have VB application which connects to the remote machine perfectly.Visual
studio 2005 also works fine. but only 2003 with framework1.1. is not
connecting.

Thanks in advance.
Vignesh

 

[Cor Ligthert [MVP]]

Vignesh,

Yes and?

Cor

 

[Guest]

My application use VS 2003 and framework1.1. I want to connect to the remote
database. how will i be able to do it. b'coz my old VB app and works fine. Do
you need any other information.

Regards
Vignesh

 

[Guest]

Hi,

Maybe there is a problem with the connection pool. Try adding
pooling='false' to the connectionstring.

Ken

 

[Guest]

Hi,

I tried connection pooling false also. but i didnt work.

 

[Guest]

Ahoy,
This seems to be a problem i have encountered in the 'SQLConnection' Thread
above. I have encountered it and so have many of my colleagues yet solutions
are few and far between on the web and in forums.

 

[Guest]

Vignesh

How did you set up your connection string?
Did you use the GUI or code it?

If the former, then you must ensure that when it says that your password is
viewable in the assembly and code, you choose Include Password.

It defaults to Don't include password which i chose thinking that it would
star out my password but oh no, it literally does NOT use it....strange
because how else are you meant to connect!!!!

I hope this works for you

 

[Guest]

Hi,

We tried both GUI and code. When i tried to give thi statement

"SQLConnection.Open" then it gives the error.


iam pasting the code below. Almost i tried all the possibilities.


Dim con As New SqlConnection
Dim str As String

'str = "Provider=sqloledb.1; User Id=maxmillion; Password=peabody;
Database=insurance; Data Source=maxins-vcovan;"

str = "pooling=false; User Id=sa; Password=activemax; Initial
Catalog=insurance; Data Source=maxins-vcovan;"

'max pool size = 7500;

'Connect Timeout=200; pooling='true'; Max Pool Size=200

'Network Library=DBMSSOCN;Connect Timeout=200;Trusted_connection = false;
con.ConnectionString = str
con.Open()


"The Commented lines are the various possibilities we tried".

Regards
Vignesh

 

[Guest]

follow the gui bit as follows on a new form. to it exactly in the steps here.
but remember to choose include password when setting the new connection.


http://www.informit.com/articles/article.asp?p=26956&rl=1

 

[Guest]

This Solution is also not working. Is the Framework 1.1 has this problem. Can
you suggest where to get the Latest patch or Service packs for framework1.1.


Regards
Vignesh