How make an automatic dsn less connection

abhisheksud · October 4th, 2005, 01:37 AM

I have a microsot access database file which is stored in the same directory as rest of the website file...Now the current database connection is made specifying the full path of file..now when the file is uploaded on to the server the address changes and hence the connection is broken..could someone suggest a modification to this code which could make the connection automatic even if the website directory is moved...

StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
" Data Source = C:\Inetpub\IT Security\Security.mdb;" & _
" Persist Security Info=True"

Also if i want to make this file password protected how can i access that file automatically....

Thanks

Steven · October 5th, 2005, 05:57 PM

Use Server.MapPath
For example

Code:

StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ 
  "Data Source = " & Server.MapPath("Security.mdb") & ";" & _
  "Persist Security Info=True"

I am a loud man with a very large hat. This means I am in charge

abhisheksud · October 6th, 2005, 11:26 PM

Hi Steven
Thanks for the reply....earlier also i hv tried to use the server.MapPath command but then it used to give that end of statement expected...but on using your code it is giving error that "INVALID CHARACTER"....what could be the problem please help me out ...
Thnxs

happygv · October 7th, 2005, 04:51 AM

abhishek,

Can you post the exact error here along with the line number and which line it denotes in the code, etc...

Cheers.

_________________________
- Vijay G
Strive for Perfection