MDAC reinstall under Win XP Sp2

Hello Guys!
I have a corrupted MDAC Installation on a Windows XP Sp2 Client.
The Application we use responds with the message "provider not found" for a
MS SQL 2000 Connection.
Poorly i cannot just install MDAC again since the setup denies that under
Win XP Sp2.
Is there any way to reinstall MDAC or heal this corrupt part? A reinstall of
the Service Pack did not solve it.
Greetings,
Daniel Guenther
Hi Daniel,
Thanks for your post.
From your descriptions, I understood that you would like to reinstall MDAC
in Windows XP SP2 box. Have I understood you? Correct me if I was wrong.
Based on my scope, the reason why you cannot complete the installation was
that Windows XP Service Pack 2 comes with MDAC 2.81 already so that it is
not necessary for you to install it.
Anyway, if you want to reinstall MDAC manually, you could follow the steps
below (anyway, I will not recommend to do so if there is nothing wrong with
your MDAC)
Navigate to the folder c:\windows\inf. Right-click on MDAC.INF and click
"install."
It will recopy the mdac files and reregister some of the basic registry
entries.
It will ask for the Windows XP CDROM as well as the Windows XP SP2 CDROM.
Some other pointers here:
- When it asks for the Windows XP SP2 CDROM, you will need to point it over
to c:\windows\servicepackfiles\i386.
- When it asks for the Windows XP CD, you will need to have the cd in the
drive and point it over to D:\i386 (assuming D is the cdrom drive.)
- If you do not have the Windows XP CD, you may have an i386 folder on
drive C (if the OEM manufacturer put it there.) In this case point it over
to C:\i386.
If all aboves doesn't resolve your problem, please paste your
c:\WINDOWS\dasetup.log here and I would love to make further research.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hello Michael!
Thanks alot for your quick answer.
Poorly your tip didn't help me much.
I have no idea why, but this setup is not able to copy any single file
during the installation.
I only get the file query dialog again and again.
NTFS Permissions are checked, i am admin and can write/read from
source/destination dir.
The files to copy are definitly in the windows\servicepackfiles\i386
directory.
To be true, I am lost actually... ;)
The logfile btw. does not contain a single entry of my actual try to install
mdac.
So, you have probably another hint for me? ;-)
Greetings,
Daniel Guenther
|||Hi Daniel,
Based on my scope, the file query dialog box comes again and again only
when incorrect file path was specified. Could you confirm you had use the
right ones?
Another workaround is reinstall Windows XP Service Pack 2. It seems you had
tried this, but please try again. Make sure to follow the instuctions in KB
below to reomve first.
How to remove Windows XP Service Pack 2 from your computer
http://support.microsoft.com/kb/875350/EN-US
And here is some KB for further troubleshooting that may help
Component Checker: Diagnose problems and reconfigure MDAC installations
http://support.microsoft.com/kb/307255/EN-US/
How To MDAC Setup Troubleshooting Guide
http://support.microsoft.com/kb/232060/EN-US/
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||I am having a similar problem with MDAC after the installation of XP
SP2. I have run the MS Component Checker tool in its default mode and
it produces an error message stating that you must select a specific
version to check against. However MDAC 2.81 XP SP2 is not listed, only
a the previous Mdac 2.7 XP SP1 and this returns a whole list of
errors. If XP SP2 includes MDAC 2.81 then presumably previous versions
are not required. Is there any way to remove all the old MDAC
components, registry entries etc with a clean install of XP?
Thanks
Dave
v-mingqc@.online.microsoft.com ("Michael Cheng [MSFT]") wrote in message news:<v3oASSkwEHA.3956@.cpmsftngxa10.phx.gbl>...
> Hi Daniel,
> Based on my scope, the file query dialog box comes again and again only
> when incorrect file path was specified. Could you confirm you had use the
> right ones?
> Another workaround is reinstall Windows XP Service Pack 2. It seems you had
> tried this, but please try again. Make sure to follow the instuctions in KB
> below to reomve first.
> How to remove Windows XP Service Pack 2 from your computer
> http://support.microsoft.com/kb/875350/EN-US
> And here is some KB for further troubleshooting that may help
> Component Checker: Diagnose problems and reconfigure MDAC installations
> http://support.microsoft.com/kb/307255/EN-US/
> How To MDAC Setup Troubleshooting Guide
> http://support.microsoft.com/kb/232060/EN-US/
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
|||Hi Daniel,
Have you tried to uninstall XP SP2 and then reinstall it? Does this resolve
your issues? I am just checking on your progress regarding the information
that was sent you! I wonder how the testing is going. If you encounter any
difficulty, please do not hesitate to let me know. Please post here and let
me know the status of your issue. Without your further information, it's
very hard for me to continue with the troubleshooting.
Looking forward to hearing from you soon
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Maybe it's just Vista that has the problem?!?

So I installed a second instance of Report Server since the default instance couldn't find any default directories and I got this error message with started my saga Friday. I actually chose to follow MS's advise and do solution 1). That is when Report Server first lost track of it's directories and caused me to reinstall everything.

Does anyone know what this means?

Server Error in Application "Default Web Site/ReportServer$Two"

---

HTTP Error 500.0 - Internal Server Error

Description: This application is running in an application pool that uses the Integrated .NET mode. This is the preferred mode for running ASP.NET applications on the current and future version of IIS.

In this mode, the application should not specify ASP.NET handler mappings in the <system.web>/<httpHandlers> configuration section. Instead, it should use the <system.webServer>/<handlers> configuration section to configure ASP.NET handler mappings. You have the following options:

1) Migrate the application to work with the Integrated .NET mode (PREFERRED).

You can migrate the application configuration, including the contents of the <httpHandlers> configuration section, by using the following from a command line window (the window must be running as Administrator):

%systemroot%\system32\inetsrv\APPCMD.EXE migrate config "Default Web Site/ReportServer$Two"

After you migrate your application, it will run in both Classic and Integrated .NET modes, as well as on downlevel platforms.

2) Move this application to an application pool using the Classic .NET mode.

You can move the application to an application pool that uses the Classic .NET mode by using the following from a command line window (the window must be running as Administrator):

%systemroot%\system32\inetsrv\APPCMD.EXE set app "Default Web Site/ReportServer$Two" /applicationPool:"Classic .NET AppPool"

Alternatively, you can use any other application pool on your system that is running in the Classic .NET mode. You can also use the IIS Administration tool to move this application to another application pool.

It is preferred that you migrate this application by using option 1 to take advantage of the benefits provided by the Integrated .NET mode.

Error Code: 0x80070032

Notification: BeginRequest

Module: ConfigurationValidationModule

Requested URL: http://jc:80/ReportServer$Two

Physical Path: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\ReportServer

Logon User: Not yet determined

Logon Method: Not yet determined

Handler: AboMapperCustom-43870

Most likely causes: IIS received the request; however, an internal error occurred during the processing of the request. The root cause of this error depends on which module handles the request and what was happening in the worker process when this error occurred. IIS was not able to access the web.config file for the Web site or application. This can occur if the NTFS permissions are set incorrectly. IIS was not able to process configuration for the Web site or application. The authenticated user does not have permission to use this DLL. The request is mapped to a managed handler but the .NET Extensibility Feature is not installed.

What you can try: Ensure that the NTFS permissions for the web.config file are correct and allow access to the Web server's machine account. Check the event logs to see if any additional information was logged. Verify the permissions for the DLL. Install the .NET Extensibility feature if the request is mapped to a managed handler. Create a tracing rule to track failed requests for this HTTP status code. For more information about creating a tracing rule for failed requests, click here.

More Information... This error means that there was a problem while processing the request. The request was received by the Web server, but during processing a fatal error occurred, causing the 500 error.

Microsoft Knowledge Base Articles: 294807

---

Server Version Information: Internet Information Services 7.0.Could be. I heard that SQL has some problems with Vista. Check on the Microsoft site and make sure you have the new update for Vista and VS 2005 SP1. You'll have to download SP1 though. Or maybe check for some SQL updates for Vista.

maximum width

When loading a report that another developer created, I got an error
message saying that the deserialization failed because the width value
needs to be between 0 and 85.3333 in. I was able to get around this by
opening the RDL file in notepad and changing the width values manually.
But my questions is, how was the developer able to set the width >
85.3333 if it was not allowed?Probably, the report was manually edited.
As for the 85.3 in limit - in RS 2000 SP2 it will increase to 160 in.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bucky" <uw_badgers@.mail.com> wrote in message
news:1103826459.105803.261470@.f14g2000cwb.googlegroups.com...
> When loading a report that another developer created, I got an error
> message saying that the deserialization failed because the width value
> needs to be between 0 and 85.3333 in. I was able to get around this by
> opening the RDL file in notepad and changing the width values manually.
>
> But my questions is, how was the developer able to set the width >
> 85.3333 if it was not allowed?
>

maximum number of tables in a query (260) was exceeded

I am getting the following error message from a view I have created. I
would think it was a design issue but it appeared to be working at one time.
When it was reopened I received the following error:
--Could not allocate ancillary table for view or function resolution. The
maximum number of tables in a query (260) was exceeded.
Any ideas on how to correct this? Thanks.
DonHi
If there are 260 tables in the query then you will need to think about the
design. You may have subsequently changed a view to include more tables it
was working previously.
John
<dbj> wrote in message news:uj39oq$UFHA.3188@.TK2MSFTNGP09.phx.gbl...
>I am getting the following error message from a view I have created. I
>would think it was a design issue but it appeared to be working at one
>time. When it was reopened I received the following error:
> --Could not allocate ancillary table for view or function resolution.
> The maximum number of tables in a query (260) was exceeded.
> Any ideas on how to correct this? Thanks.
> Don
>

Maximum # of columns for FullText engine ?

Hi ,

I am trying to run a fulltext query and I get the following error message:

"Too many full-text columns or the full-text query is too complex to be executed"

Does anybody know if there is a limitation in the number of columns? Or what can cause this error?

Here is the sql:

SELECT DISTINCT FT_TBL.CapId, FT_TBL.Title, FT_TBL.PubMedId, FT_TBL.IssueYear, Rank

FROM ClinicalLiteratureTbl AS FT_TBL,

CONTAINSTABLE(ClinicalLiteratureTbl, *, '("body mass index" OR "BMI" OR "Quetelet`s Index" OR "Quetelet Index" OR "Quetelets Index") AND ("myocardial infarction" OR "myocardial infarct" OR "MI" OR "myocardium infarct" OR "myocardium infarction" OR "cardiac infarction" OR "myocardial necrosis" OR "coronary attack" OR "myocardium necrosis" OR "myocardial infarction syndrome" OR "myocardial necrosis syndrome" OR "heart attack" OR "coronary thrombosis" OR "AMI" OR "post-AMI" OR "post AMI" OR "post infarction" OR "post-infarction")') AS KEY_TBL WHERE FT_TBL.ArticleID = KEY_TBL.[KEY] AND FT_TBL.RaterGroupId IN (1,2,3,4) ORDER BY IssueYear DESC

Thanks

gigel,

Fulltext works with 16 columns max on indexes. Because this, your query return error.

|||

Hi,

create a new field, call it keywords, copy all relevant data in this field. Now you have just one field instead of 17.

You might consider also to eliminate the "NoiseWords" in the new Keywords-field. Keep the original data including noise in their current fields.

NoiseWords are kept in a table in your SQL-Server ProgramFiles

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\noiseENG.txt

browse this forum for more about noise

Thomas

Maximum # of columns for FullText engine ?

Hi ,

I am trying to run a fulltext query and I get the following error message:

"Too many full-text columns or the full-text query is too complex to be executed"

Does anybody know if there is a limitation in the number of columns? Or what can cause this error?

Here is the sql:

SELECT DISTINCT FT_TBL.CapId, FT_TBL.Title, FT_TBL.PubMedId, FT_TBL.IssueYear, Rank

FROM ClinicalLiteratureTbl AS FT_TBL,

CONTAINSTABLE(ClinicalLiteratureTbl, *, '("body mass index" OR "BMI" OR "Quetelet`s Index" OR "Quetelet Index" OR "Quetelets Index") AND ("myocardial infarction" OR "myocardial infarct" OR "MI" OR "myocardium infarct" OR "myocardium infarction" OR "cardiac infarction" OR "myocardial necrosis" OR "coronary attack" OR "myocardium necrosis" OR "myocardial infarction syndrome" OR "myocardial necrosis syndrome" OR "heart attack" OR "coronary thrombosis" OR "AMI" OR "post-AMI" OR "post AMI" OR "post infarction" OR "post-infarction")') AS KEY_TBL WHERE FT_TBL.ArticleID = KEY_TBL.[KEY] AND FT_TBL.RaterGroupId IN (1,2,3,4) ORDER BY IssueYear DESC

Thanks

gigel,

Fulltext works with 16 columns max on indexes. Because this, your query return error.

|||

Hi,

create a new field, call it keywords, copy all relevant data in this field. Now you have just one field instead of 17.

You might consider also to eliminate the "NoiseWords" in the new Keywords-field. Keep the original data including noise in their current fields.

NoiseWords are kept in a table in your SQL-Server ProgramFiles

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\noiseENG.txt

browse this forum for more about noise

Thomas

Maximum # of columns for FullText engine ?

Hi ,

I am trying to run a fulltext query and I get the following error message:

"Too many full-text columns or the full-text query is too complex to be executed"

Does anybody know if there is a limitation in the number of columns? Or what can cause this error?

Here is the sql:

SELECT DISTINCT FT_TBL.CapId, FT_TBL.Title, FT_TBL.PubMedId, FT_TBL.IssueYear, Rank

FROM ClinicalLiteratureTbl AS FT_TBL,

CONTAINSTABLE(ClinicalLiteratureTbl, *, '("body mass index" OR "BMI" OR "Quetelet`s Index" OR "Quetelet Index" OR "Quetelets Index") AND ("myocardial infarction" OR "myocardial infarct" OR "MI" OR "myocardium infarct" OR "myocardium infarction" OR "cardiac infarction" OR "myocardial necrosis" OR "coronary attack" OR "myocardium necrosis" OR "myocardial infarction syndrome" OR "myocardial necrosis syndrome" OR "heart attack" OR "coronary thrombosis" OR "AMI" OR "post-AMI" OR "post AMI" OR "post infarction" OR "post-infarction")') AS KEY_TBL WHERE FT_TBL.ArticleID = KEY_TBL.[KEY] AND FT_TBL.RaterGroupId IN (1,2,3,4) ORDER BY IssueYear DESC

Thanks

gigel,

Fulltext works with 16 columns max on indexes. Because this, your query return error.

|||

Hi,

create a new field, call it keywords, copy all relevant data in this field. Now you have just one field instead of 17.

You might consider also to eliminate the "NoiseWords" in the new Keywords-field. Keep the original data including noise in their current fields.

NoiseWords are kept in a table in your SQL-Server ProgramFiles

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\noiseENG.txt

browse this forum for more about noise

Thomas