OraOLEDB.Oracle Connection String ???

[ehsant]

Hi Everybody ...
I just wanted to know that if :
1- is it possible to connect to a table that contain a CLOB
datatype by ODBC and if so how ? ( what's the connection
string ? )
2- If it's not possible, I Know that there is a provider named :
OraOleDB.Oracle. But When I'm using this provider, sometimes
I get The "UnSpecified Error" and I can't Work ...
Mayby my connection string is wrong ...
what is the corrtct form of this provider connection string ???

TNX
E.T.

 

[Sr]

Hi !

I was testing how to manipulate Oracle(version 8.1.7) LOB fields (NCLOB, CLOBS, BLOBS and BIFILES) using :

1.- VB6, ADO 2.7 and MSDORA (Microsoft OLE DB driver for Oracle.

2.- VB6, ADO 2.7 and Oracle OLE DB driver.

3.- VB6, ADO 2.7 and Oracle ODBC driver.

But nothing works !, you can use any of the drivers above mentioned to work with Long and Long Row data types, but not with LOBS.

LOBS are the newest Oracle data types, and you can work with them using the Oracle Ole driver = OO40 (Oracle Objects For Ole ), for more information read the chapter 10 of the book Oracle and Visual Basic Developer's Handbook, ISBN = 0-7821-2476-3.

I'll write you later some examples about it.

Regards.
Ulises