change string

[stevelibby]

hi all
how can i change this connection string:

<% dim dblocation

' Enter the location of the database below

dblocation = "..\private\fpdb\test.mdb"

%>

<%
Dim MM_test_STRING
MM_test_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\" & dblocation & "")
%>

to one that will connect to a mssql db?

[aspdaddy]

SQL is a little different depending on te security model, installation type and actual location of the SQL server, check out these example strings for info:

[carlprothman.net...]