Re: import table between Oracle 9i to MS Access - errors?

Consider this response more as pointers than a solution:

A> Do you have BLOB/CLOB/NCLOB/NCHAR data types in those tables B> Is any of those rows larger than 8K ?

//tc

"X" <shaunnx_at_mysun.com> wrote in message news:9a0ccd82.0307210637.208e2454_at_posting.google.com...
> Howdy:
>
> To follow up on a problem with MS Access (2000)
> and Oracle 9i (9.2.0.x) -
>
> History:
> I am trying to import tables from my Oracle 9i database on
> RedHat Linux 7.2 to MS Access (2000) on NT. I managed to turn
> on logging / debugging for ODBC connections and I
> got a few messages that I am unfamiliar with.
>
> [snip errors / questions]
> 1)
>
> MSACCESS 17c-159 EXIT SQLGetStmtOption with return code -1
 (SQL_ERROR)
> HSTMT 08E31718
> UWORD 0
> PTR 0x0012B37C
>
> DIAG [S1C00] [Oracle][ODBC]Driver not capable. (0)
>
>
> 2)
>
> MSACCESS 17c-159 ENTER SQLExecDirectW
> HSTMT 08E31718
> WCHAR * 0x098A0CD0 [ -3]
> "SELECT CONTRACT" ,"MBR_NUM" ,"DATE" ,
> "EVENT_ID" ,"VALUE" ,"RESULT" ,"UPDATED" ,"USERNAME" ,"CLAIM"
> FROM "SHAUNN"."HMP_DATES" \ 0"
> SDWORD -3
>
> MSACCESS 17c-159 EXIT SQLExecDirectW with return code 0
 (SQL_SUCCESS)
> HSTMT 08E31718
> WCHAR * 0x098A0CD0 [ -3]
> "SELECT CONTRACT" ,"MBR_NUM" ,"DATE" ,
> "EVENT_ID" ,"VALUE" ,"RESULT" ,"UPDATED" ,"USERNAME" ,"CLAIM"
> FROM "SHAUNN"."HMP_DATES" \ 0"
> SDWORD -3
>
> MSACCESS 17c-159 ENTER SQLFetch
> HSTMT 08E31718
>
> MSACCESS 17c-159 EXIT SQLFetch with return code -1 (SQL_ERROR)
> HSTMT 08E31718
>
> DIAG [S1000] [Oracle][ODBC][Ora]ORA-00932: inconsistent datatypes
> (932)
>
>
> 3)
>
> MSACCESS 17c-159 EXIT SQLErrorW with return code 100
 (SQL_NO_DATA_FOUND)
> HENV 08E31478
> HDBC 08E31520
> HSTMT 08E31718
> WCHAR * 0x0012B094 (NYI)
> SDWORD * 0x0012B0E0
> WCHAR * 0x031A18C2
> SWORD 3979
> SWORD * 0x0012B0E4
>
> [/snip errors / questions]
>
>
> Is there supposed to be some type of patch for this?
> Is it MS Access related? (I'm guessing it is, but ...)
> I am not sure *what* datatypes are not working for
> MS Access <-> Oracle. Is there a way I can find out?
>
> Any pointers / suggestions are welcomed.
>
> Thanks!
>
> -X
Received on Mon Jul 21 2003 - 18:40:11 CEST