INFORMIX - ACCESS Connection
- From: "Michael Andreas" <andy@xxxxxxxxxxxx>
- Date: Fri, 14 Jul 2006 14:39:05 +0200
Hi,
using the following SQL-Commands I copy a informix table-structure
and later very fast the table-rows to a MS-access DB:
SELECT * INTO tab1 FROM [ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1;
INSERT INTO tab1 SELECT * FROM
[ODBC;DSN=InfomixDB;UID=myINF;PWD=myPWD;].tab1;
source: INFOMIX IDS Server 7.0
destination : MS Access 2000
ODBC-Driver : INTERSOLV 3.11 32-Bit INFORMIX 9
If I change the source DB from INFORMIX IDS Server 7.0
to INFOMIX IDS Server 10.0 for both commands I get the
error-message: reserved error : there is no message for this error
(message from MS-query).
I changed the field-types but the result is the same.
The table dont includs a serial field.
My Question:
What is the difference between Version 7 and 10?
Who knows a solution for my problem?
andrew
.
- Prev by Date: insert xml file into temporary table via odbc
- Next by Date: Oracle ODBC - restricting list of user tables
- Previous by thread: insert xml file into temporary table via odbc
- Next by thread: Oracle ODBC - restricting list of user tables
- Index(es):
Relevant Pages
|
