Thanks, I'm glad to learn about the execute immediate function. However, I added the following line just after the loSqlServer create statement and I still get the same error.

loSQLServer.ExecuteImmediate('SET QUOTED_IDENTIFIER OFF')
loSQLServer.ExecuteImmediate('SET ANSI_WARNINGS ON')
loSQLServer.ExecuteImmediate('SET ANSI_NULLS ON')

Any ideas? TIA.