problem accessing mdb via asp/js on new server
had a web application accessing a .mdb on one server (running 2000) that works
fine...set up a new server and moved the .mdb there, reconfigured the DSN,
but things are dead.
The code where its dying, the Connection.Open statement:
DIM sqlAdmin, RsAdmin
set Connection = Server.CreateObject("ADODB.Connection")
sqlAdmin = "Select [Client_Name] From [Client] Where " & mClient_num & "
set RsAdmin = Connection.Execute(sqlAdmin)
IF RsAdmin("Client_Name") = "ADMIN" THEN
IsAdministrator = "TRUE"
IsAdministrator = "FALSE"
SET Connection = NOTHING
The Error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path.
Make sure that the path name is spelled correctly and that you are connected
to the server on which the file resides.
/eTRACK/SelectFile.asp, line 109
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center