| 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: 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:
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, |
| 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") ? HTH - Greetings |
| 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).
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, |
| 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 |
| 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) 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, |