Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Scope of a Linked Server.

Author  Topic  hafeez Starting Member 14 Posts Posted - 2006-12-18 : 03:54:48 Hi All, I am trying to establish a connection from Oracle to MS SQL using linked server concept. For this linked server concept i am using the following document mentioned in the link. http://www.databasejournal.com/feat...10893_3442661_1 I am successfully able to create the linked server and do the communication like queries and insert. For the same query this linked server is not working some times, it gives the ORA-28500 error. Then i used to do the following commands. lsnrctl stop listenerDPVTESTDBLINK lsnrctl start listenerDPVTESTDBLINK tnsping DPVTESTDBLINK After doing this, some times it working and some times not. So, Please tell me why this behaves like this. Really I am frustrated abt this. Please help me so that it is not repeating this problem again. Thanks, Hafeez.