Hi all,

Not sure whether or not this is the right newsgroup to post this question,
but here it is:
Does anybody know what combination of Oracle / MS ODBC driver and MDAC is
best for a Windows 2000 SP 4 Server? I'm running Oracle 8.1.7.4.0. I've
tested several ODBC drivers and MDAC 2.5 / 2.7 SP1, but I keep getting
errors about wrong datatypes in my ASP code. The code worked fine on a NT4
system, but I'm upgrading to W2000 Server. The problems appear ad random:
sometimes there are no problems at all, but every now and then (quite often
as a matter of fact) the system cannot open a recordset or execute a query
and then IIS 5 hangs.

Anybody familiar with this problem?

Any help is appreciated, since I've been searching for a couple of days now!

Thanx!

Tom

Tom wrote:
>
> Hi all,
>
> Not sure whether or not this is the right newsgroup to post this question,
> but here it is:
> Does anybody know what combination of Oracle / MS ODBC driver and MDAC is
> best for a Windows 2000 SP 4 Server? I'm running Oracle 8.1.7.4.0. I've
> tested several ODBC drivers and MDAC 2.5 / 2.7 SP1, but I keep getting
> errors about wrong datatypes in my ASP code. The code worked fine on a NT4
> system, but I'm upgrading to W2000 Server. The problems appear ad random:
> sometimes there are no problems at all, but every now and then (quite often
> as a matter of fact) the system cannot open a recordset or execute a query
> and then IIS 5 hangs.
>
> Anybody familiar with this problem?
>
> Any help is appreciated, since I've been searching for a couple of days now!
>
> Thanx!
>
> Tom

The best ODBC drivers I've seen for Oracle, are from Oracle. Install
Oracle's ODBC drivers. I've also seen good ODBC drivers from Data Direct
(?) but they cost $$$$$. I've had bad problems with MS's ODBC drivers
for Oracle, so I stay away from them.

HTH,
Brian
--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Brian Peasland <dba@remove_spam.peasland.com> wrote in message news:<408ECF6D.C5DC8DC8@remove_spam.peasland.com>. ..
> Tom wrote:
> >
> > Hi all,
> >
> > Not sure whether or not this is the right newsgroup to post this question,
> > but here it is:
> > Does anybody know what combination of Oracle / MS ODBC driver and MDAC is
> > best for a Windows 2000 SP 4 Server? I'm running Oracle 8.1.7.4.0. I've
> > tested several ODBC drivers and MDAC 2.5 / 2.7 SP1, but I keep getting
> > errors about wrong datatypes in my ASP code. The code worked fine on a NT4
> > system, but I'm upgrading to W2000 Server. The problems appear ad random:
> > sometimes there are no problems at all, but every now and then (quite often
> > as a matter of fact) the system cannot open a recordset or execute a query
> > and then IIS 5 hangs.
> >
> > Anybody familiar with this problem?
> >
> > Any help is appreciated, since I've been searching for a couple of days now!
> >
> > Thanx!
> >
> > Tom
>
> The best ODBC drivers I've seen for Oracle, are from Oracle. Install
> Oracle's ODBC drivers. I've also seen good ODBC drivers from Data Direct
> (?) but they cost $$$$$. I've had bad problems with MS's ODBC drivers
> for Oracle, so I stay away from them.
>
> HTH,
> Brian

IIRC,
Oracle released a patchset 8.1.7.5.0 for ODBC.
Check metalink for patchsets/one off patches.

hth.

Pd

Hi,

I've installed Oracle ODBC driver 8.1.7.1.0 and MDAC 2.7 SP 1 and got rid of
some session.lcid = .... and that fixed the problem!

It seems to me that IIS 4 was not that strict regarding some session
variables, but IIS 5 is..... anyway: I'm a happy person again. Thanx!

Tom


"Paul Drake" <drak0nian@yahoo.com> wrote in message
news:1ac7c7b3.0404272044.3f504c1@posting.google.co m...
> Brian Peasland <dba@remove_spam.peasland.com> wrote in message
news:<408ECF6D.C5DC8DC8@remove_spam.peasland.com>. ..
> > Tom wrote:
> > >
> > > Hi all,
> > >
> > > Not sure whether or not this is the right newsgroup to post this
question,
> > > but here it is:
> > > Does anybody know what combination of Oracle / MS ODBC driver and MDAC
is
> > > best for a Windows 2000 SP 4 Server? I'm running Oracle 8.1.7.4.0.
I've
> > > tested several ODBC drivers and MDAC 2.5 / 2.7 SP1, but I keep getting
> > > errors about wrong datatypes in my ASP code. The code worked fine on a
NT4
> > > system, but I'm upgrading to W2000 Server. The problems appear ad
random:
> > > sometimes there are no problems at all, but every now and then (quite
often
> > > as a matter of fact) the system cannot open a recordset or execute a
query
> > > and then IIS 5 hangs.
> > >
> > > Anybody familiar with this problem?
> > >
> > > Any help is appreciated, since I've been searching for a couple of
days now!
> > >
> > > Thanx!
> > >
> > > Tom
> >
> > The best ODBC drivers I've seen for Oracle, are from Oracle. Install
> > Oracle's ODBC drivers. I've also seen good ODBC drivers from Data Direct
> > (?) but they cost $$$$$. I've had bad problems with MS's ODBC drivers
> > for Oracle, so I stay away from them.
> >
> > HTH,
> > Brian
>
> IIRC,
> Oracle released a patchset 8.1.7.5.0 for ODBC.
> Check metalink for patchsets/one off patches.
>
> hth.
>
> Pd