ODP.NET connection problem??

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;")

Answer 1

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

Answer 2

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!

Answer 3

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)
    )
  )

Answer 4

User-1104215994 posted

I entered Schema.tableName it is fixed.

Thanks