On Fri, Aug 21, 2009 at 9:52 AM, M. Hecht <mhecht2...@instant-mail.de>wrote:
>
> Hmmm ....
>
> meanwhile I tried to find something in the proposed documentation but
> failed.
>
> What I have is a Network Address, Port, DB-Server-Name and DB-Name since on
> the computer are
> running several databases.
>
> This is what I tried to describe with the JAVA connection string:
>
> jdbc:informix-sqli://address:port/dbName:informixserver=dbServerName
>
The Python module is based on ESQL/C, which uses an entirely different
philosophy than JDBC. You can't expect to be able to translate a JDBC
connection string into an ESQL/C CONNECT statement.
There is NOTHING appropriate in the proposed documentation. Only this here:
>
> ... 'datab...@server' ...
>
> so database is clearly the database and server is the network address. But
> where can I enter the port and the dbServerName???
>
> I tried something like this
>
> connect('dbservern...@ipaddress:Port' ...
> connect('dbn...@ipaddress:Port' ...
>
> but with both I get the error message
>
> ... The INFORMIXSERVER value is not listed in the sqlhosts file or the
> Registry ...
>
> Do you have any suggestion?
ESQL/C applications don't connect directly to IP-Address/Port combinations.
They connect to abstractly defined servers that are defined in the sqlhosts
file. Information about how to write an sqlhosts file can be found on Google
by searching for "Informix sqlhosts file."
-Carsten
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
