473,221 Members | 2,199 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

Python, Windows and SQL Server

I am developing an application for a client that will have data in a MS
SQL Server database. Costs have to be kept down so I have to develop
using the free version of any and all tools I may need. I have the SQL
Server installed, running on Windows XP. I was going to develop the GUI
using wxPython. My only obstacle so far is having Python (wxPython or
just plain Python) connect to the database. Is there a way to use
Python (installed on the same XP server) to connect to SQL Server? I
had read somewhere that Sybase and SQL Server have the same 'roots' and
that using a Sybase driver, can sometimes work when one wants to connect
to a SQL Server instance.

Any ideas?
Jul 18 '05 #1
4 2369
> Is there a way to use
Python (installed on the same XP server) to connect to SQL Server? I
had read somewhere that Sybase and SQL Server have the same 'roots' and
that using a Sybase driver, can sometimes work when one wants to connect
to a SQL Server instance.

Any ideas?


Steve,
I program in Python against MS SQL Server fairly often, using Mark
Hammond's Win32 extensions for Python.
(http://starship.python.net/crew/mham...Downloads.html) With its
help, you can easily wrap ADO COM objects & access SQL Server. If
you're already familiar with ADO, it's a snap. (Even if you're not, ADO
is a pretty straightforward interface.)
Jul 18 '05 #2
Brian wrote:
Is there a way to use Python (installed on the same XP server) to
connect to SQL Server? I had read somewhere that Sybase and SQL
Server have the same 'roots' and that using a Sybase driver, can
sometimes work when one wants to connect to a SQL Server instance.
I program in Python against MS SQL Server fairly often, using Mark
Hammond's Win32 extensions for Python.
(http://starship.python.net/crew/mham...Downloads.html) With its
help, you can easily wrap ADO COM objects & access SQL Server. If
you're already familiar with ADO, it's a snap. (Even if you're not, ADO
is a pretty straightforward interface.)


That's have already been done. ;-)

See adodbapi.sf.net.
Jul 18 '05 #3
Max Ischenko wrote:
you can easily wrap ADO COM objects & access SQL Server. If
you're already familiar with ADO, it's a snap. (Even if you're not,
ADO is a pretty straightforward interface.)


That's have already been done. ;-)

See adodbapi.sf.net.


Thanks Max, I didn't realize this was available. I'll give it a try on
my next project.
Jul 18 '05 #4
Steve <sp***@pennswoods.net> wrote in message news:<ma*************************************@pyth on.org>...
I am developing an application for a client that will have data in a MS
SQL Server database. Costs have to be kept down so I have to develop
using the free version of any and all tools I may need. I have the SQL
Server installed, running on Windows XP. I was going to develop the GUI
using wxPython. My only obstacle so far is having Python (wxPython or
just plain Python) connect to the database. Is there a way to use
Python (installed on the same XP server) to connect to SQL Server? I
had read somewhere that Sybase and SQL Server have the same 'roots' and
that using a Sybase driver, can sometimes work when one wants to connect
to a SQL Server instance.

Any ideas?


mssql python db api

http://pymssql.sf.net
Jul 18 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: Jane Austine | last post by:
As far as I know python's threading module models after Java's. However, I can't find something equivalent to Java's interrupt and isInterrupted methods, along with InterruptedException....
3
by: francisl | last post by:
We have to build some script were I work to make a dynamic server inventory. But, the project team, a windows crew, start it all in vbscript and on mssql. Note, due to political reason, we can...
10
by: Andrew Dalke | last post by:
Is there an author index for the new version of the Python cookbook? As a contributor I got my comp version delivered today and my ego wanted some gratification. I couldn't find my entries. ...
3
by: Mike Moum | last post by:
Hi, I'm a civil engineer who also doubles as chief programmer for technical applications at my company. Most of our software is written in Visual Basic because our VP in charge of I.T. likes to...
10
by: martijn | last post by:
H! I'm using a windows machine. And a FreeBSD server where I run my python scripts. I'm working/making my python scripts in a windows OS with putty now. But I really want the python text...
6
by: Gary Kshepitzki | last post by:
Hello I am trying to send an event from a Python COM server to a VB (or VB.NET) COM client. I am a newbie both in VB and in python. Can anyone give me a simple (but complete) code example both of...
16
by: diffuser78 | last post by:
I want to write a python program and call OS specific commands in it. So basically, instead of typing in on the command line argument I want to have it in a python program and let it do the action....
0
by: Kurt B. Kaiser | last post by:
Patch / Bug Summary ___________________ Patches : 385 open (+21) / 3790 closed (+21) / 4175 total (+42) Bugs : 1029 open (+43) / 6744 closed (+43) / 7773 total (+86) RFE : 262 open...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.