| Author |
Message
|
| francoisvdm |
 Posted: Tue Jul 07, 2009 2:09 am Post subject: Informix V7.2 and MB V6.1 |
 |
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
Creating a database connection in the broker against an Informix V7.2 database the COLUMNS are not there. It picks up all the table names, but no columns.
Using JDBC3 drivers for Informix?
Can we use ODBC drivers? How do you set it up?
Thanks
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
 |
| broker_new |
| Posted: Tue Jul 07, 2009 3:15 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Wire protocol drivers are provided only for Oracle,SQL server and Sybase flavors. You need to install the clients for Informix and DB2 databases.
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Tue Jul 07, 2009 3:43 am Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
Thanks...we did install the JDBC3 drivers for Informix before we tried to make a db connection. It is correctly connecting from the "Test" button. But when it creates all the tables...no column information. We are thinking...unsupported version?
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Tue Jul 07, 2009 4:59 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
| broker_new wrote: |
| Wire protocol drivers are provided only for Oracle,SQL server and Sybase flavors. You need to install the clients for Informix and DB2 databases. |
I'm not not sure what you meant - Message Broker 6.1 does include support for Informix.
_________________
Bill Matthews |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Tue Jul 07, 2009 5:29 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
| broker_new wrote: |
| Wire protocol drivers are provided only for Oracle,SQL server and Sybase flavors. You need to install the clients for Informix and DB2 databases. |
I'm not not sure what you meant - Message Broker 6.1 does include support for Informix.
_________________
Bill Matthews |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Jul 07, 2009 9:41 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
|
| Back to top |
|
|
| francoisvdm |
| Posted: Tue Jul 07, 2009 10:24 pm Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
Thank you for the information. We do have correct client installed...but server is older, but we want to give it a bash anyway.
I'm not DB skilled, so any kind soul out there that can tell me what I must select in the DB connection "especially which CLASS" to use, I've got the other parameters. I guess what I'm asking is how do I point to the V2.9 client to use it.
Thank you
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Tue Jul 07, 2009 10:27 pm Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
| Bill.Matthews wrote: |
| broker_new wrote: |
| Wire protocol drivers are provided only for Oracle,SQL server and Sybase flavors. You need to install the clients for Informix and DB2 databases. |
I'm not not sure what you meant - Message Broker 6.1 does include support for Informix. |
It does include support for it, yes, but I can't find documentation on which class to select, how to set up ODBC for informix.
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| broker_new |
| Posted: Wed Jul 08, 2009 12:00 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
If you need to point the broker to connect to informix, set up the DSN parameters in $ODBCINI and in the Driver parameter locate the library that is obtained from the client installation.
_________________
IBM ->Let's build a smarter planet |
|
| Back to top |
|
|
|
|
