hi all,
I'm getting crazy with the above error!
Pls help me!
I'm trying to export data from an Informix
db (IDS7.31) to an Excel file using DTS. This is
because the Informix is working on a server where
also is a MSDE (Sql Server 7.0 sp4) db
I create the DTS and manually it works properly,
but when I use the planning utility to schedule
the process it doesn't work.
As I do not have any SQL Server MSDE 7.0 tool, I'm
using the MMC for SQL Server2000sp2 that is working
on a client station an also on the server (the one with
sql msde 7.0).
Here is the syntax of the error(translated from italian,
sorry for eventual errors!) :

Error string : Microsoft OLE DB Provider for ODBC Drivers
Help File :
ID Context Help : 0
Details error record:
Error : -2147467259 (80004005)
Provider error: 0 (0)
Error String : Microsoft - Driver Manager ODBC : Source
Data Name not found and default driver not specified.
Source Error : Microsoft OLE DB Provider for ODBC Drivers
....

I thought it was because the db was not updated so that
I download all the latest service pack (I forget to tell
that the OS of the server is a NT4 sp6a) for the sql db
and also for the client apps (MMC), but with no result.
I saw other people experiencing problems with the
permission of the starting account of the services
for SQL Server and the Agent so that I previously changed
them with Users with Admin role on the db and on the
server.
Now I thinking that it should be a compability problem
between the client (SQL2000) and the server (SQL 7.0),
but ....
Anyone could give me any suggestion?

Thank you in advance and sorry for my poor english
writing!

RenatoD

Have a read of this article


http://support.microsoft.com/?kbid=269074

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


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

Thank you. I already had a look to this doc. I found the solution,
an alternative one : I tried to launch the dts package from a batch
file and It works also if I schedule with the at. Don't really know why,
owners of the scheduling service and the SQL Server service and
DTS owner are the same...
RenatoD