Nick Gorham wrote: > drewhead wrote: > > > Yes Oliver, this is my understanding of the issue. As long as we're > > talking specfics, this is a ODBC API for RedBrick, an IBM product > > formerly Informix (no DBD-Infomix isn't for the DBMS). I actually > > did try iODBC first, but was unsuccessful. Upon asking on the > > RedBrick list I was contacted by a helpful user who showed me how it > > could be done linking some of the libs (that have an extra 'rb' in > > their name). Alas, I've now coded myself into a corner needing > > access to other drivers that this 'interface' can't handle. > > > > If the solution here is to compile what I currently have working with > > RB to a diffrent name, perhaps RBODBC, I'll certianly give that a > > shot. I don't think I've ever changed a module's name. Is there > > anything to be aware of besides wholesale %s/ODBC/RBODBC/g? > > -- > > Can someone point me to where I can get a copy of this driver and a > database to connect to and I will see why there are problems with driver > managers. > > -- > Nick Gorham > Easysoft Ltd
Ok, I downloaded a copy of informix-se and the client libs, it was a bit of a hack, but it seems to work under unixODBC ok. The driver does its own thing about ini files, so what I did was link the user dsn (/root/.odbc.ini in this case) which is what the driver was looking in to the system dsn one. However you could just use a user dsn. The odbcinst.ini entry is [INFORMIX] Driver = /opt/informix/lib/cli/libifcli.so FileUsage = 1 the odbc.ini entry [Infdrv33] Driver=Informix Description=INFORMIX 3.3 32-BIT Database=/opt/informix/bin/stores7 Servername=demo_se CursorBehavior=0 CLIENT_LOCALE=en_us.8859-1 DB_LOCALE=en_us.8859-1 TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so It connects with the DBD:ODBC make test, but fails as it doesn't seem to support any long types (well looking at the output from SQLGetTypeInfo it doesn't) -- Nick Gorham Easysoft Ltd