how to run SQL script

M

Maileen

Hi,

I have a SQL script created under MS SQL 2000 and another one under
PostGreSQL 8.

Both of these scripts are simple text files.

how to can i run through my VB.net application, these scripts to perform
the script actions written in it ?

thanks a lot,
Maileen
 
K

Ken Tucker [MVP]

Hi,

You need to use osql to run a sql server 2000 script. I am not
sure about PostGreSql. I would use process.start to call osql to install
the script.

Ken
 

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

VB.net 2005 and database 1
Rule to Run a Script 4
VB.net + Retriving MS SQL Messages 2
Run SQL Scripts Files from ADP 4
Combine installation of SQL database with deployment of application 1
How to run multiple SQL Scripts from VB.net (Application_Start method in Global.asax) 1
Run SQL scripts from VB.NET 3
OL2003: Rules to "run a script" 2

Top