Re: ODBC Long column garbaged on retreival...

In article <36548EBE.73DAC548_at_scientech.com>,   Dale Cook <dcook_at_scientech.com> wrote:
> Howdy,
>
> Many pardons if this has been answered recently, i've got about 5K
> messages to go thru here to catch up :-)
>
> I'm trying to talk to an 8.0.5 database on a DEC Unix box via
> an ODBC connection from an NT4 IIS4 configuration running ASP.
> I've got the latest ODBC ora drivers from Oracle (8.0.5.1b), and
> still have this problem. Anyway, the problem is that long
> values are horked up when I retrieve them from the database. I
> can insert them fine. The first few characters are good, but
> there's binary crap thereafter. Supposedly, one of the patches
> addressed this problem as i recall reading it in one of the release
> notes files but I can't find it now. Microsoft's oracle driver
> works better, actually, except that under load the web server goes
> belly up.
>
> Any ideas???
>
> ----dale
>
> PS: In the course of trying to get this to work, I found a different
> bug in the Oracle driver: retrieval of columns defined as NUMBER(nn)
> in an oracle db via ODBC causes the select to fail with a no data
> found.
>

I know you propably do not want to hear this.. but you could try the third driver on the market.. being the one from intersolv.. After using the free ones from Oracle and MS, falling over bugs, getting no support whatsoever from one of them I decided to invest a little money in the intersolv driver and got a functional driver with a good support package.. (I'm gonna shutup now or those intersolv guys might get an attitude).. you can download an 30-day eval from http://www.microfocus.com/products/ddmain.htm .. if it doesn't work you only lost the time.. not the money..

toffie.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 20 1998 - 07:56:58 CST