import table between Oracle 9i to MS Access - errors?
Date: 21 Jul 2003 07:37:16 -0700
Message-ID: <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:
[snip errors / questions]
2)
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.
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)
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 - 16:37:16 CEST