Re: Attaching Microsoft Access to Informix Online 5.0

In article <33AEFD7E.BAD72A6E@mindspring.com> tschaefe@mindspring.com writes: [snip] >> I wouldn't exactly say a piece of cake. I had a heck of a time getting >> these configured. We're using Openlink's drivers now. Easier to >> configure and much better performance as well (also I-Net is not >> required--part of the performance increase, as well as a cost savings). >And I had just the opposite experience. I could not get Openlink to >work with I-net--tried this past week-end--but COULD get Intersolv's 3.x >drivers to work, WITHOUT I-net. I tested them with Informix OWGS, and >SQLServer, and the clients were S-Designor/Appdesigner, ER/Win, Visual >Basic, and Visual C++. Didn't try with Access--don't have it. > >Openlink Lite clearly states you must use the I-net with their ODBC driver; >maybe the non-lite products do not require I-net. I don't like Lite 'cos it DOES need INET. The full drivers from Openlink seem to work well. I installed them on my SPARC amchine & my Win95 machine and Access is talking to my SE databases. Only "gotcha" I found was - DON'T put the .dbs extension on your data source name when setting up the ODBC32 data sources. You can either specify a DBPATH environment variable in the Openlink ini file on the server or give the absolute database path on the client, or both, but having .dbs on the end will cause you some problems. It don't work. Now I want some JDBC drivers. Grabbed the openlink ones but as they have exactly zero docs included in the zip file and no examples, I think I'll look elsewhere. Weblogic beta might be betta. Peter Wiley PS: PostgresSQL and JDBC drivers work for experimenting with, at zero cost except time.