ODBC connection from Unix to Windows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ODBC connection from Unix to Windows

  1. #1
    Join Date
    Nov 2000
    Posts
    42

    Question

    Hi!

    I've got installed Oracle 8.0.5 on a Unix machine (HP-UX 10.20),
    and an application running on Oracle.

    This application has its own database, with its own ORACLE_SID: XXX,
    and I can connect it via 'sqlplus' or 'server manager'.

    I would like to connect this database via ODBC from my Windows PC, and
    I've got some questions:

    +) In wich way must I modify 'listener.ora' and 'tnsnames.ora'?

    +) How can I start/stop 'listener' on Unix?

    +) On Windows, wich parameters must I set?

    Regards,
    ========
    LARRY ELLISON

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by l-ellison
    +) In wich way must I modify 'listener.ora' and 'tnsnames.ora'?
    The listener.ora file on the server does not need to change. The tnsnames.ora file must be configured so that you can connect to your database using sqlplus.


    +) How can I start/stop 'listener' on Unix?
    lsnrctl start
    lsnrctl stop


    +) On Windows, wich parameters must I set?
    On the windows side you must install the ODBC Driver and the Oracle client. Once you have configured the Oracle client (can connect through sqlplus), you must configure the ODBC driver as well and setup your data source.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

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



Click Here to Expand Forum to Full Width