Hello
We just upgraded from win2k to win2003 on our sql server 2000 and we can't see the other drivers like excel,access conncetions in DTS packages is there a way we can load them how do they come they used to come default in win 2k
all the packages which have connections to excel and access failed

Thanks,

Those drivers should come with MDAC. Can you see the drivers if you look at
creating a DSN?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"sch" <anonymous (AT) discussions (DOT) microsoft.com> wrote

a way we can load them how do they come they used to come default in win 2k
..

I can see the drivers when creating DSN but the my DTS can't see those.

----- Allan Mitchell wrote: ----

Those drivers should come with MDAC. Can you see the drivers if you look a
creating a DSN

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP
www.SQLDTS.com - The site for all your DTS needs
I support PASS - the definitive, global communit
for SQL Server professionals - http://www.sqlpass.or


"sch" <anonymous (AT) discussions (DOT) microsoft.com> wrote in messag
news:55046CB7-B90E-4918-BF86-4245EDA0B11D (AT) microsoft (DOT) com..
a way we can load them how do they come they used to come default in win 2

I can look at the drivers but my dts doesn't see them..

OK.

Can you try reregistering the DTS dlls as detailed here.

Redistributing DTS with your program
(http://www.sqldts.com/Default.aspx?225)

If that does not work and you are on the latest SP dor SQL Server then can
you try redoing MDAC?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"sch" <anonymous (AT) discussions (DOT) microsoft.com> wrote