Link Server between Oracle and SQL Server error

This message appears :
"Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
[OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
tool installed with Oracle client) it connects correcty to Oracle Database.
Unfortunatelly, when I want create a "linked server" and I click on "tables"
this message appears !?
Who can help me ?Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
you're running 7.x?
"Olivier TACKELS" wrote:
> This message appears :
> "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
> [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
> My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
> tool installed with Oracle client) it connects correcty to Oracle Database.
> Unfortunatelly, when I want create a "linked server" and I click on "tables"
> this message appears !?
> Who can help me ?
>|||You not only have an Oracle issue, there is also an MDAC issue. I have seen
that and similar issues when upgrading from MDAC 2.2-5 to MDAC2.6-7.
MS's Oracle drivers and interfaces are based on Oracle 8.1.7.6 from MDAC 2.5
on. Your client MDAC needs to be in sync with your db server mdacs.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
> > This message appears :
> > "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
> > [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
> >
> > My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> > Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
> > tool installed with Oracle client) it connects correcty to Oracle Database.
> > Unfortunatelly, when I want create a "linked server" and I click on "tables"
> > this message appears !?
> >
> > Who can help me ?
> >
> >|||Additional thought:
What release is your Oracle database? The 10g ones won't even talk to
Oracle 7x (or 8.0.x). If your Oracle is 10g, then you definitely need to
look at MDAC and SQL*NET.
--
Joseph R.P. Maloney, CSP,CCP,CDP
"fnguy" wrote:
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
> > This message appears :
> > "Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error trace
> > [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ]."
> >
> > My server is a Windows 2000 Server SP4, with SQLServer Enterprise SP3a.
> > Oracle client 7.3.3.5.0 had been installed. When I use SQL Plus 3.3 (Little
> > tool installed with Oracle client) it connects correcty to Oracle Database.
> > Unfortunatelly, when I want create a "linked server" and I click on "tables"
> > this message appears !?
> >
> > Who can help me ?
> >
> >

Limiting traces in Profiler

I've opened a trace in Profile, and now want to limit the results based on
the TextData field. I've setup a filter for "textdata not like exec
some_existing_sp" and that worked fine.
How is a "or" added here, if possible?
I'd like a filter something like "textdata not like (exec some_existing_sp)
or (exec some_existing_sp2)".
Or and "()" don't seem to work though.
Marco
Close and expand the 'NOT LIKE' and you should get another input box.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:uQLNEDl4GHA.1248@.TK2MSFTNGP03.phx.gbl...
> I've opened a trace in Profile, and now want to limit the results based on
> the TextData field. I've setup a filter for "textdata not like exec
> some_existing_sp" and that worked fine.
> How is a "or" added here, if possible?
> I'd like a filter something like "textdata not like (exec
> some_existing_sp)
> or (exec some_existing_sp2)".
> Or and "()" don't seem to work though.
> Marco
>

Limiting traces in Profiler

I've opened a trace in Profile, and now want to limit the results based on
the TextData field. I've setup a filter for "textdata not like exec
some_existing_sp" and that worked fine.
How is a "or" added here, if possible?
I'd like a filter something like "textdata not like (exec some_existing_sp)
or (exec some_existing_sp2)".
Or and "()" don't seem to work though.
MarcoClose and expand the 'NOT LIKE' and you should get another input box.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:uQLNEDl4GHA.1248@.TK2MSFTNGP03.phx.gbl...
> I've opened a trace in Profile, and now want to limit the results based on
> the TextData field. I've setup a filter for "textdata not like exec
> some_existing_sp" and that worked fine.
> How is a "or" added here, if possible?
> I'd like a filter something like "textdata not like (exec
> some_existing_sp)
> or (exec some_existing_sp2)".
> Or and "()" don't seem to work though.
> Marco
>

Limiting traces in Profiler

I've opened a trace in Profile, and now want to limit the results based on
the TextData field. I've setup a filter for "textdata not like exec
some_existing_sp" and that worked fine.
How is a "or" added here, if possible?
I'd like a filter something like "textdata not like (exec some_existing_sp)
or (exec some_existing_sp2)".
Or and "()" don't seem to work though.
MarcoClose and expand the 'NOT LIKE' and you should get another input box.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:uQLNEDl4GHA.1248@.TK2MSFTNGP03.phx.gbl...
> I've opened a trace in Profile, and now want to limit the results based on
> the TextData field. I've setup a filter for "textdata not like exec
> some_existing_sp" and that worked fine.
> How is a "or" added here, if possible?
> I'd like a filter something like "textdata not like (exec
> some_existing_sp)
> or (exec some_existing_sp2)".
> Or and "()" don't seem to work though.
> Marco
>