Friday, February 24, 2012

connection string in the SQL Server Management Studio Express

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