ODBCLINKSE does not allow multiple threads

[Deskin, Bob]

I know very little about Impromptu but PowerHouse uses the same data access
services. Depending on the version of Impromptu you're using, the data
access services may be attempting to multi-thread. Basically it is trying to
start the transaction before the prepare has completed. We've run into this
in the latest version of PowerHouse during testing. And of course we made
sure that it didn't happen.

I do not know how database dependant this is. Please contact customer
support.

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA 

-----Original Message-----
From: Thomson, Robert G [mailto:robert.g.thomson@boeing.com]
Sent: Monday, April 22, 2002 10:58 AM
To: 'powerh-l@lists.swau.edu'
Subject: ODBCLINKSE does not allow multiple threads


We get this error when using Impromptu against an Image/Sql database. The
entire error message reads:

Query Server Error
Error number -239
DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request with options'.
DMS-E-GENERAL, A general exception has occurred during operation 'start
transaction'.
[ODBCLN32.DLL]ODBCLINKSE does not allow multiple threads.

It's a query against a single dataset. We don't think we're trying to
multi-thread, but maybe Impromptu is doing something we're not aware of.
It's intermittent. We can duplicate it sometimes, but not always. 

If anyone can shed some light on this I'd greatly appreciate it.

Thanks, 

robert.g.thomson@boeing.com




= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.