Informix back-end drawbacks? (XP)

Topic

New Reply

Hi,
Does anyone have experience with using Access (front end) on an Informix back end? Does it make any difference for developing the user interface, word automation (e.g. creating word documents from a query’s content) and other VBA-procedures,…?
Browsing through the forum, I’ve interpreted that
– “one should test the odbc thoroughly to be sure long text fields are treated properly” (but I don’t know how I should test corruption risk… if Informix shouldn’t be as stable on this point as SQL Server)
– “all vba procedures dealing with data should be rewritten to ADO” .
Is this true and/or… are there other issues to take care of (besides learning to manage an Informix db :-p)?

Reply | Quote

Replies

We don’t have any experience with Informix, but as long as you have a solid ODBC driver or ADO provider you should be able to work with it virtually the same as if you were using Access or SQL Server attached tables. If you want to use bound forms, then you will definitely want to use ODBC – if the forms are unbound, or if you are doing processing of the data then you can use DAO with ODBC, or ADO to manipulate recordsets and the like.

Reply | Quote

Thanks Wendell… I’m already a bit more at my ease now :-)…
(although I preferred using SQL Server… but one of our it guys told me I should be happy they don’t use that… fwiw
There are already other questions popping up but I will go for a try out first (once we have gone through & digested our pc-‘refresh’ coming on our way – finally upgrading to Win + Office XP… imagine :-).
Thanks again,
Hasse

Reply | Quote

Take the comment about SQL Server with a BIG grain of salt – we use it for a number of our clients, and do remote admin and dozens of other things that you just can’t do with Informix (or most other big database products).

Reply | Quote