Information générale
Titre:
Urgent: Access BLOB or LONG RAW data in Oracle using ADO/SP
Anyone have experience with BLOB/CLOB/LONG RAW fields in Oracle?
I have serious problems retrieving fields of these types from Oracle, having tried several approaches, using both ADO and SP.
Using VFP 6.0 SP3, MDAC 2.1 (just installed 2.1.2.4202.3), connecting to Oracle 8 (8.0.6.0.0). SQL*Plus client is 8.0.5.0.0.
ADO:
I have mainly tried with adUseClient on Connection object and adUseClient, adOpenStatic, adOpenBatchOptimistic on Recordset object and calling the Open method of Recordset object.
I believe I have also tried adUseServer and adOpenKeySet, but I probably haven't tried all possible combinations yet...
What I have not yet tried is using the Command object, calling the Execute method of the Connection object or creating a stored procedure on the server.
OLE DB Provider for Oracle (MSDAORA) (02.10.3711.0)
LONG returns and updates ok.
LONG RAW returns field of type 205 (adLongVarBinary), but using GetChunk() or simply = to assign to variable returns a numeric variable of 0.
BLOB/CLOB Error 1429 "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for Oracle: An Oracle Error occured, but message could not be determined..; An Oracle Error occured, but message could not be determined; Microsoft OLE DB Provider for Oracle"
Microsoft ODBC Driver for Oracle (2.573.3711.00)
LONG returns ok.
LONG RAW returns field of type 205 (adLongVarBinary), but using GetChunk() or simply = to assign to variable returns a numeric variable of 0.
BLOB/CLOB Error 1429 "OLE IDispatch exception code 0 from Provider: Unspecified error..; Unspecified error; Provider"
Oracle ODBC Driver (8.00.05.00)
Error 1429 when calling Open method of Connection object:
OLE IDispatch exception code 0 from Microsoft OLE DB Provider for ODBC Drivers: [Oracle][ODBC][Ora]ORA-12203: TNS:kunne ikke kople til bestemmelsessted ..; Microsoft OLE DB Provider for ODBC Drivers
SQL pass-through:
Using Microsoft ODBC Driver for Oracle (2.573.3711.00)
LONG RAW field returns as GENERAL field
LONG returns ok.
BLOB/CLOB Error 1526 "Connectivity error: Unable to retrieve specific error information. Driver probably out of resources"
Oracle ODBC Driver (8.00.05.00)
LONG RAW field returns as GENERAL field
LONG returns ok.
BLOB/CLOB returns as C(255) field.
Preferably, I'd like to use ADO and the OLE DB Provider for Oracle, but any solution is welcome...
Grateful for any help or ideas!
TIA,
Arne
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement