Connect to Oracle database using VB 6.0

**Ariadne** · 19-01-2009

Hello Friends,

I have created an Oracle database, and I'd like to be able to write a VB6 front-end for it.
Does anyone know if you can use VB6 to connect to an Oracle db, and if so, do you know of any simple step-by-step examples that a newbie like myself could use to learn how to do it?

Thanks...

**opaper** · 19-01-2009

Try to use "Microsoft OLE DB Provider for Oracle" (in DataLink Properties),
then "Next>>" command button, and in "Enter a server name" you should have something like "T101" (your Oracle server name) and User name and password, if needed.
Just to connect your DataEnvironment to your Oracle DB.

In code in VB 6, to connect to your Oracle DB, you should have a connection string something like:

Code:

strCn = "Driver={Microsoft ODBC for Oracle};" & _
            "SERVER=T101;UID=MyID;PWD=MyPassWd"
    Set Cn = New ADODB.Connection
    Cn.ConnectionString = strCn
    Cn.CursorLocation = adUseNone
    Cn.Open

**MindSpace** · 19-01-2009

For more information about the database connectivity, you just go through with this,

http://www.johnsmiley.com/cis18/Smiley004.pdf

Hope, this will help you.