Connecting to SQL database

[bill ramsay]

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