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
0
5 comments
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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
Avatar
Permanently deleted user

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.