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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL