Thank you everyone for your posts. Listed below is the correct code,
solution reached. And to include the username and password you can
simply inter it behind Persist Security devieded off with semicolons.
con = win32com.client.Dispatch(r'ADODB.Connection')
DSN = r'Provider=Microsoft.Jet.OLE
You also might want to take a look at;
http://www.mayukhbose.com/python/ado/index.php
I found it very helpful
LenS
--
http://mail.python.org/mailman/listinfo/python-list
I have used the following code in ADO:
# The following code creates a connection object,
# assigns the connection string, opens the
# connection object, and then verifies a good
# connection.
oConn = Dispatch('ADODB.Connection')
oConn.ConnectionString = "Provider=SQLOLEDB.1;" +\
[EMAIL PROTECTED] 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
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.
And cannot find a way to do it without using a ODBC or other older
techniques. Can someone help me with this, below is the code I am
currently attempting to use
