×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

connection to oracle database

connection to oracle database

connection to oracle database

(OP)
Hi everybody,
in my project (visual basic 6.0) i generally use MS SQL SERVER.
first time i ll try to connect to ORACLE database.
i have tried to see about connection Oracle here , but i couldnt find enough information.
can you tell me please what is the steps of connection Oracle databes. what is the connection string.
i have below information :

USER_ID
PASSWORD
HOST
PORT
SERVICE_NAME

thank you.

RE: connection to oracle database

I use something like this:

CODE

Dim Cn As ADODB.Connection

Set Cn = New ADODB.Connection
Cn.ConnectionString = "Driver={Microsoft ODBC for Oracle};" & _
            "SERVER=YoueServerHere; UID=USER_ID; PWD=PASSWORD"
Cn.CursorLocation = adUseClient
Cn.Open 

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

RE: connection to oracle database

Or since this isn't really a VB question you might try an Oracle forum.

RE: connection to oracle database

Can you just post the text of the error rather than a link. Not all of us are allowed to open external links like that

In order to understand recursion, you must first understand recursion.

RE: connection to oracle database

I'd expect Oracle to supply a "client" package with a decent OLEDB Provider anyway. That old ODBC Driver is pretty obsolete.

RE: connection to oracle database

In order to use ADODB, you need to add a reference to your VB6 Project:

Project - References - Microsoft ActiveX Data Object X.X Library

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close