2. ASPRunnerPro General questions
  3. DNS-less connections
This topic is locked

DNS-less connections

 		10/27/2003 20:31:57
ASPRunnerPro General questions
author

Can you set up a dnsl-ess connection rather than have an OBDC DSN connnection to MS SQL database? If so, how. I tried but each time I get an error message, 2147217843 .
Richard
500065 10/30/2003

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
Sergey Kornilov admin 10/30/2003

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