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

[CroCrew]

Hello universe,

Try changing your connection from:

cnNet.open "provider=SQLOLEDB.1;

To

cnNet.Open " provider=SQLOLEDB;

I have never used the “.1” within my connection.

Let us know if that helped any~

[jhardman]

Have you turned off windows authentication by any chance? The mode of connection will definitely affect authentication, that would give you access denied.

Jared

[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