i want to change the database from access to SQL Server Management Studio Express
the old connection string in the asp is
<%
Set strConn = Server.CreateObject("Adodb.Connection")
Provider="provider=microsoft.jet.oledb.4.0;"
dbpath="data source=" & Server.MapPath("../data.mdb")
Pwd = ";jet oledb:database password=dolunlimit"
strConn.open provider & dbpath & Pwd
%>
i have write the new connection in the SQL server, but it can not work
<%
Set conn=CreateObject ("adodb.connection")
strConn="driver={SQL Server};server=192.168.0.102;uid=sa;Pwd=sa;database=sadb"
conn.open strConn
Set rs=CreateObject("adodb.recordset")
%>
can someone tell me what wrong of my coding
Tryhttp://www.connectionstrings.com for connection string help. Also, these forums are for ASP.NET-related questions, not classic ASP.
No comments:
Post a Comment