table permissions vs. ODBC problem?

[shaunnx]

Howdy:

Running Oracle 9.2.0 on RedHat Linux 7.2.

I have a table which I created in Oracle, but would like to allow other users to connect to the server via MS Access (2000) and import a copy. However, the client side gives an 'ODBC
call failed' error message, but no description.

I can't believe it is a driver configuration problem - one reason why is that I am able to connect and EXPORT a table to my schema from MS Access and do some simple queries against that table. I just can't IMPORT a table from Oracle. I was thinking that this would have something to do with table permissions - but I'm not sure.

What type of permission should a table have in order for someone to IMPORT it to some other client / tool? Where can I find some log files that could point me toward the solution? Oracle's log files don't seem to have any info.

Thanks!

-X

[MAK]

It can be of so many reasons. see whether these links are useful to you

http://www.finance.state.mn.us/agenc...faqoracle.html

MS KB article Q160762 ODBC Call Failed or Error 3146

http://support.microsoft.com/default.aspx?kbid=326605

http://beta.experts-exchange.com/Dat..._20409581.html

http://www.experts-exchange.com/Deve..._20366448.html

[shaunnx]

Howdy:

To follow up on a problem with MS Access (2000) and Oracle 9i (9.2.0.x) -

I managed to turn on the logging
(on the NT workstation side / ODBC)
and got the following error messages:

[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