Thanks to everyone for their assistance yesterday. I feel like I'm really
close to making this work now, but I can't get the Product to connect. I
always get "Invalid connection string".
One thing that puzzles me is the distinction between 'Server' and
'Datasource'.
If Datasources are what we're defining in the interfaces file, that looks a
whole lot like Server. I've seen PHP help pages dealing with these Sybase
libs and MSSQL; somehow they only need to specify user, password, and
database.
TIA for any assistance you can offer.
What I've done:
----------------
I have successfully compiled the SybaseDA product, with Sybase libs, etc,
set SYBASE and LD_LIBRARY_PATH environment variables in Zope startup.
As far as I know, I have created a valid 'interfaces' file. It looks like
this:
spindler
master tcp eth0 xxx.xxx.xxx.xxx 1433
query tcp eth0 xxx.xxx.xxx.xxx 1433
where spindler is the hostname of my computer, xxx.xxx.xxx.xxx is the
dotted-quad of my sql server. On the windows side, the SQL Server has
Network Utility on, port 1433.
(it refers to itself as SPINDLER, does case matter?)
I created a test database with user/passwd and so on.
The output I get upon connection:
----------------------------------
Invalid connection string: database: quux, password: xxxxx, server:
spindler, transactional: Y, user: neilk
Traceback (innermost last):
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/ZPublisher/Publish.py,
line 222, in publish_module
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/ZPublisher/Publish.py,
line 187, in publish
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/Zope/__init__.py, line
221, in zpublisher_exception_hook
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/ZPublisher/Publish.py,
line 171, in publish
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/ZPublisher/mapply.py, line
160, in mapply
(Object: manage_adddcSybaseConnection)
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/ZPublisher/Publish.py,
line 112, in call_object
(Object: manage_adddcSybaseConnection)
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/Products/SybaseDAv2/DA.py,
line 100, in manage_adddcSybaseConnection
File
/home/neilk/Zope/Zope-2.2.4-src/lib/python/Shared/DC/ZRDB/Connection.py,
line 132, in __init__
(Object: RoleManager)
File
/home/neilk/Zope/Zope-2.2.4-src/lib/python/Shared/DC/ZRDB/Connection.py,
line 161, in edit
(Object: RoleManager)
File
/home/neilk/Zope/Zope-2.2.4-src/lib/python/Shared/DC/ZRDB/Connection.py,
line 240, in connect
(Object: RoleManager)
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/Products/SybaseDAv2/db.py,
line 147, in __init__
File /home/neilk/Zope/Zope-2.2.4-src/lib/python/Products/SybaseDAv2/db.py,
line 306, in _error
BadRequest: (see above)
--
Neil Kandalgaonkar, ActiveState
_______________________________________________
Zope-Dev maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope )
