Q

How do I automatically create a database in Oracle using a VB app?

I have an application in Visual Basic involving Oracle as the database. While setting up the application, I want the database to be created automatically. How do I do that?
There are two ways to handle this, depending on what you have installed on the machine. If you have the Oracle command line SQL processing tools, you can include a SQL script that you'll spawn off to do the creation. If the command line tools are not available, you'll probably need to write a custom DLL or EXE that will connect using the Oracle database driver DLLs and do the table creation in your own code.
This was last published in September 2002

Dig Deeper on Windows Server and Network Security

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchServerVirtualization

SearchCloudComputing

SearchExchange

SearchSQLServer

SearchWinIT

SearchEnterpriseDesktop

SearchVirtualDesktop

Close