April 4, 2013 at 9:08 am
We have a peculiar issue in SQL Server 2005. When we try to access the Providers under linked servers in SSMS (Management Studio), we are unable to view the providers and in the sessions (sp_Who2) we are seeing that the stored procedure xp_enum_oledb_providers is running. There are different applications using Oralce linked servers (user created) are showing up as running (but now getting completed). All the sessions are displayed as running and when the Max threads (128) are reached the Server is not responding.
Help on this is much appreciated
April 5, 2013 at 4:15 am
Hi,
I am also having the exact issue in my project. lets hope if we could have any solution for the same issue
April 8, 2013 at 10:14 am
I've had a similar issue for 2 different situations in the past.
1) The base oracle client had been installed, but the server not rebooted post install. (SQL+ was fine querying)
2) The Oracle drivers (10g) had been installed and not been patched correctly.
Hope any of the above is useful.
Cheers
April 8, 2013 at 10:30 am
We have resolved this issue by copying the DLL xpstar90.dll from the other instance of the same version 2005 SP3.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply