I: caching the sql queries

[Bob Gailer]

At 05:27 AM 9/15/2003, Luca Calderano wrote:

>I MEAN YOU CAN ACCESS ADO TROUGHT COM
>AS EXPLAINED HERE:
>
>import win32com.client
>import locale
>from os import sys
>
>
>adCmdStoredProc    =   4     # Evaluates CommandText as a stored procedure
>name.
>adCmdTable         =   2     # Evaluates CommandText as a table name.
>adInteger          =   3     # A 4-byte signed integer.
>adParamInput       =   0x1   # from enum ParameterDirectionEnum
>
>
>class DBConnect:
>     def __init__(self):
>         self.Cnn = win32com.client.Dispatch(r'ADODB.Connection')
>         self.ConnStr = r'File Name=C:\Graal.dsn'

I want to learn form your excellent example.

What is the function of r'File Name=C:\Graal.dsn' in this context?

Can I use this approach to connect to MS SQL Server? and if so how? what 
would the connection string be?

[snip]

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625
-------------- next part --------------

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003