connection string

[universe]

hi friends,

in my ASP application I am using the following connection string to connect to a remotely located sql server database in our web server.

 
                set cnNet = server.createobject("adodb.connection")
	cnNet.open "provider=SQLOLEDB.1;user id=xxx;password=yyy;Initial Catalog=dbName;data source=<IPAddress>"

when I am running this from my system using Dial-Up connection it works file. But when I had changed my dial-up to CCProxy I am getting the following Error.

Microsoft OLEDB Provider for SQL Server
[DBNETLIB][Connection Open (connect()).]SQL Server does not exist or Access Denied.

What is wrong with my connection string. When I am conecting using CCProxy what is to be Done ?

Thank u all,
kiran

[ck9663]

hi friends,

in my ASP application I am using the following connection string to connect to a remotely located sql server database in our web server.

 
                set cnNet = server.createobject("adodb.connection")
	cnNet.open "provider=SQLOLEDB.1;user id=xxx;password=yyy;Initial Catalog=dbName;data source=<IPAddress>"

when I am running this from my system using Dial-Up connection it works file. But when I had changed my dial-up to CCProxy I am getting the following Error.

Microsoft OLEDB Provider for SQL Server
[DBNETLIB][Connection Open (connect()).]SQL Server does not exist or Access Denied.

What is wrong with my connection string. When I am conecting using CCProxy what is to be Done ?

Thank u all,
kiran

check your IP. if you can not connect from other source using the same connection, that means you won't be able to with your ASP

-- ck

[universe]

I am using the same connection string from ASP to connect to the remote DataBase via Dial-Up Connection. Here it works fine.But recently we changed our Dial-up Internet Connection to a Proxy Connection. Since then I am facing the problem.

[OuTCasT]

I am using the same connection string from ASP to connect to the remote DataBase via Dial-Up Connection. Here it works fine.But recently we changed our Dial-up Internet Connection to a Proxy Connection. Since then I am facing the problem.

The proxy server obviously is blocking ur remote connection to the sql server, u need to run through your proxy servers ip add before connecting to the sql server. had the same problem.

[universe]

Partly I tracked the problem, first of all my proxy server is not pinging with my web server.
Actually we hav given internet connection from our local server to other systems using CCProxy (YoungzSoft's free ver, supports 3 users) . Our local server is able to connect to the web server (remotely located).
And here the thing is we don't hav permission to set the properties of our webserver. Only the possibility is to pass everything in the connection string so that it is able to connect to web server.

Thank u all,
Kiran

[nitindel]

your connection string seems to be fine but..the problem may be in the Proxy Server or IP...
Please check ur IP again


Thanks & Regards
Nitin Sharma
Software Engineer