1 2 Previous Next 20 Replies Latest reply on Nov 8, 2005 12:50 PM by 466436 Go to original post
      • 15. Re: ODBC Error
        JustinCave
        When you invoke tnsping, it should specify which tnsnames.ora file it is using. Does it specify the file you expect?

        Are you sure that the service_name is ORCL.WORKGROUP? Generally, the service_name would be just ORCL.

        Can you ping "grapevin-pnanmy"?

        Justin
        Distributed Database Consulting, Inc.
        http://www.ddbcinc.com/askDDBC
        • 16. Re: ODBC Error
          chukwuma10
          Try reconfiging your ODBC again like this

          To create a system DSN:
          Open the ODBC Data Source Administrator � Click Start; point to Settings, Control Panel, and Administrative Tools; click Data Sources.
          Click the System DSN tab.
          Click Add.
          Select Microsoft ODBC for Oracle Driver and click Finish.
          A Microsoft ODBC for Oracle Setup dialog box is displayed with four text boxes.
          Enter the following values:
          Data Source Name: db1test [DSN_NAME]
          Description: (you may add a description or leave this blank)
          User Name: scott [DB_USERNAME]
          Server: db1.intersystems.com [SERVICE_NAME]


          Download a third party software to test your connection first WinSQL at: http://www.indus-soft.com/winsql. Download the version without oracle driver. In stall by following the instruction and config it thus

          To test with WinSQL:
          Start WinSQL or WinSQL Lite.
          Click File.
          Click New Connection.
          An ODBC Data Source dialog box is displayed with several text boxes.
          Enter the following values:
          Data Source Name: db1test [DSN_NAME]
          User ID: scott [DB_USERNAME]
          Password: tiger [DB_PASSWORD]
          Database Type: Generic ODBC
          Click OK.
          Click the Query tab.
          Enter the query: SELECT ename, job FROM scott.emp WHERE JOB = �CLERK�
          Press ALT+X to execute the query.
          Click the Result tab, which shows:

          ENAME JOB
          ---------- ---------
          SMITH CLERK
          ADAMS CLERK
          JAMES CLERK
          MILLER CLERK

          4 Row(s) affected


          to test connection to the DB


          • 17. Re: ODBC Error
            338055
            When you invoke tnsping, it should specify which
            tnsnames.ora file it is using. Does it specify the
            file you expect?

            Are you sure that the service_name is ORCL.WORKGROUP?
            Generally, the service_name would be just ORCL.

            Can you ping "grapevin-pnanmy"?

            Justin
            Distributed Database Consulting, Inc.
            http://www.ddbcinc.com/askDDBC
            Okay, silly me! I should have noticed that. It says it's using this file:

            C:\oracle\ora10gds\network\admin\sqlnet.ora

            I'm pretty green with all this (as I'm sure is obvious), but I was under the impression it would be using a file called tnsnames.ora! So what is the best route from here, to edit the sqlnet.ora, or to reconfigure something to point to the proper tnsnames.ora? If the latter, how do I do that?

            Thank you!

            Owen Gibbins

            PS: My apologies for being so slow to respond on my own thread. I have been working on this project only sporadically.
            • 18. Re: ODBC Error
              466436
              Hi All,

              I am also facing the same error when i try to install..Oracle 10g (RAD)..any help ?

              I am using Windows 2000 Prof and want to access Remote database but use Forms/Report to develop....my other colleagues were able to install it and no problem with the ODBC....but i dont know why its not working on my machine.

              Thanks in advance.

              Urooj R Khan
              • 19. Re: ODBC Error
                464312
                rename your sqlnet.ora to sqlnet.bak
                Make sure your tnsnames file is correct and you can do a tnsping to the database.
                Let me know what the response is.
                • 20. Re: ODBC Error
                  466436
                  Thanks for reply.

                  I did install now COMPLETE SUITE and did tnsping for my remote db0.hct.ac.ae: its going to t:/or92/network/admin/slqnet.ora
                  (this is a shared drive)

                  it works fine..but my ODBC driver gets corrupted....its no more letting me connect ??

                  it doesnt let me go into Net Manager or Net Assistant also ?

                  what do i do now ?

                  Message was edited by:
                  user463433
                  1 2 Previous Next