Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 19-01-2009
Member
 
Join Date: Dec 2008
Posts: 10
Connect to Oracle database using VB 6.0

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...
Reply With Quote
  #2  
Old 19-01-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: Connect to Oracle database using VB 6.0

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
Reply With Quote
  #3  
Old 19-01-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Connect to Oracle database using VB 6.0

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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Connect to Oracle database using VB 6.0"
Thread Thread Starter Forum Replies Last Post
Connect To Remote Oracle Database with Toad Eashta^devata Software Development 2 30-08-2011 11:09 PM
The synonyms in oracle database Norse Software Development 4 02-02-2010 10:46 PM
Different processes in oracle database Aileen_L Software Development 4 01-02-2010 04:38 PM
Managing oracle 9i Database Landan Software Development 3 21-01-2010 11:05 AM


All times are GMT +5.5. The time now is 12:03 AM.