Answered by:
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;")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