If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > JDBC connections for IDS 9.4

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-12-03, 08:21
lloydnwo lloydnwo is offline
Registered User
 
Join Date: Aug 2003
Location: India
Posts: 262
JDBC connections for IDS 9.4

Hi All,

I have installed IDS 9.4 on win, 2000. I have also installed Informix client-SDK 2.81. I created a system dsn to my database & i can connect thru winsql. Now i need to know what are the parameter that need to be set if i need to connect from JAVA. Do i need to install jdbc drivers or it comes bundled with Informix client. I do not know anyting about java. Pls. let me know the settings.

Regards,

lloyd
Reply With Quote
  #2 (permalink)  
Old 11-12-03, 13:44
Amit Dandekar Amit Dandekar is offline
Registered User
 
Join Date: Oct 2003
Posts: 29
hi ,
I don't think JDBC comes with CSDK

JDBC driver is bundled with IDS 9.4 .

You can always download latest JDBC driver from
http://www-3.ibm.com/software/data/informix/tools/jdbc/

The JDBC Programmers manual is at
http://publibfi.boulder.ibm.com/epubs/pdf/ct1utna.pdf


There are no special settings as such as to be able to conenct using JDBC.
(On a side note , JDBC driver does not support shared memory connections , but that shouldn't be issue as you are on windows )

on your sever machine , make sure you add entry to C:\WINNT\system32\drivers\etc\services
for the port number .

If you want to play with JDBC without having to write Java code ,
you can use winSQL lite for JDBC available for free download
from
http://www.indus-soft.com/Synametric...thDownload.jsp
Reply With Quote
  #3 (permalink)  
Old 11-13-03, 02:25
lloydnwo lloydnwo is offline
Registered User
 
Join Date: Aug 2003
Location: India
Posts: 262
Quote:
Originally posted by Amit Dandekar
hi ,
I don't think JDBC comes with CSDK

JDBC driver is bundled with IDS 9.4 .

You can always download latest JDBC driver from
http://www-3.ibm.com/software/data/informix/tools/jdbc/

The JDBC Programmers manual is at
http://publibfi.boulder.ibm.com/epubs/pdf/ct1utna.pdf


There are no special settings as such as to be able to conenct using JDBC.
(On a side note , JDBC driver does not support shared memory connections , but that shouldn't be issue as you are on windows )

on your sever machine , make sure you add entry to C:\WINNT\system32\drivers\etc\services
for the port number .

If you want to play with JDBC without having to write Java code ,
you can use winSQL lite for JDBC available for free download
from
http://www.indus-soft.com/Synametric...thDownload.jsp
Hi Amit,

Thanks a lot for your feedback. I could download winsql lite for jdbc and connect to my database. Thanks once again.

Regards,

lloyd
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On