Python adodb

[Kent Johnson]

gt_mac at yahoo.com wrote:
> In trying to use the adodb module, I have had good success. However I
> need to access a database with a username and password at this time.

I have used a connection string like this to connect to MS SQL Server from adodb:
connStrSQLServer = r"Provider=SQLOLEDB.1; User ID=user; Password=passwd;Initial Catalog=Northwind;Data Source=(local)"

HTH
Kent