asp_database_setup thread: DSN-less Connection
Message #1 by "Chong" <c_huei_huei@h...> on Thu, 15 Mar 2001 06:42:18
|
|
I have upload a database onto my webserver. I had create this connection
string :
<%
strConnect = "provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source= c:\abc\abc.mdb;"&_
"Persist Security Info =False"
%>
However my database had upload onto this www....../xxx/abc.mdb. how should
I change to my connect string?
I had change my connect string as :
<%
strConnect = "provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source= http://www....../xxx/abc.mdb;"&_
"Persist Security Info =False"
%>
But can't work? Please help.
Thankx.
Chong
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 15 Mar 2001 18:46:03 +1100
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: I have upload a database onto my webserver. I had create
: this connection string :
:
: <%
: strConnect = "provider=Microsoft.Jet.OLEDB.4.0;" &_
: "Data Source= c:\abc\abc.mdb;"&_
: "Persist Security Info =False"
: %>
:
: However my database had upload onto this www....../xxx/abc.mdb. how should
: I change to my connect string?
:
: I had change my connect string as :
: <%
: strConnect = "provider=Microsoft.Jet.OLEDB.4.0;" &_
: "Data Source= http://www....../xxx/abc.mdb;"&_
: "Persist Security Info =False"
: %>
:
: But can't work? Please help.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.Mappath("/xxx/abc.mdb")
Cheers
Ken
|