|
-
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:
FUNCTION IsAdministrator()
DIM Connection
DIM sqlAdmin, RsAdmin
set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open ConnectionStr
sqlAdmin = "Select [Client_Name] From [Client] Where " & mClient_num & "
= [Client_num]"
set RsAdmin = Connection.Execute(sqlAdmin)
IF RsAdmin("Client_Name") = "ADMIN" THEN
IsAdministrator = "TRUE"
ELSE
IsAdministrator = "FALSE"
END IF
Connection.Close
SET Connection = NOTHING
END FUNCTION
The Error message:
Error Type:
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
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
|
Bookmarks