I am trying to use Access 2000 to access an Informix 7.2 database running on HP-UX 10.20. I am using v3.80 of the Informix ODBC driver.
What is happening, is, if I try to do a linked table, it retrieves the list of tables, but missing the last few characters (eg. the table I'm after is richarlj.printers, it calls it rich.prin) When I actually try to create the link, Informix then tells me that rich.prin does not exist.
If I create an SQL query and do something like SELECT * FROM richarlj.printers That works, but the data in every record is truncated.
This is making it very difficult to work with this database
I have used a shareware package called SQL Query Tool that goes via the same driver, and this does not exhibit the same problems, so I think it is most likely Access that is at fault.
Can anyone help?
(And a less important, though probably related problem. These errors only occur when I set up the connection as a Machine Data Source. If I use a File Data Source, I get "Reserved Error (-7778); There is no message for this error" as soon as I click the OK button to use that connection.)
What is happening, is, if I try to do a linked table, it retrieves the list of tables, but missing the last few characters (eg. the table I'm after is richarlj.printers, it calls it rich.prin) When I actually try to create the link, Informix then tells me that rich.prin does not exist.
If I create an SQL query and do something like SELECT * FROM richarlj.printers That works, but the data in every record is truncated.
This is making it very difficult to work with this database
I have used a shareware package called SQL Query Tool that goes via the same driver, and this does not exhibit the same problems, so I think it is most likely Access that is at fault.
Can anyone help?
(And a less important, though probably related problem. These errors only occur when I set up the connection as a Machine Data Source. If I use a File Data Source, I get "Reserved Error (-7778); There is no message for this error" as soon as I click the OK button to use that connection.)
