473,795 Members | 3,428 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

python connection to mssql from windows box

Is there a python module that uses the mssql client tools to connect
to mssql? When you install php on windows and you want mssql
connectivity, you need the client tools and it uses that api to
connect.

I know there is an ADO connection for postgres to connect from
windows, but that's different. Is there anything like this for python?

-Josh
Jul 18 '05 #1
2 2340
On Wed, 29 Sep 2004 21:05:32 -0500, Josh Close wrote:
Is there a python module that uses the mssql client tools to connect
to mssql? When you install php on windows and you want mssql
connectivity, you need the client tools and it uses that api to
connect.

I know there is an ADO connection for postgres to connect from
windows, but that's different. Is there anything like this for python?

-Josh


Josh,

I think you will either need to:

A. use win32com to call ADO

or

B. use odbc

- -
Mark J. Nenadov
http://www.pythonbyte.com

Jul 18 '05 #2
Josh Close <na****@gmail.c om> wrote in message news:<ma******* *************** *************** *@python.org>.. .
Is there a python module that uses the mssql client tools to connect
to mssql? When you install php on windows and you want mssql
connectivity, you need the client tools and it uses that api to
connect.

I know there is an ADO connection for postgres to connect from
windows, but that's different. Is there anything like this for python?

-Josh


You may use ODBC or ADO (<http://sourceforge.net/projects/adodbapi>).
ODBC comes with win32 extensions and is seamlessly integrated with dbi
(1) . So when you write your script, besides of opening the connection
there is no real difference what kind of relational database is used.
ADO supports dbi-2.0.

Good luck
Jul 18 '05 #3

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

Similar topics

2
2763
by: ao | last post by:
I had PHP installed on as CGI on a Window 2000 Server and connected to an MSSQL 2000 on another server. Both server were upgraded to Windows Server 2003 and problems developed that I could no longer run PHP any more. What I did next was to uninstall PHP and re-installed it as ISAPI, and make necessary configurations in Windows Server 2003. PHP seems to work fine now on my applications are having problem connection to MSSQL. One thing...
3
2204
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 not use mysql or anyother one that are not *authorize*, it's oracle or mssql. Now we have to make it work also with our sun and HP unix server(plus one Linux). So I propose to use python, and after they see my litle python/wxwindow program, that...
5
2021
by: Peter Maas | last post by:
I have inherited an extremely messy ASP/VBScript application which is a pain for me to support. Now the customer is thinking about a redesign. I'd like to rewrite the whole thing in Python but the app has to meet some conditions like - IIS frontend - MSSQL db server - Win32 authentication - No 'ugly' URLs like http://server/cgi-bin/frontend.cgi?main.py - Performance: intranet with ~ 1000 users
13
4943
by: Graham | last post by:
I need a SQL Server or ODBC package for Python. Can anyone help please? Have search the Python packages under Database and there is no reference to either SQL Server or ODBC. Thanks Graham
5
4259
by: Leslie Lim | last post by:
I had link my 4 of workstations to server with MySql. 1 pc of my pc can run a software which can update MsSql perfectly but not others(3 failed). I tried to add System Dsn data source for Control Panel - Odbc data source 32. The pc which working fine with the software function but 3 of the rest not. My pcs running xp and win98 ! Regards. Thanks.
15
8289
by: Rob Nicholson | last post by:
I'm starting to worry a bit now. We're getting the above error when two users hit the same database/page on an ASP.NET application using ADO.NET, talking to a SQL 7 server. The error is perfectly repeatable :-( But this should help! The error is occurring inside ExecuteReader which uses a DataReader internally. Here are some things that I'm pretty sure it's *NOT*:
3
4331
by: gharmel | last post by:
I'm trying to get some clues on why I get (much) slower responses from my PHP applications when dealing with a remote sql server as opposed to a local sql server. Here's my situation: Server #1 MSSQL 2000 sp4 Windows 2000 Server PHP4 on IIS5 (CGI)
10
16219
by: sara | last post by:
Hi All, I was able to connect to MS SQL Server 2005 on my computer but after a while I can not. When I want to connect to it using MS SQL Server Management Studio I got this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider,...
7
2776
by: =?Utf-8?B?Sm9obiBTdGFnZ3M=?= | last post by:
Hello, Please read this all before giving an answer :) I'm doing some troubleshooting on a web application that my company wrote. It's written in asp.net 1.1. The error that the Event viewer gives is: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
0
9672
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10437
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10164
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10001
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9042
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6780
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5563
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3723
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.