I'm having a problem connecting to my SQL server with an ASP connection string. Per a tip I read in this forum, I created a UDL file and created the connect string that way and the connection test successfully. However, when I try using that same string with ASP, I keep getting a Server Does Exist, or Access Denied error. Here's my connect string:

<%
Option Explicit
Dim strConnection, conn

strConnection = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=qdbreports;Initial Catalog=qdb;Data Source=myserver"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConnection

%>

Help! Any suggestions are greatly appreciated.

Dale

Try this:

Change myserver to the IP of the server if you are still getting the problem, it is possible that your User does not have rights to the qdb database.

Also, through enterprise manager, make sure that in your security tab you have Authentication setup as SQL Server and Windows.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

I changed the server to its IP, but still getting the same error. Also verified that the Authentication was set to SQL Server and Windows. If this is a user issue, why do the same credentials it work with the UDL file (asking out of complete ignorance)?

I am unfamiliar with an UDL file?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

If you create a blank notepad file and save it as a UDL file, then right-click, select properties and you can set up a connection to the databse. Then open the UDL file and copy the connection string.

Never heard of them nor have I used them. I am curious though, the code you pasted, does that code reside in a file by itself that you include on other pages?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

I just copied the code to my asp file.