Last post Aug 12, 2011 09:34 AM by cenk1536
Aug 11, 2011 07:39 AM|cenk1536|LINK
I would like to connect to Oracle with ODP.NET as follows. How can I set which schema to look for???
Using destinationConnection As New Oracle.DataAccess.Client.OracleConnection("Data Source=ServerName;User Id=userID;Password=Pass;")
Aug 11, 2011 08:01 AM|cenk1536|LINK
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
Aug 11, 2011 08:03 AM|asurani15|LINK
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!
Aug 11, 2011 02:07 PM|cenk1536|LINK
I am not sure tnsnames.ora contains which schema to refer.
Here is a sample
Aug 12, 2011 09:34 AM|cenk1536|LINK
I entered Schema.tableName it is fixed.