Zopistas, Is it possible to access an ODBC data source through Zope running under Linux? I have perused the literature, and it appears the Zope DA's for ODBC only run under the Win32 environment. I would very much like to setup ZAP (for many reasons), but our "organizational standard" is MS SQL Server 6.5. Thanks, -Darin Lee Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 leedm@state.mi.us Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 leedm@state.mi.us
+-------[ Darin Lee ]---------------------- | Zopistas, | | Is it possible to access an ODBC data source through Zope running under Linux? I have perused the literature, and it appears the Zope DA's for ODBC only run under the Win32 environment. | | I would very much like to setup ZAP (for many reasons), but our "organizational standard" is MS SQL Server 6.5. Openlink multi-tier UDBC drivers will work a treat (minor hacking of ZODBCDA required) and will talk to anything your NT box can talk to. They also have evaluation licenses (up to 10 simultaneous connections). I'll see if I can dig up my hacks to ZODBCDA... they're not clean, but, they served the purpose at the time. -- 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 ABN: 83 082 081 472 | M:+61 416 022 411 | Carpe Daemon PO Box 837 Indooroopilly QLD 4068 |akm@theinternet.com.au|
Check out this ODBC-ODBC bridge: http://linuxpr.com/releases/430.html I have not tried it, but it does seem to do what you want. "The ODBC-ODBC Bridge is a package of libraries which provide applications on Linux with access to ODBC data sources on remote machines. Examples of using the ODBC-ODBC Bridge are: Apache/PHP + the ODBC-ODBC Bridge (running on Linux) to read/write data held in Microsoft SQLServer on NT. Perl + DBI + DBD:ODBC + the ODBC-ODBC Bridge (running on Linux) to read/write data held in a Microsoft Access database on NT. As above but with Python's mxODBC, RExx/SQL or any C application. Access from StarOffice or Applixware on Linux to remote ODBC databases. Access to any remote ODBC compliant driver." If you find problems with this one, I suspect that there are other offerings (web search, "+ODBC +bridge"). Richard P.S. Please let us know how you get on.
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Darin Lee Sent: 23 August 2000 14:13 To: zope@zope.org Subject: [Zope] Microsoft SQL Server Access under Linux?
Zopistas,
Is it possible to access an ODBC data source through Zope running under Linux? I have perused the literature, and it appears the Zope DA's for ODBC only run under the Win32 environment.
I would very much like to setup ZAP (for many reasons), but our "organizational standard" is MS SQL Server 6.5.
Thanks, -Darin Lee
Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 leedm@state.mi.us
Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 leedm@state.mi.us
_______________________________________________ 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 )
Hi Darin, Darin Lee wrote:
Zopistas,
Is it possible to access an ODBC data source through Zope running under Linux? I have perused the literature, and it appears the Zope DA's for ODBC only run under the Win32 environment.
I would very much like to setup ZAP (for many reasons), but our "organizational standard" is MS SQL Server 6.5.
It might or might not be helpful for you. I also have a bunch of databases only accessible via ODBC, so we use Merants Sequelink-Socket product (since we bought it). So far I could get mxODBC to work with it flawlessy. Now I'm up to integrate it into the ZmxODBC DA published some days ago at zope.org.
participants (4)
-
Andrew Kenneth Milton -
Darin Lee -
Richard Folwell -
Tino Wildenhain