Connecting to SQL database
bill ramsay
blah at blahdeblah
Fri Dec 14 21:24:24 EST 2007
Hi
I have successfully connected to SQL2000 and MSDEE databases in the
past, however I have to move to SQL2005 and SQLEXPRESS databases now.
I've tried the following but with no luck [this is what i used in the
earlier incarnation except the Provider resource was SQLOLEDB.1]
Conn = Dispatch('ADODB.Connection')
Conn.ConnectionString = "Provider=SQLNCLI;Server=10.1.1.2;
Database=csrctest;Uid=bill;Pwd=bill"
print Conn.ConnectionString
try:
print 'trying to open'
Conn.Open()
etc.
All I ever get to is the trying to openline, then it times out.
I have tried all of the following combinations too:
Provider=SQLNCLI;Server=localhost;Database=csrctest;Uid=bill;Pwd=bill;
Provider=SQLNCLI;Server=localhost\SQLEXPRESS;Database=csrctest;Uid=bill;Pwd=bill;
The SQLEXPRESS database for testing purposes is on my home PC
[10.1.1.2]
Any clues s to where I am going wrong?
Look forward to hearing from someone, anyone!!
Kind regards
Bill
More information about the Python-list
mailing list