ODBC to use MS Access as frontend for Informix 7.2 
Author Message
 ODBC to use MS Access as frontend for Informix 7.2

First of all: I am not a programmer - but just a poor user, who is alone
in the jungle of ODBC.

We do have a database (informix 7.2) the data of which we would like to
use in MS Access (97). Just works fine with Informix CLI-32 2.5.

The problem is that some of the rows do not show the real data but "long
binary-Daten". Somebody told me that this is in connection with BLOBs
(whatever that may be).

What can I do to have access to this data (we just want to read them in
order to make reports)?
Is it possible to convert this information to "Memo"?
Does it only depend on the ODBC-drivers?

THANX for solutions!

Peter Schmiedseder



Wed, 18 Jun 1902 08:00:00 GMT
 ODBC to use MS Access as frontend for Informix 7.2

I got some additional information:
Our database is informix 7.22.
The data that I need is BYTE (but there is only text in it - but we must not
change it to TEXT).

How can I convert this BYTE to MEMO?

TIA
Peter Schmiedseder

Schmiedseder Peter schrieb:

Quote:
> First of all: I am not a programmer - but just a poor user, who is alone
> in the jungle of ODBC.

> We do have a database (informix 7.2) the data of which we would like to
> use in MS Access (97). Just works fine with Informix CLI-32 2.5.

> The problem is that some of the rows do not show the real data but "long
> binary-Daten". Somebody told me that this is in connection with BLOBs
> (whatever that may be).

> What can I do to have access to this data (we just want to read them in
> order to make reports)?
> Is it possible to convert this information to "Memo"?
> Does it only depend on the ODBC-drivers?

> THANX for solutions!

> Peter Schmiedseder



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. LAN Traffic issues between using VB Frontend/MS Access Backend vs Just MS Access

2. Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS and MS-QUERY

3. Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS and MS-QUERY

4. ORACLE 7.2 - ODBC - MS ACCESS 2.0 char(1) problem

5. ORACLE 7.2 - ODBC - MS ACCESS 2.0 char(1) problem

6. ODBC Informix db access using MS Access

7. connect to the MS Access database without using the ODBC driver for MS Access

8. Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS

9. Informix SE ODBC Errors using MS Access #-201 Syntax Error Occured

10. Troubles with informix ODBC drivers when using ms-access

11. Interface MS-Access with Informix using ODBC.

12. Problems connecting MS Internet Info Serv to Informix 7.2


 
Powered by phpBB® Forum Software