last updated at 31 Mar, 2006 02:57 (1 times)
SORRY FOR THE DOUBLE POST
I'm trying to use RexxSQL v2.4r1 and am having problems loading the functions. I am trying the following:
If RxFuncQuery('SQLLoadFuncs') Then
RTC=RxFuncAdd('SQLLoadFuncs', 'rexxsql', 'SQLLoadFuncs')
Say RTC" Returned"
Say RTC"on load"
Say "Functions already loaded."
I've broken it down like this to try to find what is hanging or where... the results are as follows.
(1) if I've tried previously to load the functions, dropping SQLLoadFuncs returns 0 for success
(2) RxFuncAdd returns 0 for success of loading SQLLoadFuncs
(3) SQLLoadFuncs errors with
35 +++ RTC = SQLLoadFuncs();
REX0043: Error 43 running C:\scripts\RX_SQL_Connect.cmd, line 35: Routine not found
Though, if I try to drop the function with RxDropFunc, it returns success as if it is loaded.
Is there a DLL or library that is needed by RxSQL for it to function? I have EMXRT installed (from the WarpIn package), and vrobj.dll - am I missing something? Is it a case sensitivity issue?
I've tried the sample scripts that come with RxSQL and had the same results (SQLLoadFuncs not found, SQLDropFuncs not found, etc).
Any help would be greatly appreciated.