ASP Connection String for Oracle 10g

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nsung
    New Member
    • Feb 2008
    • 5
    #1

    ASP Connection String for Oracle 10g

    Recently we upgraded to Oracle 10g and added encryption on the server.

    I used to access the database tables via Active Server Pages with the following connection string: MyConnection.op en "DSN=eisreport; Uid=eiu_sung;Pw d=xxxxx"

    After upgrading to 10g it stop working with the following error message.

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
    /reports/reports.asp, line 47 (the line indicates the above connection string)


    The following three lines were added to 'sqlnet.ora' when upgrading the oracle client.

    SQLNET.ENCRYPTI ON_TYPES_CLIENT = RC4_256
    SQLNET.ENCRYPTI ON_CLIENT= required
    SQLNET.CRYPTO_S EED=LDFKANTEJTE 8232AFDFDEDFD

    So I think the problem may related to the encryption feature.
    I have no idean where to fix. Can I still use ASP? or Do something in IIS???
    Any assistance would be greatly appreciated.

    I guess this has to do with migration to the 10g.
    Tags: None
    • markrawlingson
      Recognized Expert Contributor
      • Aug 2007
      • 346
      #2
      I personally have 0 experience working with oracle. Here's a couple resources for you though.

      http://ora-12154.ora-code.com/

      Invalid URL
      http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14212/troublestng.htm#BABBBGGG

      Invalid URL
      http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14219/net12150.htm#ORA-12154

      Invalid URL
      http://download-uk.oracle.com/docs/cd/B19306_01/gateways.102/b16222/net.htm#sthref484


      I also have a tiny inclination that it could be your System DNS configuration. Maybe a driver problem? Try updating the oracle driver, creating a new System DNS configuration, rebooting the server, and then trying it out.

      Hope that helps, if not - I'll move this thread to the oracle forum where you'll likely get more help.

      Sincerely,
      Mark

        Comment

        • nsung
          New Member
          • Feb 2008
          • 5
          #3
          Thank you Mark!

          I am able to link tables from within MS-Access at the same machine where the ASPs are, which indicates DSN and the Driver had been installed correctly.

          I already posted the same message to the ORACLE forum. Thank you!

            Comment

            • markrawlingson
              Recognized Expert Contributor
              • Aug 2007
              • 346
              #4
              Originally posted by nsung
              Thank you Mark!

              I am able to link tables from within MS-Access at the same machine where the ASPs are, which indicates DSN and the Driver had been installed correctly.

              I already posted the same message to the ORACLE forum. Thank you!
              No problem. In the future please don't double post questions though.

              I'll move this thread.

              Sincerely,
              Mark

                Comment

                • jhardman
                  Recognized Expert Specialist
                  • Jan 2007
                  • 3405
                  #5
                  Originally posted by nsung
                  Thank you Mark!

                  I am able to link tables from within MS-Access at the same machine where the ASPs are, which indicates DSN and the Driver had been installed correctly.

                  I already posted the same message to the ORACLE forum. Thank you!
                  I also think it's a dsn problem. Did you update the dsn entry after updating?

                    Comment

                    Previous template Next
                    Working...