Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: cionnect to oracle

    I want to connect to oracle in asp 3.0
    please help me

  2. #2
    Join Date
    Nov 2003
    Christchurch, New Zealand
    it depends in the method you are using to connect, but here are the details for using ODBC (uncomment the string you require and change to include your database details).
    Dim oConn
    set oConn = Server.CreateObject("ADODB.Connection")
    'For the current Oracle ODBC Driver from Microsoft
    'oConn.Open "Driver={Microsoft ODBC for Oracle};;Uid=myUsername;Pwd=myPassword"
    'For the older Oracle ODBC Driver from Microsoft
    'oConn.Open "Driver={Microsoft ODBC Driver for Oracle};;Uid=myUsername;Pwd=myPassword"
    ' ODBC Driver for Oracle - from Oracle 
    'oConn.Open "Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword"
    Connection strings taken from

Posting Permissions

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