ADO.NET Error

[Vignesh]

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
"Vignesh" <Vi*****@discussions.microsoft.com> schreef in bericht
news:62**********************************@microsof t.com...

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

[Vignesh]

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

"Cor Ligthert [MVP]" wrote:

Vignesh,

Yes and?

Cor
"Vignesh" <Vi*****@discussions.microsoft.com> schreef in bericht
news:62**********************************@microsof t.com...

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

[Ken Tucker [MVP]]

Hi,

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

Ken
--------------------

"Vignesh" wrote:

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

[Vignesh]

Hi,

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

"Ken Tucker [MVP]" wrote:

Hi,

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

Ken
--------------------

"Vignesh" wrote:

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

[marcmc]

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.

"Vignesh" wrote:

Hi,

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

"Ken Tucker [MVP]" wrote:

Hi,

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

Ken
--------------------

"Vignesh" wrote:

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

[marcmc]

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

"Vignesh" wrote:

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

[Vignesh]

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
"marcmc" wrote:

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

"Vignesh" wrote:

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

[marcmc]

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/art...p?p=26956&rl=1
"Vignesh" wrote:

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
"marcmc" wrote:

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

"Vignesh" wrote:

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

[Vignesh]

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

"marcmc" wrote:

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/art...p?p=26956&rl=1
"Vignesh" wrote:

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
"marcmc" wrote:

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

"Vignesh" wrote:

> 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