Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how to connect   vb with oracle?

Posted on 2001-07-15
2
Medium Priority
?
381 Views
Last Modified: 2008-03-06
how to connect   vb with oracle?
0
Comment
Question by:imranb35
2 Comments
 
LVL 6

Expert Comment

by:jpk041897
ID: 6284108
Take a look at:

http://support.microsoft.com/support/kb/articles/Q176/9/36.ASP


BTW, you would probably get a better response in the VB forum.
0
 

Accepted Solution

by:
hquoc earned 150 total points
ID: 6284464
Hi,
Y try using following way:
1. Create a service by Net8 Configuration Assistant utility to connect to database.
2. Then, Y can insert some snippet to create a database object:
 Set db = New Connection
 db.CursorLocation = adUseClient
 db.Open "Provider=MSDAORA.1;Password=" & Password & ";User ID=" & Username & ";Data Source=" & Service_name & ";Persist Security Info=True"
Where db is a variable declared in public for the project scope.
3. For each connection what y want to create to connect to oracle database can be used following:
for a selection query:
 Set rs = New Recordset
 rs.Open "Select * from Schema.TableName conditions", db
for a insert/update/delete query:
 db.Execute "Insert into Schema.TableName values(...)"
or
 db.Execute "Update Schema.TableName Set FieldName=Value, .."
or
 db.Execute "Delete from Schema.TableName where conditions"
and so on.
Also, y can operate data in the database by some other ways. But all cases, y have to create above database object(db).

I hope it will help y.
thank for ragards,
huuquoc  

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
Viewers learn about the scanner class in this video and are introduced to receiving user input for their programs. Additionally, objects, conditional statements, and loops are used to help reinforce the concepts. Introduce Scanner class: Importing…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
Suggested Courses
Course of the Month14 days, 21 hours left to enroll

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question