|
|
Posted by Erland Sommarskog on 10/01/14 11:17
WeLeh (Teguh.AB@gmail.com) writes:
> I am using ODBC (ODBCLink/SE) to connect to HP3000 system;
>
> Retrieving the data into Microsoft Excel goes fine using
> MicrosoftQuery.
> But if I try to use SQLServer2000-DTS on Windows2003 to do the import,
> it always fails and gives the message:
>
> "ODBCLINKSE does not allow multiple thread"
>
> Does anybody knows how to do that?
> I need to synchronize data in HP3000 into my database in SQLServer; and
> I dont see any other ways to do that besides using DTS-scheduled-jobs.
DTS does indeed use multiple threads for running its tasks, so if
ODBCLink/SE is not multithreaded, you have a problem. I don't know DTS
well - rather not at all - but I doubt that there is a way configure DTS
as single-threaded. Even if your package has a single task, DTS keeps the
DLL loaded, and a poorly implemented DLL may not even handle that.
I don't know much about HP3000, but maybe you need to look for a different
solution.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|