Hi there,

I am quite new to informix and would like to say hello to everybody, as
I probably will show up more often in the future ;-))

For now I am looking for a tool to have easy database access, like
phpMyAdmin in MySQL. Did not find something usefull as webapplication,
but found two windows-tools.

The one I found is WinSQL. That one connects using ODBC, so I skipped
trying it for now.

The other one called Aqua Data Studio (Java-Software) is cheaper and has
a native Informix-java-lib with it. It does connect to MySQL-Servers
without any trouble, but I cannot manage it to get it connected to my
informix-se-server.

When I try to I get this in sqlexecd_tcp.log:
2006-11-02 17:10:28.303972 sqlexec ac1001c8 root -X(null)

The application tells me the following:
Connection failed: Database not found or no system permission

I googled around the world, but couldn't find much usefull stuff. Except
that this error often occures, if file permissions are not set properly.
but this is not the case. Every single file has 666 assigned. Directory
is allright, as well.

Whats wrong? What can I do about it? Any Suggestions?

thanks so much,

regards,

Thomas

I just wrote to the support-team. Everything is cleared now.

thank you anyway!

Thomas


My Answer:
------------

what a pitty. Our version is 7.24... no chance to update.

Thank you,

Thomas

Niels xxxx wrote:

> Hi,
>
> What version of Informix are you trying to connect to? ADS only
supports 7.3 and above.
>
> -Niels

tom wrote:
> Hi there,
>
> I am quite new to informix and would like to say hello to everybody, as
> I probably will show up more often in the future ;-))
>
> For now I am looking for a tool to have easy database access, like
> phpMyAdmin in MySQL. Did not find something usefull as webapplication,
> but found two windows-tools.
>
> The one I found is WinSQL. That one connects using ODBC, so I skipped
> trying it for now.
>
> The other one called Aqua Data Studio (Java-Software) is cheaper and has
> a native Informix-java-lib with it. It does connect to MySQL-Servers
> without any trouble, but I cannot manage it to get it connected to my
> informix-se-server.
>
> When I try to I get this in sqlexecd_tcp.log:
> 2006-11-02 17:10:28.303972 sqlexec ac1001c8 root -X(null)
>
> The application tells me the following:
> Connection failed: Database not found or no system permission
>
> I googled around the world, but couldn't find much usefull stuff. Except
> that this error often occures, if file permissions are not set properly.
> but this is not the case. Every single file has 666 assigned. Directory
> is allright, as well.
>
> Whats wrong? What can I do about it? Any Suggestions?
>
> thanks so much,
>
> regards,
>
> Thomas