Thanks Chuck! I'm now able to connect to the Informix database. For those interested your connection string from the client should look like this:
jdbc:informix-sqli://ip:port/dbname:informixserver=servername;user=username; password=password The driver name currently is: com.informix.jdbc.IfxDriver This is the link that describes in detail the connection string: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ib m.jdbc.doc/jdbc52.htm Calven On 1/11/07 9:26 PM, "Chuck Hill" <[EMAIL PROTECTED]> wrote: > Hi Calven, > > > On Jan 11, 2007, at 12:13 PM, Calven Eggert wrote: > >> On Mac. I've actually managed to connect to Informix using >> SQLGrinder but >> it still doesn't show any of the tables/views. When I try to do a >> select it >> tells me that the database has not been selected. >> >> Here is my connection string: >> jdbc:informix-sqli://ip:port:informixserver=servername >> >> This is a custom JDBC URL because otherwise there is no place to >> put in the >> informixserver variable. And now, as you can see, there is no >> place for the >> databasename variable. Do you know how to correct this? > > No, never used it. Do the Informix docs not state this? > > In desperation, one might consult Google... > > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/ > com.ibm.jdbc.doc/jdbc52.htm > > >> BTW - EOModeler, doesn't connect and says "an error occurred". Great. >> Thanks. > > There is your problem! Entity Modeler produces much better error > messages. > > :-) > > Chuck > >> >> On 1/11/07 6:43 PM, "Chuck Hill" <[EMAIL PROTECTED]> wrote: >> >>> On Windows or Mac? Does your application work? Did you put the >>> driver in /Library/Java/Extensions? Did you try setting >>> driver=<class name> in the connection dictionary? >>> >>> Chuck >>> >>> On Jan 11, 2007, at 3:18 AM, Calven Eggert wrote: >>> >>>> Hi Albert, >>>> >>>> EOModeler says it cant find the driver after I installed the IBM >>>> one. >>>> >>>> Any suggestions on what to do next? What should I be checking for >>>> to make sure the driver is in the right place? >>>> >>>> Calven >>>> >>>> >>>> >>>> On 1/10/07 3:42 PM, "Albert Jagnow" <[EMAIL PROTECTED]> wrote: >>>> >>>>> Here is a link to IBM¹s JDBC driver: >>>>> >>>>> http://www14.software.ibm.com/webapp/download/search.jsp? >>>>> go=y&rs=ifxjdbc <http://www14.software.ibm.com/webapp/download/ >>>>> search.jsp?go=y&rs=ifxjdbc> >>>>> >>>>> I use it in one of my applications to pull data from another >>>>> campus database, I am not sure the exact version of Informix they >>>>> are running, the only issue is if they take down their database >>>>> for an upgrade or something I have to restart my WO app, the >>>>> driver won¹t automatically establish a new connection. >>>>> >>>>> -- >>>>> Albert Jagnow >>>>> Web Developer >>>>> The University of Iowa >>>>> >>>>> From: webobjects-dev-bounces+albert- >>>>> [EMAIL PROTECTED] [mailto:webobjects-dev-bounces >>>>> [EMAIL PROTECTED] On Behalf Of Calven >>>>> Eggert >>>>> Sent: Wednesday, January 10, 2007 5:17 AM >>>>> To: [email protected] >>>>> Subject: Connecting to Informix >>>>> >>>>> Hi All, >>>>> >>>>> Has anyone connected to Informix 9.x, from their WO projects? >>>>> >>>>> I¹ve tried to find drivers for the Mac to connect via ODBC or >>>>> JDBC. No luck. (My deployment environment will be Windows Server >>>>> 2003) >>>>> >>>>> Any assistance would be grateful. >>>>> >>>>> Calven >>>>> >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/chill% >>>> 40global-village.net >>>> >>>> This email sent to [EMAIL PROTECTED] >> >> >> _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
