[Zope-DB] Sybase DA
D. Rick Anderson
ruger@comnett.net
Mon, 05 Nov 2001 16:32:02 -0800
--------------040009070507040209060107
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
I am trying to get the Sybase DA to work on a RH 7.1 system with Sybase
12.5 and Zope 2.3.2. I had to modify the Setup file from:
sy_occ sy_occ.c -I$(SYBASE)/include -L$(SYBASE)/lib -lcomn -lcs -lct
-lintl -ls
ybtcl -linsck -lm
to:
sy_occ sy_occ.c -I$(SYBASE)/include -L$(SYBASE)/OCS/lib -lcomn -lcs
-lct -lintl
-lsybtcl -lsybdb
just to get sy_occ.so to compile. The libraries that were used by the
original Setup weren't all there so I modified it to reflect all of them
in the $SYBASE/OCS/lib directory. I then imported the sy_occ.so into
Python and the DA installed just fine. When I try to create a connection
in Zope it gives me:
Invalid connection string: database: 14852, password: blatherskite,
server: 192.168.0.23, transactional: Y, user: blatherskite
[Powered by Zope] <http://www.zope.org/Credits>
Traceback (innermost last):
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 223, in publish_module
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 187, in publish
File /usr/local/Zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook
(Object: RoleManager)
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 171, in publish
File /usr/local/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply
(Object: manage_edit)
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 112, in call_object
(Object: manage_edit)
File /usr/local/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 167, in manage_edit
(Object: RoleManager)
File /usr/local/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 161, in edit
(Object: RoleManager)
File /usr/local/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 240, in connect
(Object: RoleManager)
File /usr/
local/Zope/lib/python/Products/SybaseDAv2/db.py, line 149, in __init__
File /usr/local/Zope/lib/python/Products/SybaseDAv2/db.py, line 309, in _error
BadRequest: (see above)
Any ideas? Is this caused by the changes I made to the Setup file? Any help would be greatly appreciated.
Thanks,
Rick
--
************************************************
Rick Anderson Work: (702)397-6445
System Administrator Cell: (702)275-1855
ComNett Computer Services http://www.comnett.net
************************************************
--------------040009070507040209060107
Content-Type: multipart/related;
boundary="------------000508090306090901010901"
--------------000508090306090901010901
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<html>
<head>
</head>
<body>
I am trying to get the Sybase DA to work on a RH 7.1 system with Sybase 12.5
and Zope 2.3.2. I had to modify the Setup file from:<br>
<br>
sy_occ sy_occ.c -I$(SYBASE)/include -L$(SYBASE)/lib -lcomn -lcs -lct -lintl
-ls<br>
ybtcl -linsck -lm<br>
<br>
to:<br>
<br>
sy_occ sy_occ.c -I$(SYBASE)/include -L$(SYBASE)/OCS/lib -lcomn -lcs -lct
-lintl<br>
-lsybtcl -lsybdb<br>
<br>
just to get sy_occ.so to compile. The libraries that were used by the original
Setup weren't all there so I modified it to reflect all of them in the $SYBASE/OCS/lib
directory. I then imported the sy_occ.so into Python and the DA installed
just fine. When I try to create a connection in Zope it gives me:<br>
<br>
<strong>Invalid connection string: </strong><code>database: 14852, password:
blatherskite, server: 192.168.0.23, transactional: Y, user: blatherskite</code><br>
<!--
exceptions.AttributeError
_db
-->
<p><a href="http://www.zope.org/Credits" target="_top"><img src="http://206.159.190.91/p_/ZopeButton" width="115" height="50" border="0" alt="Powered by Zope" /="">
</a>
</p>
<pre class="moz-signature" cols="$mailwrapcol">Traceback (innermost last):
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 223, in publish_module
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 187, in publish
File /usr/local/Zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook
(Object: RoleManager)
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 171, in publish
File /usr/local/Zope/lib/python/ZPublisher/mapply.py, line 160, in mapply
(Object: manage_edit)
File /usr/local/Zope/lib/python/ZPublisher/Publish.py, line 112, in call_object
(Object: manage_edit)
File /usr/local/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 167, in manage_edit
(Object: RoleManager)
File /usr/local/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 161, in edit
(Object: RoleManager)
File /usr/local/Zope/lib/python/Shared/DC/ZRDB/Connection.py, line 240, in connect
(Object: RoleManager)
File /usr/
local/Zope/lib/python/Products/SybaseDAv2/db.py, line 149, in __init__
File /usr/local/Zope/lib/python/Products/SybaseDAv2/db.py, line 309, in _error
BadRequest: (see above)<br><br>Any ideas? Is this caused by the changes I made to the Setup file? Any help would be greatly appreciated.<br><br>Thanks,<br><br>Rick<br>--
************************************************
Rick Anderson Work: (702)397-6445
System Administrator Cell: (702)275-1855
ComNett Computer Services <a class="moz-txt-link-freetext" href="http://www.comnett.net">http://www.comnett.net</a>
************************************************
</pre>
<pre class="moz-signature" cols="$mailwrapcol">
</pre>
</body>
</html>
--------------000508090306090901010901--
--------------040009070507040209060107--