Need help connecting to access database on web server.
this is an excerpt of the code from the results.htm file located from the root:
\gas_interface\results\results.htm

the database is located from the root:
\fpdb\gas.mdb

I need to get access to it using server.mapath() probably, but I am not sure. I know that the Jet.OLEDB 4.0 wants the data source= to be entered as a UNC path, but if i enter it for the webhosting server, it points it to my computer.

Here is the code:
==================================================
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Documents and Settings\Caley\Desktop\Gas\fpdb\gas.mdb;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
================================================
Caley

Try using Server.MapPath("\fpdb\gas.mdb"), that should work. Not sure what you mean by "but if i enter it for the webhosting server, it points it to my computer". How so?

Brian

I mean the exact server path is d:\website\69.68.25.82\gas\fpdb\gas.mdb, but this in IE will point to the d drive on my computer.... so I need code to change the:
==================================================
Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Documents and Settings\Caley\Desktop\Gas\fpdb\gas.mdb;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False
================================================
to something that will direct it to the local webhost server db.

Sub Session_OnStart
Dim sDB, sPath, sDSNDir, sDSNFil, sDefDir, sDSN, sScriptDir
    sDB = "database.mdb"
     sScriptDir = Request.ServerVariables("SCRIPT_NAME")
    sScriptDir = StrReverse(sScriptDir)
    sScriptDir = Mid(sScriptDir, InStr(1, sScriptDir, "/"))
    sScriptDir = StrReverse(sScriptDir)
    sPath = Server.MapPath(sScriptDir) & "\"
    sPath="C:\Database\"
    sDSN = "DBQ=" & sPath & sDB & ";Driver={Microsoft Access Driver (*.mdb)}"
    Session("Dataconn_ConnectionString") = sDSN
    Session("Dataconn_ConnectionTimeout") = 30
    Session("Dataconn_CommandTimeout") = 45
    Session("Dataconn_CursorLocation") = 3
    Session("Dataconn_RuntimeUserName") = ""
    Session("Dataconn_RuntimePassword") = ""

End Sub

surendran
(Anything is Possible)

You need to change d:\website\69.68.25.82\gas\fpdb\gas.mdb to \\servername\path... If you need to reference a drive on the server, i think you can do \\servername\d$, or something like that.

The pages are on the webhosting server. Is the database there as well? Is the database in a directory relative to the root of your web application? On my web host, they give me a data directory to put my MDB files in. So when I need to refer to the database file, I use Server.MapPath("/data/mydatabase.mdb"). Without knowing the exact physical file path of the host's server I can't explicitly tell the data provider where to get it. That what MapPath is for.

Hmm...well... it seems my webhosting company doesn't allow for data access pages because they pose a security threat. Guess I will have to do some workarounds...

Thanks for all the help guys... :)

Sounds like it's time to switch web hosts.