Home » SQL & PL/SQL » SQL & PL/SQL » clob and microsoft provider
clob and microsoft provider [message #1515] Wed, 08 May 2002 06:00 Go to next message
massa
Messages: 12
Registered: April 2002
Junior Member
Hy
I'm working in ASP under Windows 2000 server and I use the Microsoft provider for Oracle DB.
All my programs were working except when I wanted to make an sql request that was using a like on a 'long'.
I discovered that long doesn't support 'like' so now I would like to use a CLOB instead of the long.
The problem is that now I have this error:
Microsoft OLE DB Provider for Oracle (0x80004005)
Data type is not supported.

This error appears when I make a 'select *' on the table where there is the clob.
So I would like to know if it is possible to change my provider or what I have to do in order to solve this problem?
Thanks

Report message to a moderator

Re: clob and microsoft provider [message #1516 is a reply to message #1515] Wed, 08 May 2002 07:03 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
The Oracle odbc driver supports blob, clob, and bfile datatypes and the Microsoft odbc driver for oracle does not.

Report message to a moderator

Previous Topic: SQL, ROWNUM and ORDER BY
Next Topic: Updating With Subquery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:58:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.