Asp & oracle


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Asp & oracle

  1. #1
    Sral Guest

    Asp & oracle


    Can any one please show me how to connect to an oracle 8i DB with ADO??
    Need the connection string...
    Do i have to do anyting else before connecting?

    Sral

  2. #2
    Paul Clement Guest

    Re: Asp & oracle

    On 26 Feb 2002 01:47:07 -0800, "Sral" <sral@netkom.voh> wrote:


    Can any one please show me how to connect to an oracle 8i DB with ADO??
    Need the connection string...
    Do i have to do anyting else before connecting?

    Sral

    You need to install and configure the Oracle client prior to connecting to an Oracle database.

    Here is a simple connection string which uses the Microsoft Oracle provider for OLEDB:

    objConn.Open "PROVIDER=MSDAORA;DATA SOURCE=OracleDB;","userid","password"

    The DATA SOURCE argument in this instance is a DSN created (in the Data Sources ODBC Manager Control
    Panel applet) to identify the name of your database.


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  3. #3
    Anthony Waung Guest

    Re: Asp & oracle



    There is several ways to do this. A good quick reference guide is:

    http://www.able-consulting.com/ADO_Conn.htm

    I hope it stays there.

    Anthony


    "Sral" <sral@netkom.voh> wrote:
    >
    >Can any one please show me how to connect to an oracle 8i DB with ADO??
    >Need the connection string...
    >Do i have to do anyting else before connecting?
    >
    >Sral



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center