My zope server is running on fedore core3. I want to connect to ms sql server running on windows xp platform using FreeTDS, SQLRelay and ZSqlRelayDA. My sqlrelay.conf can be seen below:

<?xml version="1.0"?>
<!DOCTYPE instances SYSTEM "sqlrelay.dtd">

<instance id="mssql" port="9000" socket="/tmp/examplesocket" dbase="freetds" connections="1" maxconnections="15" maxqueuelength="5" growby="1" ttl="60" endofsession="commit" sessiontimeout="600" runasuser="nobody" runasgroup="nobody" cursors="5" authtier="listener" handoff="reconnect" debug="none">
<user user="evrim" password="123456"/>
<connection connectionid="db1" string="sybase=/usr/local/etc/freetds.conf;user=evrim;password=123456;server=MyServer2k;db=LKSDB;" metric="1"/>

As you seen there is only 1 listener socket created. I can execute the first sql command successfully but i can't execute the second command. The sqlrelay error shown in the log file:

Client Library error:
Error:  Attempt to initiate a new SQL Server operation with results pending.

I think the connection does not end after the execution. When all the listener sockets used the system becomes useless. Then i restart the sqlrelay service in order to clear the sockets.

What must i do ? The listener socket must be empty after the execution.
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to