Re: Connecting to Informix
Re: Connecting to Informix
- Subject: Re: Connecting to Informix
- From: Calven Eggert <email@hidden>
- Date: Thu, 11 Jan 2007 21:13:52 +0100
- Thread-topic: Connecting to Informix
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?
BTW - EOModeler, doesn't connect and says "an error occurred". Great.
Thanks.
Calven
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
_______________________________________________
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