Error Opening ODBC Connection from ASP Application

Error Opening ODBC Connection from ASP Application

Post by U3RldmUgUG » Fri, 16 Dec 2005 03:20:35


I have an application which opens an Access mdb database in an asp
application. It is working on an existing Win 2k server. I am trying to
migrate it to a Windows 2003 server and I am getting the following error
Message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Internal OLE Automation error

The source code is as follows:
Set propdata = Server.CreateObject("ADODB.Recordset")
propdata.ActiveConnection = "aSystemDSN"
propdata.Source = queryString
propdata.CursorType = 0
propdata.CursorLocation = 2
propdata.LockType = 1
propdata.Open()

The dsn is configured.

I have installed MDAC 2.8 on the system

Any and all help will be appreciated.
--
Thanks,
Steve
 
 
 

1. Advanced Server 7 ODBC error - [DataDirect][ODBC SequeLink driver][SequeLink Client]TCP/IP error, connection refused

2. Error with ASP.NET opening OleDb/ODBC database

Hi there,

I got a problem using an MS Access database through ASP.NET.

After updating my system from .NET Framework 1.0 to 1.1, my existing
application gives me the following error when opening a connection
with the code below:

"Unspecified error" (ErrorCode: -2147467259)

string connectionStringKey = "LocalDBConnectionString";
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\InetPub\wwwroot\IS_Italy_2003\IS.mdb";

OdbcConnection connection = new OdbcConnection(connectionString);
try
{
connection.Open();
}
catch (OdbcException ex)
{
string error = ex.Message;
}
finally
{
connection.Close();
}

What's really strange is that:
1. The same application works on some of my colleagues' computers with
the .net Framework 1.1
2. The very same code works on my computer when creating a brand new
application with VS.NET 2003
3. The same application was working with .NET Framework 1.0

The same thing happens (including the two cases above) when using ODBC
classes instead of OleDB ones. In this case the connection string is:

"FIL=MS Access;DSN=AIS_Local"

and the error is:

"ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Disk or
network error.\r\nERROR [IM006] [Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed\r\nERROR [HY000] [Microsoft][ODBC
Microsoft Access Driver] Disk or network error."

Need HELP!!!
tks

3. ODBC error when opening a connection.

4. Registry access error when try to open a odbc connection!!

5. ODBC Error 3151 on conection of MYSql ODBC Connection

6. Receiving SocketSSL connection from ASP or ASP.net application

7. Opening Excel from an ASP file (VB works, ASP gets ASP 0178 error)

8. connection failed errors trying to set up a ODBC connection

9. Using Connection Class VS Connection Module in Asp.net Application

10. Migrate ASP application from Win2000 to Win2003 but ADO connection error!!!

11. Connection to remote COM object works in Windows Forms application but not in ASP.NET application