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 1 6157
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Maddman |
last post by:
Hello all. SQL 2000 newbie here. I've done a lot of development in
Access, but the limitations of that program have me looking at upsizing
to SQL 2000.
In my current project I need to import...
|
by: Jon Ole Hedne |
last post by:
My Access 2002-application need to work with tables from both Oracle and
Access. To solve this, I want to run some querys on three views in Oracle
and import the results into temporary...
|
by: mark |
last post by:
In Access 2000 and 2002, I have created an import specification to import the
fixed-width recordset below into an existing table. I am having strange
problems with the import of the date and time...
|
by: Johnny Meredith |
last post by:
I have seven huge fixed width text file that I need to import to Access.
They contain headers, subtotals, etc. that are not needed. There is also
some corrupt data that we know about and can...
|
by: Arti Potnis |
last post by:
Hi,
I want to import some tables from Oracle 9i to MS Access 2000.
I'm able to import the table structures and data using File->Get
External Data->Import . (I don't want to import links)...
|
by: veaux |
last post by:
Peeked around here but didn't really see an explanation as to the
varied "Invalid Argument" errors that appear in Access sometimes. I'm
using Access 2003 and trying to import an Access table of...
|
by: Julie Warden |
last post by:
Group,
I'm running Oracle 8.05 with Solaris 6.
I have a database with several schemas, and I want to create a test
schema from one of the other ones. I'm having a problem with my...
|
by: jen78 |
last post by:
Hi,
I am new to Oracle administration and hope someone can help me out on this as i am struggling to make it work....
I am doing development work using oracle database on my own development...
|
by: X |
last post by:
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...
|
by: MeoLessi9 |
last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
| |