- Bug in SqlOdbc (BB 1.5Beta and BB 1.4)

From: [at]} <rene.krywult{>
Date: Tue, 26 Apr 2005 15:56:01 +0200

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

I use:
WinXP
Microsoft SQL Server
BB1.5Beta

I open the SQL Browser, enter my odbc-Source, SqlOdbc as
Driver, and "select * from tblDepartments" (without quotes,
of course, the tblDepartments is an existing table in my
odbc-source) as statement. Then I press execute, and as
expected I receive my result.

Then I close the BB, and receive an error window:
Title: ODBC Error
Text: [Microsoft][ODBC SQL Server Driver]Invalid
transaction state

I can press "OK", and that's it.

BB 1.4 shows the same behavior.

BB1.3 works OK: It simply exits without any ODBC Error.

The same error message appears with BB1.4 and BB1.5Beta
(but not with BB1.3), whenever I unload a module that
accesses the Database.

It seems that there's a bug in the SqlOdbc-Driver. As I am
not versed in the SqlDriver, I cannot really fix the bug,
though I believe that it has to do with the release of a
transaction.

If I had the BB1.3 module for SqlOdbc, I could chekc the
difference, but without, I just need help.

Since I'm introducing BB for the very first time for the
Bank Austria, and since my tool will be used be the middle
management, I want to make an impression. Error messages
can ruin this impression.

Can anybody (OMI?) help?

Rene

























































































































































































------------------- Werbung -----------------------
>> JETZT: AT-Domains Erst-Registrierung kostenlos!
und NUR EUR 16,00/Jahr * http://www.emerion.com


---------------------------------------------------------
*** sent through http://www.everymail.net FREE e-mail
             

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



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

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmlsXGZjaGFy
c2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5ldzt9fQ0Ke1xj
b2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1NTt9DQpcdWMxXHBh
cmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIEkgdXNlOiBccGFyDQpXaW5YUFxwYXINCk1pY3Jv
c29mdCBTUUwgU2VydmVyXHBhcg0KQkIxLjVCZXRhXHBhcg0KXHBhcg0KSSBvcGVuIHRoZSBTUUwg
QnJvd3NlciwgZW50ZXIgbXkgb2RiYy1Tb3VyY2UsIFNxbE9kYmMgYXMgXHBhcg0KRHJpdmVyLCBh
bmQgInNlbGVjdCAqIGZyb20gdGJsRGVwYXJ0bWVudHMiICh3aXRob3V0IHF1b3RlcywgXHBhcg0K
b2YgY291cnNlLCB0aGUgdGJsRGVwYXJ0bWVudHMgaXMgYW4gZXhpc3RpbmcgdGFibGUgaW4gbXkg
XHBhcg0Kb2RiYy1zb3VyY2UpIGFzIHN0YXRlbWVudC4gVGhlbiBJIHByZXNzIGV4ZWN1dGUsIGFu
ZCBhcyBccGFyDQpleHBlY3RlZCBJIHJlY2VpdmUgbXkgcmVzdWx0LlxwYXINClxwYXINClRoZW4g
SSBjbG9zZSB0aGUgQkIsIGFuZCByZWNlaXZlIGFuIGVycm9yIHdpbmRvdzpccGFyDQpUaXRsZTog
T0RCQyBFcnJvclxwYXINClRleHQ6IFtNaWNyb3NvZnRdW09EQkMgU1FMIFNlcnZlciBEcml2ZXJd
SW52YWxpZCBccGFyDQp0cmFuc2FjdGlvbiBzdGF0ZVxwYXINClxwYXINCkkgY2FuIHByZXNzICJP
SyIsIGFuZCB0aGF0J3MgaXQuXHBhcg0KXHBhcg0KQkIgMS40IHNob3dzIHRoZSBzYW1lIGJlaGF2
aW9yLlxwYXINClxwYXINCkJCMS4zIHdvcmtzIE9LOiBJdCBzaW1wbHkgZXhpdHMgd2l0aG91dCBh
bnkgT0RCQyBFcnJvci5ccGFyDQpccGFyDQpUaGUgc2FtZSBlcnJvciBtZXNzYWdlIGFwcGVhcnMg
d2l0aCBCQjEuNCBhbmQgQkIxLjVCZXRhIFxwYXINCihidXQgbm90IHdpdGggQkIxLjMpLCB3aGVu
ZXZlciBJIHVubG9hZCBhIG1vZHVsZSB0aGF0IFxwYXINCmFjY2Vzc2VzIHRoZSBEYXRhYmFzZS5c
cGFyDQpccGFyDQpJdCBzZWVtcyB0aGF0IHRoZXJlJ3MgYSBidWcgaW4gdGhlIFNxbE9kYmMtRHJp
dmVyLiBBcyBJIGFtIFxwYXINCm5vdCB2ZXJzZWQgaW4gdGhlIFNxbERyaXZlciwgSSBjYW5ub3Qg
cmVhbGx5IGZpeCB0aGUgYnVnLCBccGFyDQp0aG91Z2ggSSBiZWxpZXZlIHRoYXQgaXQgaGFzIHRv
IGRvIHdpdGggdGhlIHJlbGVhc2Ugb2YgYSBccGFyDQp0cmFuc2FjdGlvbi5ccGFyDQpccGFyDQpJ
ZiBJIGhhZCB0aGUgQkIxLjMgbW9kdWxlIGZvciBTcWxPZGJjLCBJIGNvdWxkIGNoZWtjIHRoZSBc
cGFyDQpkaWZmZXJlbmNlLCBidXQgd2l0aG91dCwgSSBqdXN0IG5lZWQgaGVscC5ccGFyDQpccGFy
DQpTaW5jZSBJJ20gaW50cm9kdWNpbmcgQkIgZm9yIHRoZSB2ZXJ5IGZpcnN0IHRpbWUgZm9yIHRo
ZSBccGFyDQpCYW5rIEF1c3RyaWEsIGFuZCBzaW5jZSBteSB0b29sIHdpbGwgYmUgdXNlZCBiZSB0
aGUgbWlkZGxlIFxwYXINCm1hbmFnZW1lbnQsIEkgd2FudCB0byBtYWtlIGFuIGltcHJlc3Npb24u
IEVycm9yIG1lc3NhZ2VzIFxwYXINCmNhbiBydWluIHRoaXMgaW1wcmVzc2lvbi4gXHBhcg0KXHBh
cg0KQ2FuIGFueWJvZHkgKE9NST8pIGhlbHA/XHBhcg0KXHBhcg0KUmVuZVxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxw
YXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXINClxwYXIN
ClxwYXINClxwYXINClxwYXINCi0tLS0tLS0tLS0tLS0tLS0tLS0gV2VyYnVuZyAtLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLVxwYXINCj4+ICBKRVRaVDogQVQtRG9tYWlucyBFcnN0LVJlZ2lzdHJpZXJ1
bmcga29zdGVubG9zIVxwYXINCnVuZCBOVVIgRVVSIDE2LDAwL0phaHIgICogICBodHRwOi8vd3d3
LmVtZXJpb24uY29tXHBhcg0KXHBhcg0KXHBhcg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tXHBhcg0KKioqIHNlbnQgdGhyb3VnaCBodHRw
Oi8vd3d3LmV2ZXJ5bWFpbC5uZXQgICAgIEZSRUUgZS1tYWlsIFxwYXINCiAgICAgICAgICAgICBc
cGFyDQpccGFyDQotLS0gQmxhY2tCb3hccGFyDQotLS0gc2VuZCBzdWJqZWN0IEhFTFAgb3IgVU5T
VUJTQ1JJQkUgdG8gYmxhY2tib3hAb2Jlcm9uLmNofX0AIHNpbXBseSBleA=


----boundary-LibPST-iamunique-2103210887_-_---
Received on Tue Apr 26 2005 - 15:56:01 UTC

This archive was generated by hypermail 2.3.0 : Thu Sep 26 2013 - 06:28:16 UTC