Solved

how to connect   vb with oracle?

Posted on 2001-07-15
2
369 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 50 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
java 8 lambda expresssions exception handling 3 90
jar file executable 12 52
varialbe initialization 11 33
Detect Closed Loops (circles, figure-8s, etc) in PNG Images 6 33
INTRODUCTION Working with files is a moderately common task in Java.  For most projects hard coding the file names, using parameters in configuration files, or using command-line arguments is sufficient.   However, when your application has vi…
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…
The viewer will learn how to implement Singleton Design Pattern in Java.
This video teaches viewers about errors in exception handling.

772 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