My Development machine is Win XP Pro.
I have MDAC 2.7, Visual Studio 6.0 SP3 Installed.
I am running into some issues where a vb program i wrote runs perfectly fine (Using ADO) when connecting to sql server but only runs fine on half of the windows 2000 machines i tested on.
Anyone have any suggestions? even stranger is that the versions of the odbc driver on the 2000 box are newer than the versions on my xp box with MDAC 2.7 SP1 installed.
All machines have DSN's set up exactly the same. I even tested with a DSN'less connection just to be sure (same result).Refer to event viewer logs for any kind of information in this regard.
Showing posts with label win. Show all posts
Showing posts with label win. Show all posts
Friday, March 30, 2012
MDAC Upgrade
Please advice.
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
--
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> >--Original Message--
> >SQL Server 2000 Service Pack 3a comes with MDAC 2.7
> Service Pack 1a, so the
> >best way is to install the SQL Server Service Pack.
> >
> >--
> >Jacco Schalkwijk
> >SQL Server MVP
> >
> >
> >"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> >> Please advice.
> >>
> >> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
> MDAC
> >> 2.6 SP1.
> >> I would like to upgrade this to MDAC 2.7. Can I simply
> >> run the MDAC 2.7 update or what is the Microsoft way to
> >> do this.
> >>
> >> Help Appreciated.
> >
> >
> >.
> >
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
--
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
>> Please advice.
>> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
MDAC
>> 2.6 SP1.
>> I would like to upgrade this to MDAC 2.7. Can I simply
>> run the MDAC 2.7 update or what is the Microsoft way to
>> do this.
>> Help Appreciated.
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> >--Original Message--
> >SQL Server 2000 Service Pack 3a comes with MDAC 2.7
> Service Pack 1a, so the
> >best way is to install the SQL Server Service Pack.
> >
> >--
> >Jacco Schalkwijk
> >SQL Server MVP
> >
> >
> >"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> >> Please advice.
> >>
> >> I have a WIN 2K SP3 ADV Server that runs SQL 2K with
> MDAC
> >> 2.6 SP1.
> >> I would like to upgrade this to MDAC 2.7. Can I simply
> >> run the MDAC 2.7 update or what is the Microsoft way to
> >> do this.
> >>
> >> Help Appreciated.
> >
> >
> >.
> >
MDAC Upgrade
Please advice.
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> Service Pack 1a, so the
> message
> MDAC
I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
2.6 SP1.
I would like to upgrade this to MDAC 2.7. Can I simply
run the MDAC 2.7 update or what is the Microsoft way to
do this.
Help Appreciated.SQL Server 2000 Service Pack 3a comes with MDAC 2.7 Service Pack 1a, so the
best way is to install the SQL Server Service Pack.
Jacco Schalkwijk
SQL Server MVP
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
> Please advice.
> I have a WIN 2K SP3 ADV Server that runs SQL 2K with MDAC
> 2.6 SP1.
> I would like to upgrade this to MDAC 2.7. Can I simply
> run the MDAC 2.7 update or what is the Microsoft way to
> do this.
> Help Appreciated.|||MDAC 2.8 is also availabe for download from MS site.
Regards
Chip
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Thanks for your reply.
My configuration is WIN 2k SP3 plus SQL 2K Client tools
with MDAC 2.6 SP1. What is the best course of action to
upgrade to MDAC 2.7
Help Appreciated.
>--Original Message--
>SQL Server 2000 Service Pack 3a comes with MDAC 2.7
Service Pack 1a, so the
>best way is to install the SQL Server Service Pack.
>--
>Jacco Schalkwijk
>SQL Server MVP
>
>"Olutimi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:e9c601c3f096$369ceb40$a501280a@.phx.gbl...
MDAC
>
>.
>|||Olutimi,
We run Win 2K SP4 and SQL2000 SP2 +. Remember to make sure that the server
MDAC is at least the same level as the client or higher. MDAC can introduce
changes that cause things like DTS, run from the client, to fail.
We upgraded the server to MDAC 2.7SP1A and then the clients. A simple
download and then run the DASETUP.
HTH
Chris Wood
Alberta Department of Energy
CANADA
"Olutimi" <anonymous@.discussions.microsoft.com> wrote in message
news:e17301c3f0b9$9ec87860$a301280a@.phx.gbl...
> Thanks for your reply.
> My configuration is WIN 2k SP3 plus SQL 2K Client tools
> with MDAC 2.6 SP1. What is the best course of action to
> upgrade to MDAC 2.7
> Help Appreciated.
>
> Service Pack 1a, so the
> message
> MDAC
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!
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!
Wednesday, March 28, 2012
MDAC Component Checker
I am on a win 2003 server and have run the component
checker and found 2 errors. The files obdcbcp.dll and
sqlsrv32.dll have mismatch errors. There errors say
expecting version 2000.85.1022.0; but the problem is that
I have 2000.85.1025.0
How can I fix this?
Thanks in advance,
Stewart
It sounds like you have installed MS04-003 to thsi system. The sqlsrv32.dll
and odbcbcp.dll from that patch are version 2000.85.1025.0.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Stewart,
I have exactly same problem, what did you do to fix it?
Thanks
Regards
Kasba
checker and found 2 errors. The files obdcbcp.dll and
sqlsrv32.dll have mismatch errors. There errors say
expecting version 2000.85.1022.0; but the problem is that
I have 2000.85.1025.0
How can I fix this?
Thanks in advance,
Stewart
It sounds like you have installed MS04-003 to thsi system. The sqlsrv32.dll
and odbcbcp.dll from that patch are version 2000.85.1025.0.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Stewart,
I have exactly same problem, what did you do to fix it?
Thanks
Regards
Kasba
MDAC Component Checker
I am on a win 2003 server and have run the component
checker and found 2 errors. The files obdcbcp.dll and
sqlsrv32.dll have mismatch errors. There errors say
expecting version 2000.85.1022.0; but the problem is that
I have 2000.85.1025.0
How can I fix this?
Thanks in advance,
StewartIt sounds like you have installed MS04-003 to thsi system. The sqlsrv32.dll
and odbcbcp.dll from that patch are version 2000.85.1025.0.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Stewart,
I have exactly same problem, what did you do to fix it?
Thanks
Regards
Kasba
vkasba
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message744871.html
checker and found 2 errors. The files obdcbcp.dll and
sqlsrv32.dll have mismatch errors. There errors say
expecting version 2000.85.1022.0; but the problem is that
I have 2000.85.1025.0
How can I fix this?
Thanks in advance,
StewartIt sounds like you have installed MS04-003 to thsi system. The sqlsrv32.dll
and odbcbcp.dll from that patch are version 2000.85.1025.0.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Stewart,
I have exactly same problem, what did you do to fix it?
Thanks
Regards
Kasba
vkasba
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message744871.html
Monday, March 26, 2012
mdac 2.6 sp2
Does anyone know any bugs on mdac 2.6 sp2 running on win xp or win98 or win 2000?Do you have to run this version on all 3 operating systems ?
Friday, March 9, 2012
Maximum Memory Configurations
What is the maximum amount of memory SQL2K can address per instance using the following configuratio
WIN 2003 32 bit Enterprise Edition OS with 32 GB RA
SQL2K SP3 32 bit Enterprise Edition w/ hot fixe
AWE Enable
/PAE switch in boot.in
Lock pages in memory enabled for MSSQL Service Account
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Server but has no mention of max memory allowed.It is my understanding that each instance will be able to use all of its =addressable RAM. In your scenario you could configure three instances =to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =would allow 4GB of free memory for the OS to work with. Of course you =could install more instances, but you would want to limit the amount of =RAM each uses so that you do not run into problems by trying to allocate =more memory than you have in the server.
-- Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =using the following configuration
> > WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
> > The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =Advanced Server but has no mention of max memory allowed.
WIN 2003 32 bit Enterprise Edition OS with 32 GB RA
SQL2K SP3 32 bit Enterprise Edition w/ hot fixe
AWE Enable
/PAE switch in boot.in
Lock pages in memory enabled for MSSQL Service Account
The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K Advanced Server but has no mention of max memory allowed.It is my understanding that each instance will be able to use all of its =addressable RAM. In your scenario you could configure three instances =to use 8GB of RAM and you could have a fourth using 4GB of RAM. That =would allow 4GB of free memory for the OS to work with. Of course you =could install more instances, but you would want to limit the amount of =RAM each uses so that you do not run into problems by trying to allocate =more memory than you have in the server.
-- Keith
"Douglas Luke" <anonymous@.discussions.microsoft.com> wrote in message =news:D6F9605B-497D-49C6-9BED-FF0B19B83BC9@.microsoft.com...
> What is the maximum amount of memory SQL2K can address per instance =using the following configuration
> > WIN 2003 32 bit Enterprise Edition OS with 32 GB RAM
> SQL2K SP3 32 bit Enterprise Edition w/ hot fixes
> AWE Enabled
> /PAE switch in boot.ini
> Lock pages in memory enabled for MSSQL Service Account.
> > The BOL says SQL2K 32 bit can address up to 8 GB of RAM on Win2K =Advanced Server but has no mention of max memory allowed.
Wednesday, March 7, 2012
Maximize Sql Server 2005 Memory.
Hi ,
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
Travis Tan
If this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
Travis Tan
If this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
Maximize Sql Server 2005 Memory.
Hi ,
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
Travis TanIf this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
Travis TanIf this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
Saturday, February 25, 2012
Maximize Sql Server 2005 Memory.
Hi ,
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
Travis TanIf this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
Travis TanIf this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
Maximize Sql Server 2005 Memory.
Hi ,
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
--
Travis TanIf this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
--
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
I just installed my new server with spec show below ,
1. Win 2003 R2 32 bit
2. Sql Server 2005 32 bit
3. 4 Processor 2800 Mhz
4. 8 GB of RAM.
As I know , enable an AWE will maximize the memory usage of the Sql
Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
My intention is simple , is to make sure Sql Server 2005 fully untilize
the memory since this server only have one instance and with no other's
application sharing with it.
Please advise how is the proper configuration. Many thanks.
--
Travis TanIf this is a brand new server you might have been better off going with the
x64bit versions of the OS and SQL Server (assuming the hardware is x64 bit
capable) so AWE would have been unnecessary. But in this case you do need to
turn on AWE and PAE (PAE may be turned on by the OS automatically) for the
OS in order to get the most out of this. Then set the MAX Memory of SQL
Server to no more than 7GB to allow the OS to have enough memory to operate
properly.
--
Andrew J. Kelly SQL MVP
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:EFA5E09C-B8C5-4B9F-B665-B71509CB41C5@.microsoft.com...
> Hi ,
> I just installed my new server with spec show below ,
> 1. Win 2003 R2 32 bit
> 2. Sql Server 2005 32 bit
> 3. 4 Processor 2800 Mhz
> 4. 8 GB of RAM.
> As I know , enable an AWE will maximize the memory usage of the Sql
> Server. Is it true ? Before this , I need to set the "Lock Page Memory" ?
> My intention is simple , is to make sure Sql Server 2005 fully untilize
> the memory since this server only have one instance and with no other's
> application sharing with it.
> Please advise how is the proper configuration. Many thanks.
> --
> Travis Tan
Subscribe to:
Posts (Atom)