Thanks for everyone's suggestions. One person thought it might a
permissions problem but the SQL guys are out until Tuesday. That seems
likely since I asked only for read/write permissions not realizing
that a separate permission is needed to insert into a table. At least
I hope it's that simple. However I like what others have said. I
know very little about connecting to SQL server and the different
syntax options are enlightening. Thanks again.