OSQL

  • Thread starter Thread starter nate axtell
  • Start date Start date
N

nate axtell

I would like to use the OSQL utility to run a *.SQL script from my VB.NET
application. What is the best way to call osql in the command prompt
fashion? Should I use WScript.Shell or is that for VBScript mainly? Any
other suggestions?
Thanks,
Nate
 
Why can't you just connect to SQL server, load your SQL script into a
Command object, and execute it directly?

Regards,
John Wadie
 
Hi,
Take a look at Process.Start()

"nate axtell" <naxtell at progeny dot net> wrote in message
I would like to use the OSQL utility to run a *.SQL script from my VB.NET
application. What is the best way to call osql in the command prompt
fashion? Should I use WScript.Shell or is that for VBScript mainly? Any
other suggestions?
Thanks,
Nate
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OSQL userName and Password Prompt. 11
process.start(filename), shell(filename) weird behavior 6
OSQL UserName and PWd 7
running SQL Scripts from VB.Net - is OSQL the best way? 2
SQL Server does not exist or access denied. 4
How to check Connection type? 2
Any way to capture errors from Shell command 8
Run sql server 2005 backup from VB.net 2005 3

Back
Top