connection to oracle database

[baran121]

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.

 

[fredericofonseca]

http://www.connectionstrings.com/

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886

 

[Andrzejek]

I use something like this:

Dim Cn As ADODB.Connection

Set Cn = New ADODB.Connection
Cn.ConnectionString = "Driver={Microsoft ODBC for Oracle};" & _
            "SERVER=[blue]YoueServerHere[/blue]; UID=[blue]USER_ID[/blue]; PWD=[blue]PASSWORD[/blue]"
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.

 

[dilettante]

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

 

[baran121]

hi Andrzejek,
when i used your connection link.
i got the error folloving attachment.
plz help me..

 

[taupirho]

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.

 

[dilettante]

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

 

[Andrzejek]

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.