Bill Lam said:
>> So I'd be a very happy camper if anyone could answer the following:
>>
>> 1- Does ddins work? (and 1.1- why does it overtake varchars so max size?)
>>
>> 2- Has anyone been using it, with MySQL or any other database?
>>
>> 3- Does anyone ever bulkinserts into MySQL or anywhere else (and if so, how?)
>
>1. it works for me
>1.1 I'm lazy.
>2. it tested ok with ms-access, ms sqlsvr, firebird
>3. I don't know, you better ask in their forum (but it seems you have
> already done that).
> I suggest you first verify ddins working properly ms-access or ms sqlsvr.
>If that doesn't work, try again with J602 and use the original odbc package.
Bill, thanks for the quick answer... I did follow your suggestion, and
tried <ddins>
on a stock, original, fresh install of J6.02.
Turns out <ddins> just doesn't work on a 64bit system: it uses a little
verb, <iad> from packages/odbc/odbc.ijs, (same module as ins) which returns the
address of the first [byte of] data in a variable.
Now, this verb obviously still assumes 32-bit adresses and integers, so it does
not work in j64: it reads the 2nd integer at offset 4 rather than 8 and returns
an 8-byte address with the LSW and MSW swapped, which gives huuuuge addresses!
I can`t see any way ddins could work with this verb! (btw, iad is used by
a couple of other utility verbs, so perhaps these don`t get used a lot either!)
And, If I correct <iad>, the call to SQLExecDirect a bit later does return
a 070001 error, about not all parameters being bound. Which is pretty normal,
since ddins does bother to SQLBindParam only later!
How long ago have you checked ;-P it did work for you? And I`d like to know
the rationale for using SQLExecDirect there rather than wait and use SQLExec
after the binds?
Regards,
Denis
_________________________________________________________________
Look 'em in the eye: FREE Messenger video chat
http://go.microsoft.com/?linkid=9734386
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
