Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Posts
    19

    Unanswered: Accessing oracle database

    Hi Guys,

    I have a oracle database out on my company's network which i need to access.

    1. I have the IP address of where this oracle database is located.
    2. I have the name of the database
    3. I have username and password


    How do i connect to this database. What all do i need to set up the enviroment on my computer to access this database.

    Please walk me through.

    TIA

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink

    1) You need to install the Oracle Client
    2) You will need the 'port' number used by the database listener.
    3) Configure the connection with NET8 Configuration Assistant.
    4) Add an Oracle connection to ODBC with MS ODBC manager
    5) Use a tool like SQL*Plus, MS Access, MS Excel or any other SQL tool to access the data.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2003
    Posts
    19
    Hi thanks for the prompt reply..

    i installed the oracle client. This is my first time...I tried my best to configure the Net8 COnfiguration assisstant correctly.

    When i tried to add an oracle odbc connection using MS ODBC manager i got this error:

    unable to connect
    SQL State=S1000
    [oracle][ODBC][ora]ORA-12537: TNS:Connection Closed.

    Did i do something wrong while configuring the client.

    Please assist me with any further suggestions.

    TIA

  4. #4
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713
    Did you test the connection with NET8?

    Make sure that in MS ODBC you choose the correct Oracle client! (MS has an oracle ODBC client that does not work properly).

    In any case, execute the Oracle NET Manager (NOT the NET8 configuration assistant) and check if the connection info was created correctly: service name, protocol(TCP/IP), host name(or IP Address) and PORT NUMBER(normally 1521); if not correct, you can change it and try again.

    Also do the following to check connectivity:
    - Open a command window: Start>Run>cmd
    - Issue the following command: tnsping <service-name>

    Good luck!.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  5. #5
    Join Date
    Jul 2004
    Posts
    5
    Hi TIA,

    Did you create a system DSN for the oracle server?. U can do it by invoking the ODBC Data source administrator, and then adding a system DSN in the System DSN tab. There u can choose to add a new one and select Microsoft ODBC for Oracle.

    You will have 4 fields in there . They are

    1. Data source name (Any Name)
    2. Description (Any description)
    3. Username (Username with which you will connect to the database)
    4. Server name (Add the TNS Names Entry you created through the Net8 Manager).

    Try now and check ur luck.

    Luv
    Magesh

  6. #6
    Join Date
    Sep 2003
    Posts
    19
    Thanks for the reply guys...i could connect to the database out on the network and the test connection was successful. I could also add the user DSN successfully.

    Now the only thing left out is to pass the correct conenction string in my ASP code using this user DSN to access the database. Can anyone suggest me this string...

    Thanks so much for all your suggestions.

  7. #7
    Join Date
    Jul 2004
    Posts
    5

    Smile

    Frnd,

    I think you can only use the DSN name you have created. You cannot use the connect string you have created in Net8 Manager.

    Please use this URL to find more information on that topic

    http://support.microsoft.com/default...b;en-us;313062

    Best Of Luck
    Magesh

Posting Permissions

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