| View previous topic :: View next topic |
| Author |
Message |
wpaulson
Joined: 04 Jun 2004
Posts: 1
|
 Posted: Fri Jun 11, 2004 2:06 pm Post subject: Can Informix driver work with SQLGrinder? |
 |
|
I've downloaded and installed the JDBC driver from IBM Informix. The preferences are set to:
| Code: |
Name: Informix
Base Class: com.informix.jdbc.IfxDriver
URL: jdbc:informix-sqli
|
When I try it, I get the message "INFORMIXSERVER has to be specified." From the IBM documentation, it looks like the constructed URL has to include "INFORMIXSERVER=server". Any help out there? |
|
| Back to top |
|
 |
michaeldupuis
Site Admin
Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME
|
| Posted: Fri Jun 11, 2004 3:05 pm Post subject: I'll take a look at it |
|
|
Hi there,
I'll take a look at it. From the info you posted it looks like they use a "non-standard" URL, i.e. they add a string, "INFORMIXSERVER=server" to the normal URL. The current version of SQLGrinder only handles internal URLs that don't have their own extension (except in a few hardcoded cases). The next major version will at the very least let you by-pass the internal URL specification to use any URL string you want in cases like this, but the new version isn't ready yet, so I know that's not much help to you now.
I'll post what I find later.
-- Michael |
|
| Back to top |
|
|
Guest
|
| Posted: Fri Sep 10, 2004 7:47 am Post subject: |
|
|
I have an old version of Informix : 4.10.
Does it work with it ? |
|
| Back to top |
|
|
michaeldupuis
Site Admin
Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME
|
| Posted: Fri Sep 10, 2004 11:09 am Post subject: |
|
|
Hi there,
It doesn't look like it from the information I've found. This is releated to their non-standard JDBC URL usage, which is not supported in the current (1.2.6) version of SQLGrinder.
When version 2 is FINALLY released (still working on it) it will allow you to use any JDBC URL that you want, bypassing the automatic URL creation, so these drivers will then work fine.
-- Michael |
|
| Back to top |
|
|
tperrigo
Guest
|
| Posted: Wed Nov 03, 2004 1:01 pm Post subject: |
|
|
I was able to get SQLGrinder to connect to Informix by specifying the database name as my_db:INFORMIXSERVER=my_server (instead of just "my_db"). I can browse the schema, but so far I've been unable to execute any SQL-- highlighting a SQL statement and pressing "execute" does absolutely nothing.
Any thoughts? I'd love to use this tool for connecting to my Informix and PostgreSQL databases, if it works...
Tim |
|
| Back to top |
|
|
michaeldupuis
Site Admin
Joined: 15 May 2003
Posts: 1427
Location: Lewiston, ME
|
| Posted: Wed Nov 03, 2004 1:11 pm Post subject: |
|
|
| Quote: | | I can browse the schema, but so far I've been unable to execute any SQL-- highlighting a SQL statement and pressing "execute" does absolutely nothing. |
Huh, is there a message dumped to the message log when this happens? Could you also check the main console window in the Console application for anything related to this?
Usually it's the other way around when there is a problem with a driver, you can execute queries, but can't browse the schema.
-- Michael |
|
| Back to top |
|
|
|
