Re: Connecting to Informix
Re: Connecting to Informix
- Subject: Re: Connecting to Informix
- From: Chuck Hill <email@hidden>
- Date: Thu, 11 Jan 2007 12:26:29 -0800
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@hidden> 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@hidden> 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-
jagnow=email@hidden [mailto:webobjects-dev-bounces
+albert-jagnow=email@hidden] On Behalf Of Calven
Eggert
Sent: Wednesday, January 10, 2007 5:17 AM
To: email@hidden
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@hidden)
Help/Unsubscribe/Update your Subscription:
40global-village.net
This email sent to email@hidden
--
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden