IIS, ODBC, MDAC incompatibility?
From: Stan (NoSpam_at_I)
Date: 05/17/04
- Next message: Kent Milligan: "Re: ODBC driver for DB2 and AS/400"
- Previous message: Julie: "I can't seem to catch an ODBC Call Failed from Access Application"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 16:49:37 -0400
We have some simple ASP web sites on an IIS5 server that connect to MS
Access databases. The databases are local to the IIS server and are mostly
accessed for read-only purposes. Some of the sites use ODBC; the rest use
OLE DB.
While migrating these web sites to an IIS6 server, we noticed bizarre
connection errors. Microsoft support recommend against using IIS with Access
databases altogether, but said that OLE DB is much more stable than ODBC in
this scenario. Our testing revealed the same thing, so we had our users
convert their sites to use OLE DB. Of course, this eliminated the need for
DSNs for these connections.
I've been asked why ODBC worked fine with Access databases when on the IIS5
server, but not at all when on the IIS6 server. Microsoft support couldn't
answer that question. Does anyone know? Could it be attributable to
differing versions of MDAC on the servers? What part does MDAC play in
accessing an Access database using ODBC, anyway? Thanks!
- Next message: Kent Milligan: "Re: ODBC driver for DB2 and AS/400"
- Previous message: Julie: "I can't seem to catch an ODBC Call Failed from Access Application"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
