Sql Script

[Samarendra]

How to execute a Sql Script file Using Vb 6.

[AIS4U]

Samarendra:

Welcome to VB Forum.

How to execute a SQL Script file.

What is an SQL Script file?

Do you mean a SQL Query such as:

Select * From xxx ?

I think you need to tell us a little bit more such as what type of database you are using and what kind of information you want to retrieve from the database.

Give a little more information and I am sure someone can help you.

Thanks

[szlamany]

We use only .SQL script files - these are notepad-like text files typed into QUERY ANALYZER and SAVED - .SQL is the file extension of these files.

Is this what you are referring to?

The OSQL command (DOS-command line) will process these .SQL files - run them into a server as if you are in QA and executing them

You could SHELL the OSQL command to run the .SQL script.