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.
| Author |
Topic |
|
travich
Starting Member
19 Posts |
 Posted - 2008-12-08 : 10:15:36
|
| I have created a linked server w/Oracle 9i client. When I do a test connect through ODBC DSN, the test connection is successful. However, I have a very bizarre issue:When I create/alter a stored procedure with an open query using that DSN, the query hangs. That's right -- not when I RUN, but when I create or alter. Isn't this SQL just inserted into the sysobjects table? If so, why would the openquery cause it to hang endlessly?Anyone know if my client install would be causing this issue? The open query is a very straight forward query... Please let me know your thoughts. |
|
|
|
|
|
Linked Server to Oracle -- Alter Sproc Hangs...