Vb6 execute .sql file

How to Execute a SQL. Hello, I am trying to figure out the best way to make VB6 execute an auto-generated. Similar to the effect of pasting it into the Query Analyser, only automated. Anyone have a suggestion besides reformatting evey like and hard-coding it? Thanks a ton! See related articles to this posting. Kay Lee MySpace. Many script generation tools will place the "GO" delimiter into script files to tell QA where to split up the commands.

You'll need to parse the script and execute individual batches as you encounter GO batch delimiters. I m working on "light weight sql server" project. In oracle, you just put before the script name. I haven't been able to find out how to do it in sybase. Any help will be greatly appreciated.

Strange difference between SQL from. It thought I had found a way to randomly select records using SQL. So I built a stored procedure in Access and sure enough, it returns a random set of records. How do i execute a. Copy Code. Posted Apr pm Jagz W. Updated Apr pm Tarun. Add a Solution. Top Rated Most Recent. Accept Solution Reject Solution.

Posted Apr pm Om Prakash Pant. This is something I've never tested, but ADO should be able to handle multiple commands as a batch. It doesn't accept GO but it should accept semicolon. So basically if you convert GO's to semicolons it could work. You could try something like: C. Posted Apr am Wendelius. Add your solution here. OK Paste as. Treat my content as plain text, not as HTML. Existing Members Sign in to your account. This email is in use. Join Date Jul Posts 4. Sql Script Though Vb6.

July 13th, , AM 2. Re: Sql Script Though Vb6. July 13th, , AM 3. July 13th, , AM 4. July 13th, , AM 5. If it helped, then please rate the post by clicking "Rate this post"! July 14th, , AM 6. OpenTextFile App. Quick Navigation Visual Basic 6. NET Framework.