#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Posts
    33
    Rep Power
    11

    Question Connecting to an Oracle Database Programmatically Visual Studio NET ?


    Hi

    i need help. Iam searching now for a week about a solution, tutorial, help or hint.

    Iam new into Oracle. I got lot of experience with MySQL but i dunno how i can connect via Visual Studio NET or c++ to the Oracle database and about what i should take care.

    Anyone can help with a code or Tutarial..

    Many thx in advance

    Indian
    Last edited by Indian; September 18th, 2003 at 07:17 AM.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Brick City, NJ, USA
    Posts
    11
    Rep Power
    0
    Have you tried using the Server Explorer

    The Server Explorer
    Your starting point for developing database applications with VB.NET is the Server Explorer. This
    toolbox is your gateway to the databases on your system or network, and you can use it to locate and
    retrieve the tables you’re interested in. Place the pointer over the Server Explorer tab to expand the
    corresponding toolbox, which looks something like the one shown in Figure 20.5. The two main
    objects in the Server Explorer are Data Connections and the Servers object. Under the Data Connections
    branch, you will see the connections to databases you’re programming against. Under the
    Servers branch, you will see the database servers you can access from your computer and various
    objects they expose.


    Or have you tried setting up a System DSN ODBC Data Source in your control panel, so then you can just reference that name in your program.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Brick City, NJ, USA
    Posts
    11
    Rep Power
    0
    Also included with Oracle if install on a machine that you have access to is C++,VC++, JDBC,ODBC, and other device drivers(*.dll's) and header files that you can use to access the database. Found in sub folders of OraHOME directory, using named com,plsql,oci,odbc,jdbc, etc... and other folders also.

IMN logo majestic logo threadwatch logo seochat tools logo