Hi,
Looks like I will need to access MsSQL again. I recall there were others who
also had the need. So I'm wondering if the current Dabo tools to access MsSQL
are working? If not what are the current issues. Thanks for the help.
Johnf
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/201107121511.36023.johnf@jfcomputer.com
Użytkownik John Fabiani napisał:
> Hi,
> Looks like I will need to access MsSQL again. I recall there were others who
> also had the need. So I'm wondering if the current Dabo tools to access MsSQL
> are working? If not what are the current issues. Thanks for the help.
Hi.
I have few patches I will publish today evening.
AFIK, there is no driver for Python 2.7.
I tried to compile but without success.
--
Regards
Jacek Kałucki
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4E1CD689.5060708@rz.onet.pl
On Tuesday, July 12, 2011 04:19:37 pm Jacek Kałucki wrote:
> Użytkownik John Fabiani napisał:
> > Hi,
> > Looks like I will need to access MsSQL again. I recall there were others
> > who also had the need. So I'm wondering if the current Dabo tools to
> > access MsSQL are working? If not what are the current issues. Thanks
> > for the help.
>
> Hi.
> I have few patches I will publish today evening.
> AFIK, there is no driver for Python 2.7.
> I tried to compile but without success.
Thanks Jacek!
Johnf
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/201107121623.31786.johnf@jfcomputer.com
Author: python@bdurham.com
Posted: 2011-07-12 19:31:51 Link
Is there a possibility of using one of the Python ODBC modules?
Malcolm
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/1310513511.25962.2151098157@webmail.messagingengine.com
On Tuesday, July 12, 2011 04:31:51 pm python@bdurham.com wrote:
> Is there a possibility of using one of the Python ODBC modules?
>
> Malcolm
I'm sure there is one. However, I wonder how cross platform an ODBC driver
would be?
I know there is a type of setup for Linux but I don't know of anything for the
Mac. No I haven't googled it.
Johnf
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/201107121720.53663.johnf@jfcomputer.com
Author: python@bdurham.com
Posted: 2011-07-12 20:27:42 Link
pyOdbc 2.1.8
http://code.google.com/p/pyodbc
- Use ODBC to connect to almost any database from Windows, Linux, and
Mac OS/X
- Installers for Windows
- Most Linux distributions are starting to provide pre-compiled packages
- 32/64-bit for Python 2.6/2.7; 3.x version under development
- MIT license
There are other Python ODBC libraries as well including commercial
Python ODBC libraries from egenix.
http://www.egenix.com/products/python/mxODBC/
Malcolm
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/1310516862.7945.2151111917@webmail.messagingengine.com
Yes there's odbc for Mac. Not all the drivers are open source / free though.
Dan Means
www.next-erpsystem.com
Mission Viejo, CA
Sent from my iPad
On Jul 12, 2011, at 5:20 PM, John Fabiani <johnf@jfcomputer.com> wrote:
> On Tuesday, July 12, 2011 04:31:51 pm python@bdurham.com wrote:
>> Is there a possibility of using one of the Python ODBC modules?
>>
>> Malcolm
>
> I'm sure there is one. However, I wonder how cross platform an ODBC driver
> would be?
>
> I know there is a type of setup for Linux but I don't know of anything for the
> Mac. No I haven't googled it.
>
> Johnf
> _______________________________________________
> Post Messages to: Dabo-users@leafe.com
> Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
> Searchable Archives: http://leafe.com/archives/search/dabo-users
> This message: http://leafe.com/archives/byMID/201107121720.53663.johnf@jfcomputer.com
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/885D72A8-CF43-4F4B-A7BB-44FEAAA171D0@gmail.com
On Jul 12, 2011, at 7:31 PM, python@bdurham.com wrote:
> Is there a possibility of using one of the Python ODBC modules?
For raw access, yes. But these are not dbapi-compliant, which the Dabo DB layer requires. So not only would you have to set up the ODBC stuff, you'd also need to create a dbapi wrapper for the required connection and cursor classes.
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/122E8FD8-21D6-4B52-9D92-7AA3BC96C414@leafe.com
Author: python@bdurham.com
Posted: 2011-07-13 08:35:08 Link
Ed,
>> Is there a possibility of using one of the Python ODBC modules?
> For raw access, yes. But these are not dbapi-compliant
My understanding is that some of the ODBC modules are db-api compliant.
1. pyodbc - Python ODBC library
Windows, Linux, OS/X
apilevel: The string constant '2.0' indicating this module supports DB
API level 2.0.
http://code.google.com/p/pyodbc/wiki/Module
2. A fast MS SQL Server client library for Python directly using C API
instead of ODBC.
It is Python DB-API 2.0 compliant. Works on Linux, *BSD, Solaris, Mac OS
X and Windows.
http://code.google.com/p/pymssql/
Perhaps you are thinking of the pywin32 ODBC module which is a Python
wrapper for ODBC function calls vs. a db-api wrapper?
Malcolm
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/1310560508.21002.2151285805@webmail.messagingengine.com
On Jul 13, 2011, at 8:35 AM, python@bdurham.com wrote:
> Perhaps you are thinking of the pywin32 ODBC module which is a Python
> wrapper for ODBC function calls vs. a db-api wrapper?
Maybe; the last time I looked at MS SQL access, pymssql was the only dbapi library for it. Glad to see that that's changed!
-- Ed Leafe
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/F5626ACF-7BAE-441D-9C4F-6F6CA1491AD3@leafe.com