Re: [Zope] Microsoft SQL Server Access under Linux?
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. ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Microsoft SQL Server Access under Linux?
I have tested ODBCSocketServer for queries returning smal sets (20 rows) it seems fine. For larger sets (100+ rows it is slow, my geuss is that the XML encoding is taking the most time. Did not try its MS specific option for returned results but the documentation says that it should be faster. JIm - Original Message - From: Spicklemire, Jerry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 23, 2000 2:12 PM Subject: [Zope] Microsoft SQL Server Access under Linux? Darin asked: Is it possible to access an ODBC data source through Zope running under Linux? I'm getting ready to test such a solution this week. First, we'll try : ODBC Socket Server http://odbc.linuxave.net/ and the accompanying Python Client. This will require some coding, and wrapping the Python Client as an External Method. ODBC Socket Server isn't the most generic approach I've seen, but it is about as simple as such stuff can get. If that one doesn't pan out, it's on to : SQLRelay http://www.firstworks.com/site/pages/html/frames.html which is more generic, and even has a Zope Database Adapter. My fallback plan, assuming insurmountable snags with the first two attempts is: FreeTDS http://www.freetds.org/ which is SQL Server specific, and so the least generic of all. Then, if all else fails, we'll have to look at the OpenLink (for $) stuff. OpenLink http://www.openlinksw.com/ I'll let you know how it goes. Later, Jerry S.. ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[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 [EMAIL PROTECTED] Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 )
Re: [Zope] Microsoft SQL Server Access under Linux?
Use Sybase. Sybase even provide the client libs for download for *ahem* evaluation. MS SQL == Sybase wearing a pair of bad Groucho Marx glasses/nose/mustache (aka an annoying management GUI) Or FreeTDS, but last time I looked that wasn't threadsafe. Anthony "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 "organization al 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 [EMAIL PROTECTED] Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 ) -- Anthony Baxter [EMAIL PROTECTED] It's never too late to have a happy childhood. ___ Zope maillist - [EMAIL PROTECTED] 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 )
RE: [Zope] Microsoft SQL Server Access under Linux?
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Darin Lee Sent: 23 August 2000 14:13 To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Darin M. Lee Analyst / Web Administrator Office of Automation Coordination Michigan Department of Environmental Quality Phone: 517.241.5214 [EMAIL PROTECTED] ___ Zope maillist - [EMAIL PROTECTED] 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 ) ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] Microsoft SQL Server Access under Linux?
Darin asked: Is it possible to access an ODBC data source through Zope running under Linux? I'm getting ready to test such a solution this week. First, we'll try : ODBC Socket Server http://odbc.linuxave.net/ and the accompanying Python Client. This will require some coding, and wrapping the Python Client as an External Method. ODBC Socket Server isn't the most generic approach I've seen, but it is about as simple as such stuff can get. If that one doesn't pan out, it's on to : SQLRelay http://www.firstworks.com/site/pages/html/frames.html which is more generic, and even has a Zope Database Adapter. My fallback plan, assuming insurmountable snags with the first two attempts is: FreeTDS http://www.freetds.org/ which is SQL Server specific, and so the least generic of all. Then, if all else fails, we'll have to look at the OpenLink (for $) stuff. OpenLinkhttp://www.openlinksw.com/ I'll let you know how it goes. Later, Jerry S.. ___ Zope maillist - [EMAIL PROTECTED] 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 )
