Hello!
I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
2000 on Windows 2000 server, during the upgrade
I received the following error message " Error running
script:messages.sql(1)".
I found Microsoft article 300676 how to fix this problem.
In this article they provide link to the new setup.ins file
you have to download in order to fix your installation.
Here's the link and it doesn't work:
ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
Does anybody know the correct link? Or where I can download this file from?
Thank you,
LenaArticle says:
To use the fix, use these steps:
1.. Download s80305i.exe
from:ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
The password is: 8.00.305
2.. To install SQL Server 2000 using the new Setup.ins file, copy all of
the files on the SQL Server 2000 CD to a directory on your drive.
3.. Replace the existing Setup.ins in the \x86\Setup\ folder with the
Setup.ins file that you downloaded in the fix.
4.. Rerun the SQL Server 2000 setup.
It is working fine. I just cheked this out. If you will not able to download
it let me know your EMail I'll send it to you.
Regards
---
All information provided above AS IS.
"Lena" <lenaglozman@.yahoo.com> wrote in message
news:fc1e8071.0310310848.12b948d5@.posting.google.com...
> Hello!
> I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
> 2000 on Windows 2000 server, during the upgrade
> I received the following error message " Error running
> script:messages.sql(1)".
> I found Microsoft article 300676 how to fix this problem.
> In this article they provide link to the new setup.ins file
> you have to download in order to fix your installation.
> Here's the link and it doesn't work:
> ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
> Does anybody know the correct link? Or where I can download this file
from?
> Thank you,
> Lena|||I could download the file from
ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/s80
305i.exe and then ran winzip to extract the setup.ins
file, the password to unzip this file is 8.00.305.
Let me know if you still having problem downloading this
file, i can email the setup.ins file to you.
>--Original Message--
>Hello!
>I'm trying to upgrade SQL Srerver 7.0 SP4 to SQL Server
>2000 on Windows 2000 server, during the upgrade
> I received the following error message " Error running
>script:messages.sql(1)".
>I found Microsoft article 300676 how to fix this problem.
>In this article they provide link to the new setup.ins
file
>you have to download in order to fix your installation.
>Here's the link and it doesn't work:
>ftp://ftp.microsoft.com/bussys/sql/transfer/sql80/setup/
>Does anybody know the correct link? Or where I can
download this file from?
>Thank you,
>Lena
>.
>
Showing posts with label sp4. Show all posts
Showing posts with label sp4. Show all posts
Tuesday, March 27, 2012
Wednesday, March 7, 2012
Error connecting to Oracle via linked server after SP2 installatio
We have a test SQL Server box configured with the following:
Windows 2000, SP4
SQL Server: 8.00.944
Oracle Client Tools: 9.2.0.1
Microsoft ODBC for Oracle: 2.573.9030.00
We built a linked server to a 3rd party Oracle application. We used the
standard "Microsoft OLE DB Provider for Oracle" drvier from the drop down
list. We created views using this linked server and they worked fine.
However, after installing SP2 of Reporting Services, we now receive the
following error when we attempt to use the views:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned
error message: Oracle client and networking components not found. These
components are supplied by Oracle Corporation and are part of the Oracle
Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.]
We use a free SQL Tool called "Toad" to access the Oracle environment. This
tool uses the same Oracle Client Tools referred to in the error message.
This tool continues to function normally.
We really want to take advantage of some of the new features in SP2, but we
can't deploy this on our production SQL Reporting box until we get this issue
resolved. Any help in this matter would be greatly appreciated. Thanks!
--
Grande ApplicationsHello,
Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
are not supported with any Oracle versions later than 8i. For more
information, click the following article number to view the article in the
Microsoft Knowledge Base:
244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
Therefore, the cause of the issue is not related to the reporting service.
If you want to use Oracle version 9i, you can use the following settings in
step 3 of this procedure in the article 280106:
280106 How to set up and troubleshoot a linked server to Oracle in SQL
Server
http://support.microsoft.com/?id=280106
However, this configuration is not supported and is discouraged.
Oracle Client Microsoft Windows 2000
9.x
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
You can refer to the article 280106 to set up and troubleshoot a linked
server. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Sophie,
Thanks much for your response. We were able to resolve the problem by
restarting the SQL server (SQL Server service); however, we have discovered
from others that this resolution has been known to provide only a temporary
fix.
Do you know where I can find a list of all of the files (and file versions)
installed and updated by Reporting Services SP 2? This would be very helpful
to us.
Thank you.
Grande Applications
Thank you
"Sophie Guo [MSFT]" wrote:
> Hello,
> Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
> are not supported with any Oracle versions later than 8i. For more
> information, click the following article number to view the article in the
> Microsoft Knowledge Base:
> 244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
> Therefore, the cause of the issue is not related to the reporting service.
> If you want to use Oracle version 9i, you can use the following settings in
> step 3 of this procedure in the article 280106:
> 280106 How to set up and troubleshoot a linked server to Oracle in SQL
> Server
> http://support.microsoft.com/?id=280106
> However, this configuration is not supported and is discouraged.
> Oracle Client Microsoft Windows 2000
> 9.x
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
> "OracleXaLib"="oraclient9.dll"
> "OracleSqlLib"="orasql9.dll"
> "OracleOciLib"="oci.dll"
>
> You can refer to the article 280106 to set up and troubleshoot a linked
> server. I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
Windows 2000, SP4
SQL Server: 8.00.944
Oracle Client Tools: 9.2.0.1
Microsoft ODBC for Oracle: 2.573.9030.00
We built a linked server to a 3rd party Oracle application. We used the
standard "Microsoft OLE DB Provider for Oracle" drvier from the drop down
list. We created views using this linked server and they worked fine.
However, after installing SP2 of Reporting Services, we now receive the
following error when we attempt to use the views:
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned
error message: Oracle client and networking components not found. These
components are supplied by Oracle Corporation and are part of the Oracle
Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.]
We use a free SQL Tool called "Toad" to access the Oracle environment. This
tool uses the same Oracle Client Tools referred to in the error message.
This tool continues to function normally.
We really want to take advantage of some of the new features in SP2, but we
can't deploy this on our production SQL Reporting box until we get this issue
resolved. Any help in this matter would be greatly appreciated. Thanks!
--
Grande ApplicationsHello,
Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
are not supported with any Oracle versions later than 8i. For more
information, click the following article number to view the article in the
Microsoft Knowledge Base:
244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
Therefore, the cause of the issue is not related to the reporting service.
If you want to use Oracle version 9i, you can use the following settings in
step 3 of this procedure in the article 280106:
280106 How to set up and troubleshoot a linked server to Oracle in SQL
Server
http://support.microsoft.com/?id=280106
However, this configuration is not supported and is discouraged.
Oracle Client Microsoft Windows 2000
9.x
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
"OracleXaLib"="oraclient9.dll"
"OracleSqlLib"="orasql9.dll"
"OracleOciLib"="oci.dll"
You can refer to the article 280106 to set up and troubleshoot a linked
server. I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Sophie,
Thanks much for your response. We were able to resolve the problem by
restarting the SQL server (SQL Server service); however, we have discovered
from others that this resolution has been known to provide only a temporary
fix.
Do you know where I can find a list of all of the files (and file versions)
installed and updated by Reporting Services SP 2? This would be very helpful
to us.
Thank you.
Grande Applications
Thank you
"Sophie Guo [MSFT]" wrote:
> Hello,
> Microsoft OLE DB Provider for Oracle and Microsoft ODBC Driver for Oracle
> are not supported with any Oracle versions later than 8i. For more
> information, click the following article number to view the article in the
> Microsoft Knowledge Base:
> 244661 Limitations of Microsoft Oracle ODBC Driver and OLE DB Provider
> http://support.microsoft.com/default.aspx?scid=KB;EN-US;244661
> Therefore, the cause of the issue is not related to the reporting service.
> If you want to use Oracle version 9i, you can use the following settings in
> step 3 of this procedure in the article 280106:
> 280106 How to set up and troubleshoot a linked server to Oracle in SQL
> Server
> http://support.microsoft.com/?id=280106
> However, this configuration is not supported and is discouraged.
> Oracle Client Microsoft Windows 2000
> 9.x
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI]
> "OracleXaLib"="oraclient9.dll"
> "OracleSqlLib"="orasql9.dll"
> "OracleOciLib"="oci.dll"
>
> You can refer to the article 280106 to set up and troubleshoot a linked
> server. I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
Wednesday, February 15, 2012
error accessing the reports manager in browser
Hi,
I installed the Reporting Services on Win2000 server (SP4). when I try to
access the reports manager through browser I am getting following error.
The XML file
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
be loaded. Attempted to access an unloaded AppDomain.
Thanks,
Nemani.I installed latest visual studio.net 2003
"Nemani" <mnemani@.che.state.nm.us> wrote in message
news:eOHZoeuWEHA.1164@.tk2msftngp13.phx.gbl...
> Hi,
> I installed the Reporting Services on Win2000 server (SP4). when I try to
> access the reports manager through browser I am getting following error.
> The XML file
> c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
> be loaded. Attempted to access an unloaded AppDomain.
> Thanks,
> Nemani.
>
I installed the Reporting Services on Win2000 server (SP4). when I try to
access the reports manager through browser I am getting following error.
The XML file
c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
be loaded. Attempted to access an unloaded AppDomain.
Thanks,
Nemani.I installed latest visual studio.net 2003
"Nemani" <mnemani@.che.state.nm.us> wrote in message
news:eOHZoeuWEHA.1164@.tk2msftngp13.phx.gbl...
> Hi,
> I installed the Reporting Services on Win2000 server (SP4). when I try to
> access the reports manager through browser I am getting following error.
> The XML file
> c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config could not
> be loaded. Attempted to access an unloaded AppDomain.
> Thanks,
> Nemani.
>
Subscribe to:
Posts (Atom)