Re: Connecting to Informix
Re: Connecting to Informix
- Subject: Re: Connecting to Informix
- From: Calven Eggert <email@hidden>
- Date: Fri, 12 Jan 2007 11:48:58 +0100
- Thread-topic: Connecting to Informix
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@hidden> 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@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