Hi,
I have a VPME form that creates a string and uses sqlExec to create a table in an MS SQL database.
If the sqlExec fails, I write the string to a file.
If I run SQL Server Management Studio, I can copy/paste the string to a query window and it executes with out error.
My connection from VPME to MS is using Trusted Connection, so I think I'm the same login as far as SQL is concerned. So it shouldn't make any difference if I'm executing the script from VPME or the query window.
So there are no syntax errors in the string. Therefore, it must be something to do with my connection string from VPME, but what can it be?
.