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 -- http://mail.python.org/mailman/listinfo/python-list