Hi
I am using UD4 on a Windows 2000 box with IIS 5. I am creating some ASP pages using VBscipt. I have set up a site, defined the application server and URL Prefix.
The Problem
I have a page that pull out a few field from a database table. The page works fine when I use an ODBC connection however I want to use a Connection String which usues Server.Mappath it doesnt. I have created a new Custom Connection String in Ultradev setting it to "Using Drivers on Application Server" the connection string is:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=" + Server.Mappath("..\admin\data.mdb"
When I Test the connection in Ultradev the connection is successful. I can also create a recordset, however when I view the page in a browser I get the following error:
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.
/bht/test.asp, line 5
Line 5 is= rsTest.ActiveConnection = MM_myconn_STRING
Any help would be much appreciated
Thanks in advance
Indy
I am using UD4 on a Windows 2000 box with IIS 5. I am creating some ASP pages using VBscipt. I have set up a site, defined the application server and URL Prefix.
The Problem
I have a page that pull out a few field from a database table. The page works fine when I use an ODBC connection however I want to use a Connection String which usues Server.Mappath it doesnt. I have created a new Custom Connection String in Ultradev setting it to "Using Drivers on Application Server" the connection string is:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=" + Server.Mappath("..\admin\data.mdb"

When I Test the connection in Ultradev the connection is successful. I can also create a recordset, however when I view the page in a browser I get the following error:
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.
/bht/test.asp, line 5
Line 5 is= rsTest.ActiveConnection = MM_myconn_STRING
Any help would be much appreciated
Thanks in advance
Indy