Hi Sergry,

Our clients were initally set up to use TCP/IP, I will go make sure they were not changed. We install MDAC on the clients which I believe sets up the ODBC drivers. How do I tell the application to use TPC/IP? My connect string looks like this.

lcString = 'Driver={SQL Server};' +;
                    'Server=192.168.3.16;' + ;
                    'database=as2sqlrep;'+ ;
                    'uid=xxxxxxx;pwd=xxx'

lnConn = SQLSTRINGCONNECT(lcString)
= SQLSETPROP(lnConn, "ConnectTimeOut", 600 )
= SQLSETPROP(lnConn, "QueryTimeOut", 600 )

Thanks,
Margaret