DIGIT-ARC read-only archive · snapshot: July 23, 2026

Urgent help needed!!! how to meke VB interact with SQL*Plus?

3 posts · originally from https://geek.digit.in/community/threads/urgent-help-needed-how-to-meke-vb-interact-with-sql-plus.102324/

Chetan1991
Chetan1991 Original post #1
Nov 17, 2008 at 9:05 PM
Hi guys!!
I need urgent help!!!
i need some visual basic 6.0 code which can open SQL*Plus (of Oracle 9i), login with username 'scott' and password 'tiger', create some tables and even enter data in them and save them to the database.
Actually i have to finish my final term IP project consisting of an application with Oracle as the back end and VB as Front end,the database consisting of a bunch of tables linked and the front end being able to query and modify the tables etc. Please help me,i've got only 2 days!!:sad:!!!
QwertyManiac
Nov 17, 2008 at 11:54 PM
Why do you wanna open SQL Plus for doing that? Haven't they thought you to connect to the database directly?

Here are several examples for connecting to it (I'd prefer the ADO method): *www.orafaq.com/faqmsvb.htm
Chetan1991
Nov 22, 2008 at 3:56 PM
Thanks Qwertymaniac!