2. ASPRunnerPro General questions
  3. DSN and DSNless connection
This topic is locked

DSN and DSNless connection

 		6/3/2009 12:49:50 PM
ASPRunnerPro General questions
S
 stevecrowther author

Hi
Link to database file on my PC (for development) but need to us a DSN or DSNless connection on the web server. How can I tell ASP Runner Pro 6.1 how to handle this.
Is there a page that explains?
Many thanks
C
 		clig 6/3/2009

I just edit the source include dbconnection.asp depending on what I need:
<%

strConnection = "Provider=SQLNCLI;Server=ONAPP013\NTSSVII,1776;Database=TNS_Support;Uid=user;Pwd=pwd;MarsConn=yes;"

' strConnection = "Provider=sqloledb;Data Source=ONAPP013\NTSSVII;Initial Catalog=TNS_Support;User Id=user;Password=pwd;"

' strConnection = "##@BUILDER.strConnectionString##"

%>
or edit it directly after building files...
S
 		stevecrowther author 6/4/2009

I just edit the source include dbconnection.asp depending on what I need:

<%

strConnection = "Provider=SQLNCLI;Server=ONAPP013\NTSSVII,1776;Database=TNS_Support;Uid=user;Pwd=pwd;MarsConn=yes;"

' strConnection = "Provider=sqloledb;Data Source=ONAPP013\NTSSVII;Initial Catalog=TNS_Support;User Id=user;Password=pwd;"

' strConnection = "##@BUILDER.strConnectionString##"

%>
or edit it directly after building files...


Hi
I use this string with DMXready Secure Login Manger -
MM_secureloginmanager_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\websites\myuname\data\mydb.mdb;"

and

MM_secureloginmanager_STRING = "dsn=myunamemydb;"
So, would ASP Runner 6.1 be -
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\websites\myuname\data\mydb.mdb;"

and

strConnection = "dsn=myunamemydb;"
Thanks
SGC
S
 		stevecrowther author 6/7/2009

Hello
Anybody there?
Please
SGC
Sergey Kornilov admin 6/7/2009

You need to open a support ticket for questions like this.