Question: ODBC Connection Error .. multiple thread (urgent, pls)

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.

Pls help..

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/techinf...2000/books.asp

You could try setting each step in your package to execute on the main
package thread - you can use Disconnected Edit to set the
ExecuteInMainThread property, or see the code snippet here:

http://www.sqldts.com/default.aspx?208

But as Erland says, it's not at all certain that this will help to
solve your problem.

Simon