By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

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

P: n/a
X
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
TC
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" <sh*****@mysun.com> wrote in message
news:9a**************************@posting.google.c om...
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

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.