473,396 Members | 1,972 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,396 software developers and data experts.

SQL Server

Greetings, All-

About 2 months ago I was laid off and in the process of being walked to the door I lost most of my Python tips and tricks. Looks like I'm back on theair with a great job and am ready to start coding again. I'd like to know what I have to do to connect to a Microsoft SQL server database. I did it at my old job but forgot the process.

Thanks for your help. BTW, I'm the first full-time programmer in this particular shop and they are quite interested in using Python as their languageof choice! This could be a lot of fun.

Greg Lindstrom
Jul 18 '05 #1
3 1235
yu**@cyberback.com wrote:
Greetings, All-

About 2 months ago I was laid off and in the process of being walked to the door I lost most of my Python tips and tricks. Looks like I'm back on the air with a great job and am ready to start coding again. I'd like to know what I have to do to connect to a Microsoft SQL server database. I did it at my old job but forgot the process.

Thanks for your help. BTW, I'm the first full-time programmer in this particular shop and they are quite interested in using Python as their language of choice! This could be a lot of fun.

Congratulations on seeing a wage packet again!

Easiest would be to use mxODBC (downloadable from www.egenix.com, but
don't forget to buy a license if you are using it commercially).

regards
Steve
Jul 18 '05 #2
Steve Holden wrote:
yu**@cyberback.com wrote:
Greetings, All-

About 2 months ago I was laid off and in the process of being walked
to the door I lost most of my Python tips and tricks. Looks like I'm
back on the air with a great job and am ready to start coding again.
I'd like to know what I have to do to connect to a Microsoft SQL
server database. I did it at my old job but forgot the process.

Thanks for your help. BTW, I'm the first full-time programmer in this
particular shop and they are quite interested in using Python as their
language of choice! This could be a lot of fun.

Congratulations on seeing a wage packet again!

Easiest would be to use mxODBC (downloadable from www.egenix.com, but
don't forget to buy a license if you are using it commercially).

regards
Steve


I reckon its easier to use ADO. pyado.sourceforge.net or
jtoolkit.sourceforge.net have tools to do this but are GPL

David
Jul 18 '05 #3
David Fraser <da****@sjsoft.com> pisze:
I reckon its easier to use ADO. pyado.sourceforge.net or
jtoolkit.sourceforge.net have tools to do this but are GPL


Adodbapi (http://adodbapi.sourceforge.net/, LGPL) offers the same
functionality.

--
Jarek Zgoda
http://jpa.berlios.de/
Jul 18 '05 #4

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

Similar topics

2
by: Phil | last post by:
I am using a Pascal like language (Wealth-Lab) on W2K and call this server: class HelloWorld: _reg_clsid_ = "{4E797C6A-5969-402F-8101-9C95453CF8F6}" _reg_desc_ = "Python Test COM Server"...
6
by: Nathan Sokalski | last post by:
I want to set up SQL Server on Windows XP Pro so that I can use the database capabilities of ASP and IIS. I am probably using some incorrect settings, but I am not sure what they are. Here is what...
9
by: Grim Reaper | last post by:
My work let me put SQL Server 7.0 Enterprise Edition on my laptop. I have never setup a server from the beginning, so I am a little new at creating server groups. Alright, I am trying to create...
0
by: Chris Halcrow | last post by:
Hi I've spent ALL DAY trying to re-install SQL Server 2000 on Windows XP. I continually get the error 'cannot configure server' just at the end of the installation. I've tried the following: ...
0
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager...
2
by: Hazzard | last post by:
I just realized that the code I inherited is using all asp.net server controls (ie. webform controls) and when I try to update textboxes on the client side, I lose the new value of the textbox when...
2
by: Mike | last post by:
Hi, I am strugling with a simple problem which I can't seem to resolve. I have an asp.net page which contains a server-control (flytreeview, which is a kind of a tree to be exact). The tree is...
2
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
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...
0
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,...

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.