Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Run SQL Scripts
Message
 
 
To
24/11/2005 23:37:42
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01072007
Message ID:
01072017
Views:
19
>But if i run the scrit from VFP, get this error, "...OLE DB Provider for SQL Server: Incorrect syntax near 'Create' ..., but if i run it in SQL Query Analyser it works without any error.

Do you have batch separater 'GO' in the script? The 'GO' is QA command not T-SQL.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform