network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 9 months |
| seen | Jun 4 at 8:10 | |
| stats | profile views | 2 |
|
May 30 |
comment |
Oracle database link via ODBC to SQL Server does not recover automatically OK, I will try to analyse the logfiles, and come back to you after that. Do you have a link which lists the 12+ ODBC errors? |
|
May 29 |
revised |
Oracle database link via ODBC to SQL Server does not recover automatically added 399 characters in body |
|
May 29 |
comment |
Oracle database link via ODBC to SQL Server does not recover automatically "Hence drop and recreate the dblink does not affect or change the network or ODBC problem": my practical experience proves this wrong. The only remedy for the persisting error messages is a drop and re-create of the database link. But you are right: Oracle does not open or check the connection when the link is created; only when the first statement is executed, a connection is created. I've updated the post according to this fact. |
|
May 29 |
comment |
Oracle database link via ODBC to SQL Server does not recover automatically the setting seems OK, HS=OK was set. Can you clarify the second point in your post? What do you mean by "without causing any issue"? Also "when the link is requested again", do you mean reused by a query? And "drop and re-creation does not have any sense", in which way? To me it works, but in my oppinion it should not be the route to go. |
|
May 29 |
asked | Oracle database link via ODBC to SQL Server does not recover automatically |
|
May 25 |
awarded | Informed |
|
Feb 20 |
awarded | Popular Question |
|
Sep 20 |
revised |
ora-01410 invalid RowID sporadically in a select statement added 114 characters in body |
|
Sep 20 |
awarded | Scholar |
|
Sep 20 |
accepted | ora-01410 invalid RowID sporadically in a select statement |
|
Sep 20 |
comment |
ora-01410 invalid RowID sporadically in a select statement That's it! The system started an index rebuild while the select statement ran. |
|
Sep 18 |
awarded | Supporter |
|
Sep 17 |
comment |
ora-01410 invalid RowID sporadically in a select statement Nice pointer, I will investigate this in more detail, and come back to you in a short while. |
|
Sep 17 |
comment |
ora-01410 invalid RowID sporadically in a select statement @ypercube: yes I am sure, our exception handling writes the error code and the causing statement into a log-file. |
|
Sep 17 |
revised |
ora-01410 invalid RowID sporadically in a select statement added 37 characters in body |
|
Sep 17 |
awarded | Editor |
|
Sep 17 |
revised |
ora-01410 invalid RowID sporadically in a select statement added 3 characters in body |
|
Sep 17 |
awarded | Student |
|
Sep 17 |
asked | ora-01410 invalid RowID sporadically in a select statement |
|
Aug 31 |
awarded | Teacher |
