|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ADO.NET ErrorHi,
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,
Yes and? Cor Show quoteHide quote "Vignesh" <Vign***@discussions.microsoft.com> schreef in bericht news:620FE2D8-4C2A-42DB-BFFD-282C0A075CD0@microsoft.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 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 Show quoteHide quote "Cor Ligthert [MVP]" wrote: > Vignesh, > > Yes and? > > Cor > "Vignesh" <Vign***@discussions.microsoft.com> schreef in bericht > news:620FE2D8-4C2A-42DB-BFFD-282C0A075CD0@microsoft.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 > > > Hi,
Maybe there is a problem with the connection pool. Try adding pooling='false' to the connectionstring. Ken -------------------- Show quoteHide quote "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 Hi,
I tried connection pooling false also. but i didnt work. Show quoteHide quote "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 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. Show quoteHide quote "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 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 Show quoteHide quote "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 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 Show quoteHide quote "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 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 Show quoteHide quote "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 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 Show quoteHide quote "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/article.asp?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 
Other interesting topics
eventlog monitoring
indirectly setting a property of a class Setting focus File difference algorithm Not inheriting members from the base force next iteration in for...next Strongly typed datasets and web services excel range: how to tell it to move one row down? Visual Basic Hang How many jobs are waiting in the printer's queue |
|||||||||||||||||||||||
