Connecting Java/ODBC to Informix

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration, Java & JDBC Development, Versions, Editions & End-of-Life

Steve Romankiw — Thu, 18 Mar 1999 14:40:51 -0500 — source: Informix-list mailing list archive (1991-1998)

I am trying to configure our environment to run java apps against Informix but I am running into some configuration problems. The java app I am running is fairly basic - connect, do a select, and disconnect. After RTFMing, I am still left with some unanswered questions. Q: Based on my configuration below, does something seem setup incorrectly? Q: How does Java locate .odbc.ini then use it to resolve DSN? Q: Where should .odbc.ini be located? Q: Does .odbc.ini support env variables, ie. Driver=$INFORMIXDIR/lib/cli/iclis09a.so? My environment: --------------------- Solaris 2.6 JRE 1.1.7_05 IDS 7.23 UC1 Intersovle ODBC 3.01.UC1 Sample .odbc.ini: ---------------------------- [ODBC Data Sources] dsparky=UWS Development ; ; Define ODBC Database Driver's Below - Driver Configuration Section ; [dsparky] Driver=/opt3/informix/dev/lib/cli/iclis09a.so Description=UWS Development Database=duws HostName=klinger LogonID=odbcusr pwd=odbcpsw Service=dsparky_tcp Protocol=onsoctcp Servername=dsparky_tcp TIA Steve Romankiw

↪ replying to Steve Romankiw

P. Kazakov — Thu, 18 Mar 1999 21:24:48 -0500 — source: Informix-list mailing list archive (1991-1998)

Try Informix JDBC type 4 driver,just download from www.informix.com I think ODBC has problems with prepared statements and stored procedures calls. I was happy with that. Paul Steve Romankiw wrote: > I am trying to configure our environment to run java apps against > Informix but I am running into some configuration problems. > The java app I am running is fairly basic - connect, do a select, and > disconnect. > > After RTFMing, I am still left with some unanswered questions. > > Q: Based on my configuration below, does something seem setup > incorrectly? > Q: How does Java locate .odbc.ini then use it to resolve DSN? > Q: Where should .odbc.ini be located? > Q: Does .odbc.ini support env variables, ie. > Driver=$INFORMIXDIR/lib/cli/iclis09a.so? > > My environment: > --------------------- > Solaris 2.6 > JRE 1.1.7_05 > IDS 7.23 UC1 > Intersovle ODBC 3.01.UC1 > > Sample .odbc.ini: > ---------------------------- > [ODBC Data Sources] > dsparky=UWS Development > ; > ; Define ODBC Database Driver's Below - Driver Configuration Section > ; > [dsparky] > Driver=/opt3/informix/dev/lib/cli/iclis09a.so > Description=UWS Development > Database=duws > HostName=klinger > LogonID=odbcusr > pwd=odbcpsw > Service=dsparky_tcp > Protocol=onsoctcp > Servername=dsparky_tcp > > TIA > > Steve Romankiw