A
Aykut Canturk
Can I use SqlExpress2005 AttachDatabase feature with classic ADO connections
in my .asp pages ? But I need ConnectionString. Although I searched the web
for couple of weeks I still coulnd't find any solution.
anybody succeeded to use classic ado with attach feature without attaching
database filed from enterprise manager ? I want tou use SQL2005 and I don't
want directly attch files to sql.
Best regards...
<%
set cn = Server.CreateObject("ADODB.Connection")
' THIS ConnectionString IS WRONG of course. I need correct and working one
ConnectionString=
"Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=c:\db\mydbfile.mdf;Trusted_Connection=Yes;"
cn.open ConnectionString
..... database operations....
cn.execute sqlstr
cn.close
set cn = nothing
%>
in my .asp pages ? But I need ConnectionString. Although I searched the web
for couple of weeks I still coulnd't find any solution.
anybody succeeded to use classic ado with attach feature without attaching
database filed from enterprise manager ? I want tou use SQL2005 and I don't
want directly attch files to sql.
Best regards...
<%
set cn = Server.CreateObject("ADODB.Connection")
' THIS ConnectionString IS WRONG of course. I need correct and working one
ConnectionString=
"Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=c:\db\mydbfile.mdf;Trusted_Connection=Yes;"
cn.open ConnectionString
..... database operations....
cn.execute sqlstr
cn.close
set cn = nothing
%>