DNS-less connections

Why don't you use mappath? Here is a sample using Access but I am under the impression that it would be the same or at least similar. That way all you have to do is change the folder name and database name.
<%

strConnection = "Provider=MSDataShape;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("folder\database.mdb") & ";UID=;PWD="

%>
I hope this helps,

Bandit

Richard,
here is the sample DSN-less connection to MS SQL created by ASPRunner.
strConnection = "Provider=MSDataShape;DRIVER=SQL Server;SERVER=NOTEBOOK;UID=sa;PWD=sa;APP=AspRunner Application;WSID=NOTEBOOK;DATABASE=Northwind"
Do not use "Trusted connection", enter userid and password explicitly. Also your SQL server should be configured for mixed security mode.
Read this article for more information:

http://www.xlinesoft.com/asprunner/faq.htm#loginfailed
Best reagrds,

Sergey Kornilov