473,288 Members | 1,693 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,288 software developers and data experts.

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

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
1 6157
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
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...
3
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...
1
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...
5
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...
1
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)...
2
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...
0
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...
0
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...
1
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...
0
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"....
0
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...
0
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 =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
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...
1
isladogs
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...
0
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...
0
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...
1
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)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.