Python ADO

[gfender]

Hey everyone,
I'm developing a Python web application for a computer inventory system. I'm trying to find information on ADO to connect to a SQL Server 2K database but I've found very few useful links. I've tried using ActivePython's COM browser but the database is located on a remote server. Any help is greatly appreciated. Thank you.

 

[onpnt]

http://www.4guysfromrolla.com/webtech/082201-1.shtml

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[onpnt]

the links in this thread have ADO connections etc. information also
Thread333-584700

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[onpnt]

one more I liked

http://www.e-coli.net/pyado.html

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[onpnt]

slight difference in db resources but this conversation has valued information also

http://dbforums.com/t749171.html

____________________________________________________
_{The most important part of your thread is the subject line.
Make it clear and about the topic so we can find it later for reference. Please!! faq333-2924}

http://www.onpntwebdesigns.com

 

[sebsauvage]

I found this link in my archives:

http://www.e-coli.net/pyado.html

Note that instead of ADO, you can also use ODBC to access databases:

http://sebsauvage.net/python/snyppets/index.html#odbc

You can also manipulate SQL Server 2000 from Python using SQL-DMO COM objects (and script whatever you do in the MMC (Enterprise Manager)):

http://sebsauvage.net/python/snyppets/index.html#sqldmo

 

[gfender]

Thank you, all of those links helped a lot.