in my ASP application I am using the following connection string to connect to a remotely located sql server database in our web server.
Expand|Select|Wrap|Line Numbers
- set cnNet = server.createobject("adodb.connection")
- cnNet.open "provider=SQLOLEDB.1;user id=xxx;password=yyy;Initial Catalog=dbName;data source=<IPAddress>"
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