Migrate Higher version of MDAC

Hi Friends,

I have a system with windows 2000 advanced server SP4 OS. In that system, How can i upgrade MDAC version from 2.5 to 2.8 sp2.

This is use of,

I am going to install sql server 2005 express edition advanced services SP2.

Please help me, how can i upgrade higher version of MDAC?

Thanks in Advance

Rameshkumar Thirumalaisamy

You just download the version you want from the Microsoft Download Center and install it. I believe that MDAC 2.8 is currently at SP1, not SP2 as you've indicated. You can find MDAC 2.8 SP1 here.

Mike

|||

Actually, if you install the SQL Server 2005 on the machine you can connect using the SNAC provider instead of using the MDAC stack. Although you should be up-to-date in the case another application needs parts of the MDAC stack.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

When installing SQL Server 2005 (any edition) on Windows 2000 there actually is a minimum version of MDAC that is required, although I can't recall what version is required, but 2.8 SP1 will certainly qualify since it's the newest. I don't know why this requirement exists only on Windows 2000.

Mike

Migrate Higher version of MDAC

Hi Friends,

I have a system with windows 2000 advanced server SP4 OS. In that system, How can i upgrade MDAC version from 2.5 to 2.8 sp2.

This is use of,

I am going to install sql server 2005 express edition advanced services SP2.

Please help me, how can i upgrade higher version of MDAC?

Thanks in Advance

Rameshkumar Thirumalaisamy

You just download the version you want from the Microsoft Download Center and install it. I believe that MDAC 2.8 is currently at SP1, not SP2 as you've indicated. You can find MDAC 2.8 SP1 here.

Mike

|||

Actually, if you install the SQL Server 2005 on the machine you can connect using the SNAC provider instead of using the MDAC stack. Although you should be up-to-date in the case another application needs parts of the MDAC stack.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

When installing SQL Server 2005 (any edition) on Windows 2000 there actually is a minimum version of MDAC that is required, although I can't recall what version is required, but 2.8 SP1 will certainly qualify since it's the newest. I don't know why this requirement exists only on Windows 2000.

Mike

Migrate from Access to SQL 2005

Dear friends,

I'm trying to migrate my database in MS Access to SQL 2005. With the tables I dont have any problem using the Microsft tool for that. But I dont know how can I migrate StoredProdures/Views created in Access...

I have about 300 SP and views in database access.

thanks

Someone help me?|||stored procedure in sql server is completely different from access. you may have to recode your sp's

migrate database maintenance plan

Hi Friends!
Anyone know how can i migrate a lot of Database maintenance plans from one
SQL Server to another? All servers are 7.0 + SP4
Thanks all!!!Check the following articles:
Migrating a Maintenance Plan from One SQL Server to Another
http://www.databasejournal.com/features/mssql/article.php/3066351
Scripting Database Maintenance Plans
http://www.dbazine.com/sql/sql-articles/cook10
-Sue
On Tue, 24 May 2005 13:53:03 -0700, "Tinchos"
<Tinchos@.discussions.microsoft.com> wrote:
>Hi Friends!
>Anyone know how can i migrate a lot of Database maintenance plans from one
>SQL Server to another? All servers are 7.0 + SP4
>Thanks all!!!
>