locked
ODP.NET connection problem?? RRS feed

  • Question

  • User-1104215994 posted

    Hi,

    I would like to connect to Oracle with ODP.NET as follows. How can I set which schema to look for???

    best Regards.

    Using destinationConnection As New Oracle.DataAccess.Client.
    OracleConnection
    ("Data Source=ServerName;User Id=userID;Password=Pass;")
    Thursday, August 11, 2011 7:39 AM

Answers

  • User-1104215994 posted

    I entered Schema.tableName it is fixed.

    Thanks

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 12, 2011 9:34 AM

All replies

  • User-1104215994 posted

    Now I am having this error:

    ORA-00604: error occurred at recursive SQL level 1

    ORA-06502: PL/SQL: numeric or value error: character string buffer too small

    ORA-06512: at line 8

    ORA-00942: table or view does not exist

    Thursday, August 11, 2011 8:01 AM
  • User-20777992 posted

    There remains a file named tnsnames.ora.

    It contains the information about the which schema it should refer to.

    It contains information about the same.

    It needs to be configured at the time of installation Oracle Client.

    We can later on to add/configure TNS Entries.

    Let me know if you need any further help!

    Thursday, August 11, 2011 8:03 AM
  • User-1104215994 posted

    Hi,

    I am not sure tnsnames.ora contains which schema to refer.

    Here is a sample

    ServerName=
      (DESCRIPTION=
        (ADDRESS=
          (PROTOCOL=TCP)
          (HOST=111.11.11.11)
          (PORT=1510)
        )
        (CONNECT_DATA=
          (SERVER=dedicated)
          (SERVICE_NAME=ServerName)
        )
      )


    Thursday, August 11, 2011 2:07 PM
  • User-1104215994 posted

    I entered Schema.tableName it is fixed.

    Thanks

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, August 12, 2011 9:34 AM