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:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
|||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:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
Showing posts with label appears. Show all posts
Showing posts with label appears. Show all posts
Monday, March 26, 2012
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 tra
ce
> [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x800040
05: ]."
> 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 (Littl
e
> tool installed with Oracle client) it connects correcty to Oracle Database
.
> Unfortunatelly, when I want create a "linked server" and I click on "table
s"
> 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:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>|||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:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>
"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 tra
ce
> [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x800040
05: ]."
> 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 (Littl
e
> tool installed with Oracle client) it connects correcty to Oracle Database
.
> Unfortunatelly, when I want create a "linked server" and I click on "table
s"
> 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:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>|||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:
[vbcol=seagreen]
> Oracle doesn't support 7.x anymore, or 8x for that matter. Are you sure
> you're running 7.x?
> "Olivier TACKELS" wrote:
>
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 ?
> >
> >
"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 ?
> >
> >
Friday, March 23, 2012
Link for 'Compare the Editions'
Hi,
Does anyone have a link for the 'Compare the Editions' Page for SQL 2000? It
appears Microsoft are now only showing the 2005 version page.
Thanks - Ian.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
--
HTH. Ryan
"Ian Samuels" <iasamuels@.hotmail.com> wrote in message
news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
> It appears Microsoft are now only showing the 2005 version page.
> Thanks - Ian.
>|||Hi Ryan,
Thanks but I'm after a comparison of the features - I need to compare SQL
2000 Standard Edition to Workgroup Edition and there was a page similar to
the SQL 2005 page
(http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) that
seems to have gone.
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:ewzZnWCRGHA.6084@.TK2MSFTNGP14.phx.gbl...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> --
> HTH. Ryan
>
> "Ian Samuels" <iasamuels@.hotmail.com> wrote in message
> news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
>> It appears Microsoft are now only showing the 2005 version page.
>> Thanks - Ian.
>|||Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
> Hi Ryan,
> Thanks but I'm after a comparison of the features - I need to compare SQL
> 2000 Standard Edition to Workgroup Edition and there was a page similar to
> the SQL 2005 page
> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)
> that seems to have gone.
All I could find in a similar format is this:
http://www.servepath.com/servers/win_sqlserver.htm
I didn't even realise there was a 2000 Workgroup edition.
Dan|||Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
>> Hi Ryan,
>> Thanks but I'm after a comparison of the features - I need to compare SQL
>> 2000 Standard Edition to Workgroup Edition and there was a page similar
>> to the SQL 2005 page
>> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) th
>> at seems to have gone.
Also found this (forgot all about WebArchive!)
http://web.archive.org/web/20050323020459/http://www.microsoft.com/sql/evaluation/features/choosing.asp
It's slow, but it's the last version of the 2000 comparison page that was
put up in March 2005 :)
Dan|||Ah yeh - great - cheers Dan.
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message
news:uZLPcHERGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
>> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
>> Hi Ryan,
>> Thanks but I'm after a comparison of the features - I need to compare
>> SQL
>> 2000 Standard Edition to Workgroup Edition and there was a page similar
>> to the SQL 2005 page
>> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)
>> th
>> at seems to have gone.
> Also found this (forgot all about WebArchive!)
> http://web.archive.org/web/20050323020459/http://www.microsoft.com/sql/evaluation/features/choosing.asp
> It's slow, but it's the last version of the 2000 comparison page that was
> put up in March 2005 :)
> Dan
>
Does anyone have a link for the 'Compare the Editions' Page for SQL 2000? It
appears Microsoft are now only showing the 2005 version page.
Thanks - Ian.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
--
HTH. Ryan
"Ian Samuels" <iasamuels@.hotmail.com> wrote in message
news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
> It appears Microsoft are now only showing the 2005 version page.
> Thanks - Ian.
>|||Hi Ryan,
Thanks but I'm after a comparison of the features - I need to compare SQL
2000 Standard Edition to Workgroup Edition and there was a page similar to
the SQL 2005 page
(http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) that
seems to have gone.
Thanks.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:ewzZnWCRGHA.6084@.TK2MSFTNGP14.phx.gbl...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> --
> HTH. Ryan
>
> "Ian Samuels" <iasamuels@.hotmail.com> wrote in message
> news:eMA%23CvBRGHA.4900@.TK2MSFTNGP09.phx.gbl...
>> Hi,
>> Does anyone have a link for the 'Compare the Editions' Page for SQL 2000?
>> It appears Microsoft are now only showing the 2005 version page.
>> Thanks - Ian.
>|||Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
> Hi Ryan,
> Thanks but I'm after a comparison of the features - I need to compare SQL
> 2000 Standard Edition to Workgroup Edition and there was a page similar to
> the SQL 2005 page
> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)
> that seems to have gone.
All I could find in a similar format is this:
http://www.servepath.com/servers/win_sqlserver.htm
I didn't even realise there was a 2000 Workgroup edition.
Dan|||Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
>> Hi Ryan,
>> Thanks but I'm after a comparison of the features - I need to compare SQL
>> 2000 Standard Edition to Workgroup Edition and there was a page similar
>> to the SQL 2005 page
>> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) th
>> at seems to have gone.
Also found this (forgot all about WebArchive!)
http://web.archive.org/web/20050323020459/http://www.microsoft.com/sql/evaluation/features/choosing.asp
It's slow, but it's the last version of the 2000 comparison page that was
put up in March 2005 :)
Dan|||Ah yeh - great - cheers Dan.
"Daniel Crichton" <msnews@.worldofspack.co.uk> wrote in message
news:uZLPcHERGHA.4900@.TK2MSFTNGP09.phx.gbl...
> Daniel wrote to Ian Samuels on Fri, 10 Mar 2006 12:51:45 -0000:
>> Ian wrote on Fri, 10 Mar 2006 09:38:59 -0000:
>> Hi Ryan,
>> Thanks but I'm after a comparison of the features - I need to compare
>> SQL
>> 2000 Standard Edition to Workgroup Edition and there was a page similar
>> to the SQL 2005 page
>> (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)
>> th
>> at seems to have gone.
> Also found this (forgot all about WebArchive!)
> http://web.archive.org/web/20050323020459/http://www.microsoft.com/sql/evaluation/features/choosing.asp
> It's slow, but it's the last version of the 2000 comparison page that was
> put up in March 2005 :)
> Dan
>
Subscribe to:
Posts (Atom)