OS2 World.Com Forum

Subject  :  Problems using RxSQL
Author  :  RobertM
Date  :  31 Mar, 2006 on 02:42
Hi,

I'm trying to use RexxSQL v2.4r1 and am having problems loading the functions. I am trying the following:


code:

say "-"rxFuncDrop('SQLLoadFuncs')

Pause
If RxFuncQuery('SQLLoadFuncs') Then
Do
Say "Loading..."
RTC=RxFuncAdd('SQLLoadFuncs', 'rexxsql', 'SQLLoadFuncs')
Say RTC" Returned"
Pause
RTC=SQLLoadFuncs()
Say RTC"on load"
Pause
End
Else
Do
Say "Functions already loaded."
End


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

code:

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.

Thanks,
Robert


Subject  :  Re:Problems using RxSQL
Author  :  warpcafe warpcafe@yahoo.de
Date  :  31 Mar, 2006 on 12:49
Hi Robert,

have you checked that what is mentioned in the INSTALL actually applies? (e.g. "copy all executables and DLLs in a directory already in the PATH") ?
It looks just like... the dll is not found. (?)

HTH - Greetings
Thomas


Subject  :  Re:Problems using RxSQL
Author  :  RobertM
Date  :  31 Mar, 2006 on 17:22
Hi Thomas,

Everything is in the appropriate DLL directory. Found some old code I had been previously using to laod the funcs, same results. DLL's and EXE's are in C:\DLL with the appropriate statement in the config.sys. (C:\DLL is actually in the PATH, DPATH and LIBPATH statements).


Tried with both Classic REXX and Object Rexx, with and without loading REXXUTIL.

One thing that might be different is the version of EMX I am using (newest one - 0944d from the WarpIn package that installs the DLLs in OS2\DLL) which I wouldnt think is an issue.

The oddest thing is, SQLLoadFuncs seems to be somewhat loaded (at least RxDropFunc seems to think the function is loaded when I try dropping it).

Is it possible this is a bad implementation of RxSQL? I believe I was previously using version 2.3 which I cannot seem to find for MySQL anymore.

Thanks,
Robert


Subject  :  Re:Problems using RxSQL
Author  :  warpcafe warpcafe@yahoo.de
Date  :  03 Apr, 2006 on 15:04
Robert,

well I remember having had troubles getting the stuff to work here as well, but unfortunately I seem to have forgotten what the cause was... I'll give it a try as soon as I get my hands back on machine running a real OS (currently at work).

But IIRC there was a "standalone" .exe coming with the package. If so - have you tried running that to see if it complains about something missing? Usually, this is better to find out missing requirements than when trying to use the dll...

Greetings
Thomas


Subject  :  Re:Problems using RxSQL
Author  :  RobertM
Date  :  04 Apr, 2006 on 18:08
Hi Thomas,

Here's what I've found. If I switch to MySQL Build 3.23.50b1 everything works. I finally managed to get an error using the newest v4 build that says "Cannot find MySQL" - I thought it might be referring to a pipe, but on closer inspection, I noticed the following...

MySQL v3 has a DLL named MySQL.DLL (and MySQLU.dll)
MySQL v4 has a DLL named MySQL42.DLL

It seems that something in the calling/naming structure of the DLLs may have changed. So, I guess unless there's a workaround, I'm stuck using v3.23.50 - though it should suffice for my purposes. Rather go back a version than spend time coding lots of SQL calls right now as I dont have the time for that.

If you know a workaround, that would be great.

Thanks,
Robert


Powered by UltraBoard 2000 <www.ub2k.com>