View Single Post
  #10 (permalink)  
Old August 21st, 2003, 11:11 AM
kyootepuffy kyootepuffy is offline
Authorized User
 
Join Date: Aug 2003
Location: , , .
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

AHhhh.. i finally figured it out. I used this connection string on a server that processes ASP pages and it finally worked.


strConnect="DBQ=" & Server.Mappath("scservices.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"

Thanks guys.

1. Okay let me get this straight... When i do my site locally I use this: <
% strConnect = Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\sbdc.mdb;Persist Security Info=False %>

2. And when my database is on a hosting server the string should be this:
strConnect="DBQ=" & Server.Mappath("scservices.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};"

3. So whats this for????
'strConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=database/list.mdb"

4. I can also connect using a DSN right, but i need the admin to set that up for me?

Reply With Quote