Good Afternoon:
I am trying to use a normal ASP program with approximately 50 asp files. The setup file that uses a connection string to MS Access fails. Now after trying the simplest of *.asp file connections to the MS Access Northwind.mdb database, that fails too. I tried using DSN & DSN-less connections. Prior to the install of .Net Framework, these connections from an *.asp file to MS Access worked.
My computer has a windows 2000 OS, XP Office and Visual Studio.Net configuration. I believe I have checked the correct permissions in the file folders, Internet Management Services and IE 6.0 advance settings.
Has anyone else tried their asp programs after installing .NET and ran into this same issue? Please offer any suggestions and I will be happy to doublecheck my work and settings.
Here is a sample of the simplest ASP file I could find. I have used several connection string variations and Server.MapPath("") method. I can get these strings to work on a computer without .Net.
When the code hits cn.Open.... I get these two types of error messages.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'
OR: When using this string...
openStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\ Id=admin;Password=;"
I get the following error message:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/Test.asp, line 10
Thank you in advance for any help or advice you can give.
Smuckers
May your hysterical randomness be cured!
I am trying to use a normal ASP program with approximately 50 asp files. The setup file that uses a connection string to MS Access fails. Now after trying the simplest of *.asp file connections to the MS Access Northwind.mdb database, that fails too. I tried using DSN & DSN-less connections. Prior to the install of .Net Framework, these connections from an *.asp file to MS Access worked.
My computer has a windows 2000 OS, XP Office and Visual Studio.Net configuration. I believe I have checked the correct permissions in the file folders, Internet Management Services and IE 6.0 advance settings.
Has anyone else tried their asp programs after installing .NET and ran into this same issue? Please offer any suggestions and I will be happy to doublecheck my work and settings.
Here is a sample of the simplest ASP file I could find. I have used several connection string variations and Server.MapPath("") method. I can get these strings to work on a computer without .Net.
Code:
<html>
<head>
</head>
<body>
<p>
<%
openStr = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\inetpub\[URL unfurl="true"]wwwroot\Northwind.mdb;Uid=Admin;Pwd=;"[/URL]
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open openStrWhen the code hits cn.Open.... I get these two types of error messages.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'
OR: When using this string...
openStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\ Id=admin;Password=;"
I get the following error message:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/Test.asp, line 10
Thank you in advance for any help or advice you can give.
Smuckers
May your hysterical randomness be cured!
