Results 1 to 3 of 3

Thread: Need Help connecting to oracle...

  1. Jan 23rd, 2003, 01:26 PM #1
    maheshu
    maheshu is offline

    Thread Starter
    New Member
    Join Date
    Jan 2003
    Posts
    5

    Need Help connecting to oracle...

    Hello,

    Can somebody tell the steps to connect to oracle..Actually i tried to do this way..Start-settings- control pannel-ODBC-user DSN-add--after this i am not sure what i should do..some where i read that i should select "Microsoft ODBC driver for oracle" but i don't have that driver..how do i setup the driver ..& can u please let me know the remaining steps to connect to oracle..

    Thank u..
    Reply With Quote Reply With Quote
  2. Jan 23rd, 2003, 03:55 PM #2
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    Using ODBC
    Code:
    oConn.Open "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword"
    Using OLEDB
    Code:
    For Standard Security

oConn.Open "Provider=OraOLEDB.Oracle;DataSource=MyOracleDB; User Id=myUsername;Password=myPassword"
 
For a Trusted Connection

oConn.Open "Provider=OraOLEDB.Oracle;DataSource=MyOracleDB;User Id=/;Password="
' Or
oConn.Open "Provider=OraOLEDB.Oracle;DataSource=MyOracleDB; OSAuthent=1"
    Last edited by Memnoch1207; Jan 23rd, 2003 at 03:59 PM.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  3. Jan 24th, 2003, 12:04 AM #3
    abhijit
    abhijit is offline
    PowerPoster abhijit's Avatar
    Join Date
    Jun 1999
    Location
    Chit Chat Forum.
    Posts
    3,228
    Also make sure that you Oracle NET Client installed on the machine from where you are trying to connect to Oracle.

    Cheers!
    Abhijit
    Everything that has a computer in will fail. Everything in your life, from a watch to a car to, you know, a radio, to an iPhone, it will fail if it has a computer in it. They should kill the people who made those things.- 'Woz'
    save a blobFileStreamDataTable To Text Filemy blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width