Solved

how to connect   vb with oracle?

Posted on 2001-07-15
2
372 Views
Last Modified: 2008-03-06
how to connect   vb with oracle?
0
Comment
Question by:imranb35
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

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…
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

728 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