Re: Active Server Pages, ODBC, and Oracle

Zoerrer,

I've only been able to get the "Microsoft for Oracle" driver to work, and I have been having problems with connection pooling, so I turned it off.

If you have successfullly used the Oracle driver with connection pooling, I would be very encouraged to keep trying.

Anything else I should know besides the dll version number?

My connection pooling problem gives me an ODBC error saying something like "ORA-xxx Unable to allocate memory"

Any help would be appreciated.

Danny

p.s. if you could reply directly to my address below, I would appreciate it. I will be on vacation next week and the posting my be deleted by the time I get back.

dlfong_at_hotmail.com

Zoerrer Helmut <dummy_at_nowhere.com> wrote in article <35bed31d.2279728_at_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 Fri Jul 31 1998 - 08:07:00 CDT