Hi guys,
A poster on "Universal Thread" (a VFP forum) has suggested that the pymssql is
not working with Dabo. Can anyone confirm that there is a problem? I don't
currently have access to a MsSQL server or I'd do it myself.
If there happens to be a problem please explain the issues. I'll set
something up and attempt to get it fixed. Of course if it's working I'll
report that too.
Thanks in advance,
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/1547771.JnEtZoqujc@linux-12
Użytkownik John Fabiani napisał:
> If there happens to be a problem please explain the issues. I'll set
> something up and attempt to get it fixed. Of course if it's working I'll
> report that too.
Hi.
I didn't noticed any problems with Dabo, but rather with pymssql library.
For me, the latest working version on Windows platform is stable pymssql 1.0.2,
but it must be patched (you can find my patch on trac).
The latest beta 2.0.0b1-dev-20111019 release works for me on *nix platform,
but it doesn't work on Windows. There are many problems with FreeTDS on that platform.
--
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/4F0C55A2.5080806@rz.onet.pl
On Tuesday, January 10, 2012 04:13:38 PM Jacek Kałucki wrote:
> Użytkownik John Fabiani napisał:
> > If there happens to be a problem please explain the issues. I'll set
> > something up and attempt to get it fixed. Of course if it's working
> > I'll
> > report that too.
>
> Hi.
>
> I didn't noticed any problems with Dabo, but rather with pymssql library.
> For me, the latest working version on Windows platform is stable pymssql
> 1.0.2, but it must be patched (you can find my patch on trac).
> The latest beta 2.0.0b1-dev-20111019 release works for me on *nix platform,
> but it doesn't work on Windows. There are many problems with FreeTDS on that
> platform.
Interesting I really thought all of that was fixed some time ago. I guess I
have to setup a MsSQL server again. Are there any MsSQL version issues??
IOW's is using SQL5 ok for testing or some other version would be best?
Does everyone really want to use pymssql or would they rather have the ODBC
working. I have ODBC working but I did not complete the changes required for
the connection editor etc.. Also I have only tested it on windows. I had
intended to complete it over the xmas period but decided to take a mental
health week off instead.
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/3519877.eNWrQ8xQuu@linux-12
Hi John,
> Does everyone really want to use pymssql or would they rather have the ODBC working?
One vote for ODBC.
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/1326214188.32242.140661021660785@webmail.messagingengine.com
On Jan 10, 2012, at 10:49 AM, python@bdurham.com wrote:
>> Does everyone really want to use pymssql or would they rather have the ODBC working?
>
> One vote for ODBC.
Is there a dbapi-compliant ODBC class?
-- 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/1EBFE741-0A2E-4ADA-AB69-8155C8016C2D@leafe.com
Ed,
> Is there a dbapi-compliant ODBC class?
Yes. There are several.
I think pyodbc is the way to go (dbapi compliant, MIT license, cross
platform, Python 2.x/3.2, etc)
http://code.google.com/p/pyodbc
http://code.google.com/p/pyodbc/wiki/GettingStarted
<snipped>
pyodbc is a Python 2.x and 3.x module that allows you to use ODBC to
connect to almost any database from Windows, Linux, OS/X, and more.
It implements the Python Database API Specification v2.0, but additional
features have been added to simplify database programming even more.
pyodbc is licensed using an MIT license, so it is free for commercial
and personal use. You can even use the source code in your own projects.
Installers for Windows are available here and most Linux distributions
are starting to provide pre-compiled packages. Full source code is also
available.
Version 3.0.2 is the first official pyodbc release that supports both
Python 2 and Python 3 (3.2+).
If you are on Linux and connecting to SQL Server, you may also be
interested in Microsoft's new Linux ODBC driver:
http://www.microsoft.com/download/en/details.aspx?id=28160 Check your
bitness - a Google search may be required ;)
If you are on Windows, there are prebuilt installers linked on the left.
Most Linux distributions include pyodbc in their packages, but you may
need to build your own to ensure you are using the latest
</snipped>
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/1326214825.3648.140661021663221@webmail.messagingengine.com
On Tuesday, January 10, 2012 12:00:25 PM python@bdurham.com wrote:
> Ed,
>
> > Is there a dbapi-compliant ODBC class?
>
> Yes. There are several.
>
> I think pyodbc is the way to go (dbapi compliant, MIT license, cross
> platform, Python 2.x/3.2, etc)
>
> http://code.google.com/p/pyodbc
> http://code.google.com/p/pyodbc/wiki/GettingStarted
>
> <snipped>
> pyodbc is a Python 2.x and 3.x module that allows you to use ODBC to
> connect to almost any database from Windows, Linux, OS/X, and more.
>
> It implements the Python Database API Specification v2.0, but additional
> features have been added to simplify database programming even more.
>
> pyodbc is licensed using an MIT license, so it is free for commercial
> and personal use. You can even use the source code in your own projects.
>
> Installers for Windows are available here and most Linux distributions
> are starting to provide pre-compiled packages. Full source code is also
> available.
>
> Version 3.0.2 is the first official pyodbc release that supports both
> Python 2 and Python 3 (3.2+).
>
> If you are on Linux and connecting to SQL Server, you may also be
> interested in Microsoft's new Linux ODBC driver:
> http://www.microsoft.com/download/en/details.aspx?id=28160 Check your
> bitness - a Google search may be required ;)
>
> If you are on Windows, there are prebuilt installers linked on the left.
> Most Linux distributions include pyodbc in their packages, but you may
> need to build your own to ensure you are using the latest
> </snipped>
>
> Malcolm
Yep! that's what I used recently. I just hard coded the connection string (in
the dbODBC.py) and it worked very well with Dabo. Of course I did not test
everything but I was able to read without issue. I am concerned about
writting because I haven't done any real testing. And of course only tested
on windows.
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/1816929.JWuJEu7ClZ@linux-12
On Tuesday, January 10, 2012 12:00:25 PM python@bdurham.com wrote:
> Ed,
>
> > Is there a dbapi-compliant ODBC class?
>
> Yes. There are several.
>
> I think pyodbc is the way to go (dbapi compliant, MIT license, cross
> platform, Python 2.x/3.2, etc)
>
> http://code.google.com/p/pyodbc
> http://code.google.com/p/pyodbc/wiki/GettingStarted
>
> <snipped>
> pyodbc is a Python 2.x and 3.x module that allows you to use ODBC to
> connect to almost any database from Windows, Linux, OS/X, and more.
>
> It implements the Python Database API Specification v2.0, but additional
> features have been added to simplify database programming even more.
>
> pyodbc is licensed using an MIT license, so it is free for commercial
> and personal use. You can even use the source code in your own projects.
>
> Installers for Windows are available here and most Linux distributions
> are starting to provide pre-compiled packages. Full source code is also
> available.
>
> Version 3.0.2 is the first official pyodbc release that supports both
> Python 2 and Python 3 (3.2+).
>
> If you are on Linux and connecting to SQL Server, you may also be
> interested in Microsoft's new Linux ODBC driver:
> http://www.microsoft.com/download/en/details.aspx?id=28160 Check your
> bitness - a Google search may be required ;)
>
> If you are on Windows, there are prebuilt installers linked on the left.
> Most Linux distributions include pyodbc in their packages, but you may
> need to build your own to ensure you are using the latest
> </snipped>
>
> Malcolm
http://dabo.codepad.org/GLci7Y6C
is the code I'm using currently - seems to work but needs more work.
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/2219209.LoW2v7dJyg@linux-12