- Bug in SqlOdbc of BB1.4 and BB1.5Beta

From: [at]} <Rene>
Date: Tue, 26 Apr 2005 23:45:42 +0200

----boundary-LibPST-iamunique-1200824515_-_-
Content-type: text/plain

I'm using WinXP with a MS SqlServer database, which I use in BB through
SqlOdbc.

Whenever a module performs any SQL-action (this includes a
SELECT-Statement via the Sql Browser!) and is unloaded afterwards or the
BB is closed without unloading the module first, I receive the following
ODB Error (a window with ODBC error in the title bar and the below text
+ and OK button pops open):

Invalid Transaction State.

With BB1.3 there is no such error (I just tried it).

I assume that the transaction closing is somehow buggy in the current
versions.

I want to introduce BB to my boss, instead of VB. And I can be sure that
he won't accept an error-message that I can't eliminate. Does anybody
(OMI?) know what to do?

Rene

--- BlackBox
--- send subject HELP or UNSUBSCRIBE to blackbox{([at]})nowhere.xy



----boundary-LibPST-iamunique-1200824515_-_-
Content-type: application/rtf
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="rtf-body.rtf"

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmlsXGZjaGFy
c2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5ldzt9fQ0Ke1xj
b2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1NTt9DQpcdWMxXHBh
cmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIEknbSB1c2luZyBXaW5YUCB3aXRoIGEgTVMgU3Fs
U2VydmVyIGRhdGFiYXNlLCB3aGljaCBJIHVzZSBpbiBCQiB0aHJvdWdoIFxwYXINClNxbE9kYmMu
XHBhcg0KXHBhcg0KV2hlbmV2ZXIgYSBtb2R1bGUgcGVyZm9ybXMgYW55IFNRTC1hY3Rpb24gKHRo
aXMgaW5jbHVkZXMgYSBccGFyDQpTRUxFQ1QtU3RhdGVtZW50IHZpYSB0aGUgU3FsIEJyb3dzZXIh
KSBhbmQgaXMgdW5sb2FkZWQgYWZ0ZXJ3YXJkcyBvciB0aGUgXHBhcg0KQkIgaXMgY2xvc2VkIHdp
dGhvdXQgdW5sb2FkaW5nIHRoZSBtb2R1bGUgZmlyc3QsIEkgcmVjZWl2ZSB0aGUgZm9sbG93aW5n
IFxwYXINCk9EQiBFcnJvciAoYSB3aW5kb3cgd2l0aCBPREJDIGVycm9yIGluIHRoZSB0aXRsZSBi
YXIgYW5kIHRoZSBiZWxvdyB0ZXh0IFxwYXINCisgYW5kIE9LIGJ1dHRvbiBwb3BzIG9wZW4pOlxw
YXINClxwYXINCkludmFsaWQgVHJhbnNhY3Rpb24gU3RhdGUuXHBhcg0KXHBhcg0KV2l0aCBCQjEu
MyB0aGVyZSBpcyBubyBzdWNoIGVycm9yIChJIGp1c3QgdHJpZWQgaXQpLlxwYXINClxwYXINCkkg
YXNzdW1lIHRoYXQgdGhlIHRyYW5zYWN0aW9uIGNsb3NpbmcgaXMgc29tZWhvdyBidWdneSBpbiB0
aGUgY3VycmVudCBccGFyDQp2ZXJzaW9ucy5ccGFyDQpccGFyDQpJIHdhbnQgdG8gaW50cm9kdWNl
IEJCIHRvIG15IGJvc3MsIGluc3RlYWQgb2YgVkIuIEFuZCBJIGNhbiBiZSBzdXJlIHRoYXQgXHBh
cg0KaGUgd29uJ3QgYWNjZXB0IGFuIGVycm9yLW1lc3NhZ2UgdGhhdCBJIGNhbid0IGVsaW1pbmF0
ZS4gRG9lcyBhbnlib2R5IFxwYXINCihPTUk/KSBrbm93IHdoYXQgdG8gZG8/XHBhcg0KXHBhcg0K
UmVuZVxwYXINClxwYXINCi0tLSBCbGFja0JveFxwYXINCi0tLSBzZW5kIHN1YmplY3QgSEVMUCBv
ciBVTlNVQlNDUklCRSB0byBibGFja2JveEBvYmVyb24uY2h9fQAAABoAAAB9AAAA


----boundary-LibPST-iamunique-1200824515_-_---
Received on Tue Apr 26 2005 - 23:45:42 UTC