Hi.
I have a complete script from a Database.
But when I try to execute this script (script.txt) from VB.NET shows me many errors. Basically, the special caracters (vbreturn, vbtab, etc.)
How execute this script or format the text to generate the database without problems?
Thanks 4all
IF it is a SQL script, you need a SQL interpreter to run the script.
You would use either OSQL.exe or SQLCmd.exe. (Refer to Books Online for complete syntax details.)
OSQL -S servername -U username -P password -i Scriptfile
Similar command line parameters for SQLCmd.exe
|||You could also tell us what the errors are, what VB object you are trying to use, etc. There are lots of different reasons why this won't work, but I am sure that it could be made to work. Using sqlcmd, osql, or isql would be the easiest way to go, (it changes from one version of SQL Server to the next for the past few versions
but SQLCMD is just a .NET program running your batches, so we can make it happen if you will describe more about your issues.
No comments:
Post a Comment