Added SP2 now have linked server error

27 Nov 2007 3:11 PM

TLuebke

I added SP2 to my 2005 server and now I can't connect to a previously working
linked Oracle server. I get this:

TITLE: Microsoft SQL Server Management Studio
------------------------------

"The test connection to the linked server failed."

Cannot initialize the data source object of OLE DB provider "MSDAORA" for
linked server "ISRSREPLICATEDLINK".
OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
message "Error while trying to retrieve text for error ORA-01019
". (Microsoft SQL Server, Error: 7303)

What could have changed? Testing the connection via the ODBC works but
inside of SQL MAnagement Studio it fails.

27 Nov 2007 3:15 PM

TLuebke

Also somewhere in troubleshooting this I saw an error about unable to
allocate user side memory.

Show quote

"TLuebke" wrote:

> I added SP2 to my 2005 server and now I can't connect to a previously working
> linked Oracle server. I get this:
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> "The test connection to the linked server failed."
>
> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
> linked server "ISRSREPLICATEDLINK".
> OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
> message "Error while trying to retrieve text for error ORA-01019
> ". (Microsoft SQL Server, Error: 7303)
>
> What could have changed? Testing the connection via the ODBC works but
> inside of SQL MAnagement Studio it fails.
>
>
>
>

27 Nov 2007 4:44 PM

Russell Fields

TLuebke,

Have you tried reinstalling your Oracle provider? I did some research, but
no clear indication of what your problem is. One interesting thing is that
http://technet.microsoft.com/en-us/library/bb332055.aspx suggests using the
Oracle provider for OLE DB (OraOLEDB.Oracle.1) rather than MSDAORA, in case
that is useful to you.

RLF

Show quote

"TLuebke" <TLue***@discussions.microsoft.com> wrote in message
news:57778530-E08D-46F2-ADD9-0D7D31236C74@microsoft.com...
> Also somewhere in troubleshooting this I saw an error about unable to
> allocate user side memory.
>
> "TLuebke" wrote:
>
>> I added SP2 to my 2005 server and now I can't connect to a previously
>> working
>> linked Oracle server. I get this:
>>
>> TITLE: Microsoft SQL Server Management Studio
>> ------------------------------
>>
>> "The test connection to the linked server failed."
>>
>> Cannot initialize the data source object of OLE DB provider "MSDAORA" for
>> linked server "ISRSREPLICATEDLINK".
>> OLE DB provider "MSDAORA" for linked server "ISRSREPLICATEDLINK" returned
>> message "Error while trying to retrieve text for error ORA-01019
>> ". (Microsoft SQL Server, Error: 7303)
>>
>> What could have changed? Testing the connection via the ODBC works but
>> inside of SQL MAnagement Studio it fails.
>>
>>
>>
>>