This topic is locked

SQL Server connection to DB

1/27/2007 1:13:52 PM
ASPRunnerPro General questions
author

I'm on the verge of a major breakthrough... Just had a friend help me connect to a MS SQL Server table on my desktop using ASPRunnerPro.
I build the application and generated the pages and uploaded them to my server.
Now: How do I connect to the database? Can I just upload it to my server and point to it with a connection string? I suppose that's too simple. Any advice?
the string is:
<%

strConnection = "DRIVER=SQL Native Client;SERVER=G-AEJAGOFBFGRRM\SQLEXPRESS;Trusted_Connection=Yes;APP=AspRunner Professional Application;WSID=G-AEJAGOFBFGRRM;DATABASE=35aSQL;"

%>

Alexey admin 1/29/2007

Hi,
yes, all you need is to change a connection string in include\dbconnection.asp file.