Results 1 to 3 of 3

Thread: SQL Connection

  1. #1
    Funking Prink! Raz316's Avatar
    Join Date
    Jul 2003
    Location
    Deal, Kent, UK
    Posts
    2,978
    Thanks
    130
    Thanked
    62 times in 52 posts

    SQL Connection

    Red Hat Advanced Server 2.1 - Oracle SQLPlus 9.2.0.4

    Im looking to enable remote sql connections to our server (specifically, an ODBC connection to it, so I can run reports via MS Access). When I try and create the ODBC connection, I get a 'sql server doesnt exist or access denied' error, this is no big suprise as I'd expect remote access to be off by default.

    Anyways, anyone know where I should be looking to turn network access back on?

    Cheers

  2. #2
    Registered User
    Join Date
    Jul 2004
    Posts
    8
    Thanks
    0
    Thanked
    0 times in 0 posts
    Been a long time since i worked on Oracle DBs (3-4 years) but 2 things to look at:

    Listener service: Obviously make sure this up and running + properly configured.
    Client: check your TNSNAMES.ORA, this holds the connection information for the Oracle databases. Make sure the Name, IP/DNS and port information match with what the listener is set to.

  3. #3
    Funking Prink! Raz316's Avatar
    Join Date
    Jul 2003
    Location
    Deal, Kent, UK
    Posts
    2,978
    Thanks
    130
    Thanked
    62 times in 52 posts
    woops, should have reposted to say we sorted it

    What you suggested was all i needed to do, I was going about it totally the wrong way

    Thanks anyway

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need internet connection, £20
    By serlex in forum Networking and Broadband
    Replies: 31
    Last Post: 14-05-2004, 10:03 PM
  2. mandrake 10.0 dial-up connection...?
    By cm_uk in forum Software
    Replies: 0
    Last Post: 02-05-2004, 10:29 PM
  3. Internet connection sharing... sharing
    By MDC in forum Networking and Broadband
    Replies: 1
    Last Post: 28-04-2004, 09:51 PM
  4. Dropped connection is p***ing me off
    By ACiD303 in forum Networking and Broadband
    Replies: 8
    Last Post: 21-11-2003, 08:51 AM
  5. SQL help
    By Agent in forum Software
    Replies: 23
    Last Post: 11-11-2003, 09:22 AM

Posting Permissions

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