Hi Vlad:
these are the codes that I am getting the connectivity error on:

SQL_STR = "UPDATE ClientType SET clEntity = m.entity,"+;
"clFirst1 = m.clFirst1,clMI1 = m.clMI1,clLast1 = m.clLast1,"+;
"clFirst2 = m.clFirst2,clMI2 = m.clMI2,clLast2 = m.clLast2,"+;
"clZip = m.zip where clClientID = ?M.CLIENT_ID"

OUTPUT=SQLEXEC(gnquoteConn,SQL_STR)
thanks
sherry