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

make a little .vbs script and paste in the code (without the script tags). If it works this way, then your problem is related to the userid of the web site (it doesn't have admin access and you do). But please don't give that userid admin access, but rather find another solution.

If it doesn't work in a .vbs script you need to visit connectionstrings.com.

By the way, I think you have the wrong forum. This is an asp.net forum.

I'm not familiar with vbs, so I'm not sure what you mean. I'll move this to the ASP Classic forum (is that the correct forum?).

yes, that's the right forum. The name of the ASP Script language is "VBScript", and your program should have a .vbs extension if you're not using it in a web page. It's funny that some ASP coders have used it for years in web pages but they don't know they can run it stand-alone. Stand-alone is much easier, and you have a lot of Windows features that are much harder in a web page (like a MsgBox).

Make this file with Notepad, name it "connectTest.vbs", and then double-click on it from Explorer (watch out for line wrap):

--------
Dim strConnection, conn

strConnection = "Provider=SQLOLEDB.1;Password=xxx;Persist Security Info=True;User ID=qdbreports;Initial Catalog=qdb;Data Source=myserver"

' Remove the "Server." in front of CreateObject for use as a stand-alone pgm
Set conn = CreateObject("ADODB.Connection")
conn.Open strConnection

msgbox("it works")
------------------

If you see the "it works" message box, your string is good. If not, you'll see an error after the connect attempt times out. Then you need to modify your string and try again.