Hi All

Strange question here and i just cant figure out what is causing this. The company i work for has about 50 clients running their one package. A few months ago i upgraded the database from sql 2000 to sql express 2008 mainly so that it can run on windows 7. All is good and it works perfectly. Except on certain sites it doesnt seem to connect to the database the only thing i changed is the connection string to cater for sql express 2008 and i have a form that is displayed should the connection not be successfull. Im struggling to find out what is causing this as i cant duplicate the scenario on my dev machine or my laptop as it works perfectly. Could it be something to do with MDAC or now WDAC that might not be installed on certain machines that could be causing this ? Below is the connection code which works fine.

Code:
        Case "SQL/EXPRESS 2008"
            On Error GoTo trap3
            Set cnnMain = New ADODB.Connection
            cnnMain.ConnectionString = "Driver={SQL Server Native Client 10.0};server=" & Trim(ServerName) & ";uid=" & Trim(UserName) & ";pwd=" & Trim(Password) & ";database=" & Trim(Database)
            cnnMain.ConnectionTimeout = Timeout
            cnnMain.CommandTimeout = 260
            
            cnnMain.Open
            On Error GoTo 0
            Exit Sub
trap3:
            Load frmServerErr
            frmServerErr.lblCap.Caption = err.Description & cnnMain.ConnectionString
            frmServerErr.Show vbModal
            End
    End Select
Im at a bit of a loss here.

Many Thanks
AJ