Re: Active Server Pages, ODBC, and Oracle

From: Zoerrer Helmut <dummy_at_nowhere.com>
Date: Wed, 29 Jul 1998 07:56:14 GMT
Message-ID: <35bed31d.2279728@news.Austria.EU.net>

On Tue, 28 Jul 1998 17:28:32 GMT, olomis_at_my-dejanews.com wrote:

>Has anyone been able to connect to an Oracle database from an ASP using ADO
>and ODBC? I am trying to do that using the following code:
I don't know if its possible to specify the connection over the cmd-object.

Try this one:
Set conn = Server.CreateObject("ADODB.Connection")

sConnectionString = "DRIVER={Oracle ODBC Driver};SERVER=ORCL;DBQ=ORCL;DBA=W;UID=<USERNAME>;PWD=<PASSWORD>;" conn.Open sConnectionString
set recordset = Server.CreateObject("ADODB.Recordset") recordset.Open sSQLString, conn

Ensure that you're using oracle's odbc-driver Version 8.0.4.4 or higher. (look at version in the dll) and enable connection-pooling for this odbc-driver.

good luck

Zoerrer Helmut Received on Wed Jul 29 1998 - 02:56:14 CDT