Informix and JDBC versions compatibility
Posted in 1999
Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues, Java & JDBC Development
Hi, Does anybody know if the Informix On Line Database version 7.12.UC1 supports Informix JDBC driver 1.22.JC1? Which daemons should be running on AIX to listen to JDBC connections and on which port? Any other JDBC I could use to acces this DBMS? uname -a gives me: AIX host 2 3 002124004800 TIA, Igor -- (opinions stated are not necessarily those of my employer)
"Igor A. Walter" wrote: > Does anybody know if the Informix On Line Database version 7.12.UC1 > supports Informix JDBC driver 1.22.JC1? Which daemons should be running > on AIX to listen to JDBC connections and on which port? > > Any other JDBC I could use to acces this DBMS? > > uname -a gives me: > AIX host 2 3 002124004800 You could try our JDBC driver: SCO SQL-Retriever. Take a look at http://www.sco.com/vision/products/sqlretriever/ for more information and a downloadable eval. It works fine on AIX 3.2.5 (which is I think what you have) against Informix 7. Allan Gould SCO CID Support, Leeds, UK (allang at sco dot com) (Please remove anti-spam measures if replying)
>"Igor A. Walter" wrote: >> Does anybody know if the Informix On Line Database version 7.12.UC1 >> supports Informix JDBC driver 1.22.JC1? Which daemons should be running >> on AIX to listen to JDBC connections and on which port? Make sure you have tcp connections type in sqlhosts Also the URL should look something like : jdbc:informix-sqli://$HOST:$PORT/$DBM:informixserver=digitaal1;user=wwwtech Where host,port are the ip and port where your server is and dbm is the database and 'digitaal1' is your server name. Also they are at 1.40 now You can also look at examples.informix.com, they have a connect example there. -- Rico Jansen (rico@vpro.nl) http://james.vpro.nl/ James a Webserver in Java. "You call it untidy, I call it LRU ordered" -- Daniel Barlow
Rico Jansen wrote:
>
> Make sure you have tcp connections type in sqlhosts
What do you mean by that? All we have is an entry like:
dbserver_tcp onipcshm agvs xyz
>
> You can also look at examples.informix.com, they have a connect example there.
Thank you, Igor.
--
(opinions stated are not necessarily those of my employer)