Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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






  Return to Index