[BLACKBOX] AW: [BLACKBOX] AW: [BLACKBOX] reading with SqlODBC3

From: Bernhardt, Gunnar <"Bernhardt,>
Date: Fri, 11 Dec 2009 18:58:42 +0100

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

Hello,

my apologies for changing the language from English to German.

As I already mentioned some changes have been applied to SqlODBC3.odc between BB1.5 and BB1.6rc5. Perhaps the substitution of "LEN(str)" by "SIZE" will solve the problem, I will try this. Interestingly it is possible to apply a rather simple work-around: the file from BB1.5 works fine after recompilation in BB1.6rc5.

Perhaps some introductory words about myself are appropriate: My name is Gunnar Bernhardt (Gunnar being the first name). Aged 32 I work as a "project engineer" for a software company after having studied mechanical engineering. My work consists of taking out software to our customers, doing trainings and customizations in order to make him happy with it. Programming is a hobby for me. The only software I ever wrote for a real "user" is a system for reading measured data in a special file format and applying a non-linear fit to it.

Greetings
gunnar bernhardt


-----Ursprüngliche Nachricht-----
Von: BlackBox [mailto:BLACKBOX{([at]})nowhere.xy
Gesendet: Donnerstag, 10. Dezember 2009 19:27
An: BLACKBOX{([at]})nowhere.xy
Betreff: Re: [BLACKBOX] AW: [BLACKBOX] reading with SqlODBC3

Bernhardt, please use english in this mailing list.

The bug is easy to find in BB1.6 in SqlOdbc3.ReadString:

  WinSql.SQLGetData(t.stmt, SHORT(column + 1), WinSql.SQL_C_WCHAR,
                        SYSTEM.ADR(str), LEN(str), len)

LEN(str) ist the number of Unicode characters (SQL_C_WCHAR), which happens to be half of the buffer size. The BufferLength parameter is defined as a number of bytes.
So either use SQL_C_CHAR, as in BB<
5 or adapt the buffer size. The same may be required in other procedures such as ReadVarString.
In general it may be a good idea to check all occurences of "LEN"
and replace it by "SIZE" where appropriate.

- JT

----
To unsubscribe, send a message with body "SIGNOFF BLACKBOX" to LISTSERV{([at]})nowhere.xy----boundary-LibPST-iamunique-981017442_-_-
Content-type: application/rtf
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="rtf-body.rtf"
e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzc1xmY2hhcnNldDAgQXJpYWw7fQ0Ke1xmMVxmbW9kZXJuIENvdXJpZXIgTmV3O30NCntcZjJc
Zm5pbFxmY2hhcnNldDIgU3ltYm9sO30NCntcZjNcZm1vZGVyblxmY2hhcnNldDAgQ291cmllciBO
ZXc7fX0NCntcY29sb3J0YmxccmVkMFxncmVlbjBcYmx1ZTA7XHJlZDBcZ3JlZW4wXGJsdWUyNTU7
fQ0KXHVjMVxwYXJkXHBsYWluXGRlZnRhYjM2MCBcZjBcZnMyMCBIZWxsbyxccGFyDQpccGFyDQpt
eSBhcG9sb2dpZXMgZm9yIGNoYW5naW5nIHRoZSBsYW5ndWFnZSBmcm9tIEVuZ2xpc2ggdG8gR2Vy
bWFuLlxwYXINClxwYXINCkFzIEkgYWxyZWFkeSBtZW50aW9uZWQgc29tZSBjaGFuZ2VzIGhhdmUg
YmVlbiBhcHBsaWVkIHRvIFNxbE9EQkMzLm9kYyBiZXR3ZWVuIEJCMS41IGFuZCBCQjEuNnJjNS4g
UGVyaGFwcyB0aGUgc3Vic3RpdHV0aW9uIG9mICJMRU4oc3RyKSIgYnkgIlNJWkUiIHdpbGwgc29s
dmUgdGhlIHByb2JsZW0sIEkgd2lsbCB0cnkgdGhpcy4gSW50ZXJlc3RpbmdseSBpdCBpcyBwb3Nz
aWJsZSB0byBhcHBseSBhIHJhdGhlciBzaW1wbGUgd29yay1hcm91bmQ6IHRoZSBmaWxlIGZyb20g
QkIxLjUgd29ya3MgZmluZSBhZnRlciByZWNvbXBpbGF0aW9uIGluIEJCMS42cmM1LlxwYXINClxw
YXINClBlcmhhcHMgc29tZSBpbnRyb2R1Y3Rvcnkgd29yZHMgYWJvdXQgbXlzZWxmIGFyZSBhcHBy
b3ByaWF0ZTogTXkgbmFtZSBpcyBHdW5uYXIgQmVybmhhcmR0IChHdW5uYXIgYmVpbmcgdGhlIGZp
cnN0IG5hbWUpLiBBZ2VkIDMyIEkgd29yayBhcyBhICJwcm9qZWN0IGVuZ2luZWVyIiBmb3IgYSBz
b2Z0d2FyZSBjb21wYW55IGFmdGVyIGhhdmluZyBzdHVkaWVkIG1lY2hhbmljYWwgZW5naW5lZXJp
bmcuIE15IHdvcmsgY29uc2lzdHMgb2YgdGFraW5nIG91dCBzb2Z0d2FyZSB0byBvdXIgY3VzdG9t
ZXJzLCBkb2luZyB0cmFpbmluZ3MgYW5kIGN1c3RvbWl6YXRpb25zIGluIG9yZGVyIHRvIG1ha2Ug
aGltIGhhcHB5IHdpdGggaXQuIFByb2dyYW1taW5nIGlzIGEgaG9iYnkgZm9yIG1lLiBUaGUgb25s
eSBzb2Z0d2FyZSBJIGV2ZXIgd3JvdGUgZm9yIGEgcmVhbCAidXNlciIgaXMgYSBzeXN0ZW0gZm9y
IHJlYWRpbmcgbWVhc3VyZWQgZGF0YSBpbiBhIHNwZWNpYWwgZmlsZSBmb3JtYXQgYW5kIGFwcGx5
aW5nIGEgbm9uLWxpbmVhciBmaXQgdG8gaXQuXHBhcg0KXHBhcg0KR3JlZXRpbmdzXHBhcg0KZ3Vu
bmFyIGJlcm5oYXJkdFxwYXINClxwYXINClxwYXINCi0tLS0tVXJzcHJcJ2ZjbmdsaWNoZSBOYWNo
cmljaHQtLS0tLVxwYXINClZvbjogQmxhY2tCb3ggW21haWx0bzpCTEFDS0JPWEBMSVNUUy5PQkVS
T04uQ0hdIEltIEF1ZnRyYWcgdm9uIEpvc2VmIFRlbXBsXHBhcg0KR2VzZW5kZXQ6IERvbm5lcnN0
YWcsIDEwLiBEZXplbWJlciAyMDA5IDE5OjI3XHBhcg0KQW46IEJMQUNLQk9YQExJU1RTLk9CRVJP
Ti5DSFxwYXINCkJldHJlZmY6IFJlOiBbQkxBQ0tCT1hdIEFXOiBbQkxBQ0tCT1hdIHJlYWRpbmcg
d2l0aCBTcWxPREJDM1xwYXINClxwYXINCkJlcm5oYXJkdCwgcGxlYXNlIHVzZSBlbmdsaXNoIGlu
IHRoaXMgbWFpbGluZyBsaXN0LlxwYXINClxwYXINClRoZSBidWcgaXMgZWFzeSB0byBmaW5kIGlu
IEJCMS42IGluIFNxbE9kYmMzLlJlYWRTdHJpbmc6XHBhcg0KXHBhcg0KICBXaW5TcWwuU1FMR2V0
RGF0YSh0LnN0bXQsIFNIT1JUKGNvbHVtbiArIDEpLCBXaW5TcWwuU1FMX0NfV0NIQVIsXHBhcg0K
ICAgICAgICAgICAgICAgICAgICAgICAgU1lTVEVNLkFEUihzdHIpLCBMRU4oc3RyKSwgbGVuKVxw
YXINClxwYXINCkxFTihzdHIpIGlzdCB0aGUgbnVtYmVyIG9mIFVuaWNvZGUgY2hhcmFjdGVycyAo
U1FMX0NfV0NIQVIpLCB3aGljaCBoYXBwZW5zIHRvIGJlIGhhbGYgb2YgdGhlIGJ1ZmZlciBzaXpl
LiBUaGUgQnVmZmVyTGVuZ3RoIHBhcmFtZXRlciBpcyBkZWZpbmVkIGFzIGEgbnVtYmVyIG9mIGJ5
dGVzLlxwYXINClNvIGVpdGhlciB1c2UgU1FMX0NfQ0hBUiwgYXMgaW4gQkI8PTEuNSBvciBhZGFw
dCB0aGUgYnVmZmVyIHNpemUuIFRoZSBzYW1lIG1heSBiZSByZXF1aXJlZCBpbiBvdGhlciBwcm9j
ZWR1cmVzIHN1Y2ggYXMgUmVhZFZhclN0cmluZy4gXHBhcg0KSW4gZ2VuZXJhbCBpdCBtYXkgYmUg
YSBnb29kIGlkZWEgdG8gY2hlY2sgYWxsIG9jY3VyZW5jZXMgb2YgIkxFTiIgXHBhcg0KYW5kIHJl
cGxhY2UgaXQgYnkgIlNJWkUiIHdoZXJlIGFwcHJvcHJpYXRlLlxwYXINClxwYXINCi0gSlRccGFy
DQpccGFyDQpccGFyDQotLS0tXHBhcg0KVG8gdW5zdWJzY3JpYmUsIHNlbmQgYSBtZXNzYWdlIHdp
dGggYm9keSAiU0lHTk9GRiBCTEFDS0JPWCIgdG8gTElTVFNFUlZATElTVFMuT0JFUk9OLkNIXHBh
cg0KfQ=
----boundary-LibPST-iamunique-981017442_-_---

Received on Fri Dec 11 2009 - 18:58:42 UTC