Why I can`t get the detail of the table of the informix using the SQLQueryPlugin?

When i open the SQL Schema ,i can`t get the tables` information!
The DBMS is Informix.

It`s working with the MS SQL Server 2000 .



Attachment(s):
mysqlschema.JPG
5 comments

This probably happens because of a wrong name for the current schema. I use the user name
as default value but this doesn't work for some databases. If you get me some details to the
Informix JDBC driver (Driver Class, JDBC URL format, possible properties) and the current schema
name I could implement it in the next version.

cosmoboy wrote:

When i open the SQL Schema ,i can`t get the tables` information!
The DBMS is Informix.

It`s working with the MS SQL Server 2000 .

0

The connection information is :
driver class: com.informix.jdbc.IfxDriver
URL:
jdbc:informix-sqli://myip:port/MyDBName:INFORMIXSERVER=myServerName;NEWCODESET=GBK,8859_1,819;NEWLOCAL=zh_cn,en_us

I am not sure what you mean about "the current schema name"?

0

I am not sure what you mean about "the current schema name"?


Schema in jdbc (and in some other instances) is the owner of the
tables.

0

Thanks.
The connected user is just the tables owner.
I granted dba to him.

The other detail information about the Informix server
can be found in the attach picture in the first message.

Waiting for the full supported for informix driver.

0

Thanks for the information. I will add the driver to the list.

Bye,
Stefan.

cosmoboy wrote:

The connection information is :
driver class: com.informix.jdbc.IfxDriver
URL:
jdbc:informix-sqli://myip:port/MyDBName:INFORMIXSERVER=myServerName;NEWCODESET=GBK,8859_1,819;NEWLOCAL=zh_cn,en_us

I am not sure what you mean about "the current schema name"?

0

Please sign in to leave a comment.