Hi every one. I have created on sql script from sql server 2000. Now my problem is to make one exe file for executing the same script (could be in anylanguage). I know how to run sql script through query
analyzer but i want to create one exe(executable file) for the script.
as this is done in many languages (and i dont know how its done) brief explanation with coding examples will be very helpful. As i need to give this exe to the client in 2 days.

Thanks and regards
S.G.Sandeep

Hi sandeep!

I have a Visual Basic 6.0 Code to do this with OSQL. You can use OSQL in C, C++ and VC++. The hint to do in VB is -

Visual Basic 6.0 Code :
-------------------------------------------------------
Private Sub Command1_Click()
' Take user inputs in form


shell "osql -U" & user & " -P" & passwd & "-S" & server & " -i" & sqlfile_path & " -o" & file_path_out & "-d" & Database , vbHide

End Sub
-------------------------------------------------------
In the above Code -

sqlfile_path : SQL File which u want to execute.
file_path_out : Path where results are stored.

Use COMDLG32 to Browse SQL File and use TEXTBOX control to input Server, Database, Login and Password. Create EXE and deliver to your client.


If you are not able to do the Visual Basic Code, mail me at - [email protected] to get the Full Source Code for this. But, I think my Hint is enough for a developer.

Reply soon ...

Can I Get the full code??? Please??