ADO and Oracle

From: Zoerrer Helmut <dummy_at_nowhere.com>
Date: Fri, 24 Jul 1998 12:43:50 GMT
Message-ID: <35b87ef9.14228639@news.Austria.EU.net>

Hello,

I've developed an ASP-application on MS-IIS. The database used ist MS-Access.
Now my boss wants this to be replaced by an oracle-db. So i'd to learn administering Oracle 8.0.4. (oh god, enterprise manger ....)
I imported the ms-access-db within oracle and tryed to let my application work with the oracle-db instead of ms-access. Now the point comes to the ODBC-driver. There are a few of possibilites:
* Use the ODBC-driver from Oracle (Version 8.0.4.4 from download-site
NOT from 8.0.4 enterpsise edition this one doesnt's work with ADO)
* use the ODBC-driver from Microsoft (from MDAC)

use a third-party ODBC-driver I'd a look at MSDN and found Visigenic often talked about. Becouse of a former project i knew openlink and intersolve beeing ODBC-driver distributors. Now for the Test: My Test consists of the following:
ASP-Script, that makes an SQL-Select with 2000 rows and puts them on a webpage.
using different ODBC-connections I stopped the time it took when I pressed the refresh-button the 2'nd time in the webbrowser (to allow resource-pooling) till having all the HTML-output visible in my webbrowser. Here's for the result:

My old Ms-Access-Solution: 13 seconds

'Oracle ODBC Driver':                16 seconds
'Microsoft ODBC for ORACLE '    32 seconds
'Intersolve ODBC-Driver':              13 seconds

That's as i expected: You can't expect Microsoft providing fast DB-drivers; they want to see their sql-Server resp. ms-access. The Problem is, that Intersolve's solution costs 9750 DM for a webserver with single-CPU. (190DM for Clients). That's why i can't use that.
Oracle-support told me that ODBC 8.0.4.4 'may not work with ADO AND IIS' (8.0.4.5 should do so, but is not available). So this seems also not very good to me...

Other things beeing not nice:

Trying to USE: 'select DISTINCT xxx from yyy' gets with 'Microsoft ODBC for ORACLE ':
Microsoft OLE DB Provider for ODBC Drivers error '80040e21' The request properties can not be supported by this ODBC Driver.

Trying to USE ADO's Recordset.Open("Table") doesn't work with 'Oracle ODBC Driver'.
And so far i've not done any change/update/delete in the database.

So the question ist: Can anybody recommend me a 'cheap'-robust-fast solution to connect to oracle-db with ADO ? (EierlegendeWollmilchSau)

Or has anybody made experiences simular to mine ?

Zoerrer Helmut

This is my very personal opinion and not necessarily that of my employer

Received on Fri Jul 24 1998 - 07:43:50 CDT