Hi, does anyone know if it is possible to get access to a Microsoft SQL Server 7 from Zope running under Linux (e.g. via ODBC). What additional products are eventually needed ? Thanks for answers S. Wiedemann --- Wiedemann EDV Systeme GmbH Landsbergerstr. 77 80339 München Tel.: 089/897180-30 Fax.: 089/897180-20
No, unfortunately, it's not possible. You can use the Sybase database adapter to talk to SQL Server 6.5 from Linux. SQL Server 7 evidently has a different wire protocol which prevents it from working against the Sybase DA. There is no ODBC support for Linux in Zope, and though there have been rumblings about getting such a thing going one way or another, nothing concrete has happened. Severin Wiedemann wrote:
Hi,
does anyone know if it is possible to get access to a Microsoft SQL Server 7 from Zope running under Linux (e.g. via ODBC). What additional products are eventually needed ?
Thanks for answers
S. Wiedemann
---
Wiedemann EDV Systeme GmbH Landsbergerstr. 77 80339 München Tel.: 089/897180-30 Fax.: 089/897180-20
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Chris McDonough Digital Creations Publishers of Zope - http://www.zope.org
+----[ Chris McDonough ]--------------------------------------------- [Charset iso-8859-1 unsupported, filtering to ASCII...] | No, unfortunately, it's not possible. You can use the Sybase database | adapter to talk to SQL Server 6.5 from Linux. SQL Server 7 evidently | has a different wire protocol which prevents it from working against the | Sybase DA. There is no ODBC support for Linux in Zope, and though there | have been rumblings about getting such a thing going one way or another, | nothing concrete has happened. It is very possible to get ODBC connectivity using the OpenLink UDBC Multi-Tier drivers and ZODBCDA. You will have to do some minor hacking, and if you want access to any fields longer than 128 bytes, some larger hacking :-) (There is I think a major bug in SQLGetString in sql.c too that causes Zope to crash -- I think I have fixed it... at least w.r.t. the UDBC drivers, sz should be SDWORD [for OpenLink drivers anyway]). The UDBC drivers are thread-safe (so they say). I have a FreeBSD box quite happily talking to MS-SQL-7, I implemented this for a client, so I can tell you how to do it, but, not what I did to get it to work.The joys of contract programming. -- Totally Holistic Enterprises Internet| P:+61 7 3870 0066 | Andrew Milton The Internet (Aust) Pty Ltd | F:+61 7 3870 4477 | ACN: 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
participants (3)
-
Andrew Kenneth Milton -
Chris McDonough -
Severin Wiedemann