Non-ODBC MS Sql Connect

[Bill Tutt]

You can always use ADO from Python on NT.

Quick example:
import win32com.client
import win32com.client.makepy
import win32com.client.genpy
import win32com.client.gencache
adolib = win32com.client.gencache.EnsureModule(
	'{00000200-0000-0010-8000-00AA006D2EA4}', # TypeLib GUID for ADO
	win32con.LANG_NEUTRAL, # LCID
	2, # Major version #
	0, # Minor version #
	win32com.client.genpy.GeneratorProgress()) # Silent progress
indicator.
# ALL loaded typelibrary constants...
k = win32com.client.constants
cxnSQLServer = adolib.Connection()
cxnSQLServer.CursorLocation = k.adUseNone
cxnSQLServer.Provider = "SQLOLEDB"
cxnSQLServer.Open("Server=MachineName;Database=master;UID=user;PWD=apple")

rs = adolib.Recordset()
rs.Open("select * from sysobjects", cxnSQLServer, k.adOpenForwardOnly, 
	k.adLockReadOnly)
# etc.....


Bill




> -----Original Message-----
> From: Roberts, Robert J [mailto:robert_j_roberts at rl.gov]
> Sent: Thursday, July 22, 1999 5:33 PM
> To: python-list at cwi.nl
> Subject: Non-ODBC MS Sql Connect
> 
> 
> How to do I make a non-odbc connection to a MS SQL Server?
> 
> Am running Python Windows NT/IIS.
> 
> Thanks,
> 
>