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  6165 
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
