Rexx/SQL Activity
An external Rexx function package to connect to SQL databases
Brought to you by:
rexx
Activity for Rexx/SQL
-
SIMON R HUSIN posted a comment on discussion Help
Hello Mark Hessling, All, Do you have any idea what caused such an error is returned by rexxsql.dll ? More info is in the subject line. This consistently occurs on only one PC, running Windows 10, with 16Gb RAM, more than 4Gb RAM available. The Rexx engine is OORexx version 4.2.0 from Feb. 22, 2014. The Oracle client: Release 12.2.0.1.0 Prod. Any info and help will be much appreciated. -Simon in Nashville, Tennessee
-
Mark Hessling posted a comment on ticket #5
I've given this a bit more thought and I think Option 1 is best. Disadvantage of Option 2 is that it would be slower.
-
Hi Jon, There are 2 ways I can implement this: 1) Provide a MYEscapeString() function which calls mysql_real_escape_string() and returns the escaped string 2) Add a SQLVariable() option to turn on "escaping" so that when a string value is passed to SQLCommand() or SQLExecute() as a bind variable it is escaped. Option 1 provides more flexibility for the user but adds an external function that is just for mySQL (not that there aren't other examples of this) Option 2 is neater, but enforces the escaping...
-
mySql escape string
-
There are 2 ways I can implement this: 1) Provide a MYEscapeString() function which calls mysql_real_escape_string() and returns the escaped string 2) Add a SQLVariable() option to turn on "escaping" so that when a string value is passed to SQLCommand() or SQLExecute() as a bind variable it is escaped. Option 1 provides more flexibility for the user but adds an external function that is just for mySQL (not that there aren't other examples of this) Option 2 is neater, but enforces the escaping to...
-
Oracle bind by number fails
-
Jon Wolfers created ticket #5
mySql escape string
-
Hi Jon, Support request is ok. I built Rexx/SQL with the MySQL 8.0 API on Linux and it connected with a caching_sha2_password login without any change. Also connected to a remote database with a mysql_native_password login and it also worked. I'm assuming that you are using Windows; I'm hoping I just need to build Rexx/SQL for MySQL using the 8.0 API and it will connect to both login types. I might need to supply the MySQL 8.0 DLL with the Rexx/SQL installer as an option.
-
MySql caching_sha2_password
-
Jim French posted a comment on discussion Help
Hi - I'm a newbie to the RexxSQL world. I just installed RexxSQL and I'm getting an error trying to connect to my MySQL database running Simple.cmd. I am running it using the command: rexxsql simple.cmd user=Jim pass=xxxxx data=test. and receiving the error: Program failed: connecting REXX/SQL-1: Database Error (IM002) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. I have set up my path parameter as follows: PATH=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program...
-
I have a query to create (or recreate) a function under MySQL (tested on 5.7 and 8) DROP FUNCTION if exists lastMonth_end; DELIMITER $$ CREATE FUNCTION lastMonth_end() RETURNS DATE DETERMINISTIC BEGIN DECLARE endDay DATE ; select last_day(now() - interval 1 MONTH) INTO endDay ; RETURN endDay ; END $$ If I enter it in my SQL client application (HeidiSQL) it works, but if I prepare and execute it using RexxMy (tested on 2.6.0.0 Dec 21) I get an SQL error like the one below. In the past, I have worked...
-
Bob Pesner posted a comment on discussion Open Discussion
Sorry for the delayed thought, but I should also mention that I wrote a c program to make the same calls directly to unixODBC and they all worked normally.
-
Mark, I should have mentioned that the tester.cmd program fails during the connect phase because the call to SQLGetInfo doesn't return a datatype list.
-
Mark, Thanks for looking at this. This, to me, is a weird one. After more extensive testing, I've discovered two bugs that each occur in two places in the Rexx/SQL code. Both places involve calls to unixODBC functions. In one pair, a local c variable that is being passed by value is being overwritten with 0. In the other pair, the result is an error in the PostgreSQL ODBC driver. All these points in code are in cli-odbc/rexxcli.c Here are the details (my environment is described below): On a call...
-
Hi Bob, stmt should not be null until the call to ReleaseStatement(). FreeArgv() only frees the stmt->Argv pointer; stmt should still be valid. If stmt is null where you put the tests in, then there is some other issue. Can you dump stmt at various stages through SQLCOMMAND to see where it first becomes NULL? Can you run samples/tester.cmd with the original code and see if it works. Thanks, Mark
-
I ran into the same problem on Fedora 31 with rexxsql 26B3 trying to issue an sql insert statement against a PostgreSQL database using ODBC. I traced the problem to two lines in the SQLCOMMAND function in cli-odbc/rexxcli.c. After the statement provided to the function is executed, the function calls FreeArgv to free the statement at various lines. By the time it gets to the call to FreeArgv at line 2826, the statement is already null, so I added an if to skip the call if stmt is null. And a few...
-
Norbert posted a comment on discussion Help
I am runnng ooRexx 4.2.0 and RexxSQL 2.6 beta 3 on CentOS 6 since 2015. Starting around 2018, rebooting Linux would intermittently cause Call RXFuncAdd 'SQLLoadFuncs','rexxsql','SQLLoadFuncs' to fail with return code 1. Internet searches suggested ld.so.cache had become corrupted, and the fix was to run ldconfig. However, that would not correct the problem immediately. I did a reboot yesterday at 09:00, detecte dthe issue at 10:48, ran ldconfig -v, but was still able to reproduce the problem at 14:30....
-
Jo Seegers posted a comment on discussion Open Discussion
Problem solved, however I don't know why. I deinstalled Open Object Rexx and reinstalled it (64 bit version). Without changing anything else it works. Regards, Jo
-
Only thing I can think might be causing this is that libmysql.dll is not in a directory in PATH. Are you running the 32bit or 64bit version of ooRexx and Rexx/SQL?
-
Hi , I opened a ticket for my problem, but it looks like nobody is handling tickets. Probably somebody who implemented REXX SQL together with Open Object REXX can help out. I don'believe I believe I do/did something wrong. Help is appreciated. The problem is opened 2 days ago (nr 33). Regards, Jo
-
Failed to load external library libmysql
-
Sam Boker modified a comment on discussion Open Discussion
Please see problem ticket 32 I have sucessfully compiled RexxSql 2.6B3 with UnixODBC on modern RHEL distros Fedora 31 and Centos 8. I have tried with ooRexx 4.2, ooRexx beta 5, and the newest Regina 3.93. The rexx interpreters are always installed with RPM packages and the RexxSql compiles and installs sucessfully. With all 3 Rexx interpreters, a RexxSQL script will sucessfully execute a query, but fail (core dump) when attempting to update a table. Any help with this would be greatly appreciated....
-
Please see problem ticket 32 I have sucessfully compiled RexxSql 2.6B3 with UnixODBC on modern RHEL distros Fedora 31 and Centos 8. I have tried with ooRexx 4.2, ooRexx beta 5, and the newest Regina 3.93. The rexx interpreters are always installed with RPM packages and the RexxSql compiles and installs sucessfully. With all 3 Rexx interpreters, a RexxSQL script will sucessfully execute a query, but fail (core dump) when attempting to update a table. Any help with this would be greatly appreciated....
-
Trouble with RexxSql 2.6B3 ooRexx UnixODBC on centos 8
-
With what Rexx interpreter, with what database? Please include in the bug report the configure switches and the version of the database you are linking with and the version of Rexx you have installed and are linking with.
-
turgut kalfaoglu created ticket #39
Segmentation fault
-
Neale Ferguson created ticket #31
DB2 - sqlcli.h defines ULONG as 32-bits
-
taf created ticket #30
Responded to discussion, but need response forwarded to Support
-
Help to compile/build RexxSQL for debugging.
-
Sorry it's taken so long to respond to this.. There are two ways to make this work. One way is to (for mysql only, I believe) just issue the select statement directly to rexxsql: ` selStmt='select col1,col2 from table1' insStmt="insert into table2 col3'" sql_rc=SQLCommand('S1',selStmt) -- iterate thru the result set: loop i=1 to s1.col1.0 -- compute summary result col3=s1.col1.i -- or whatever sql_rc=SQLCommand('P1',insStmt || col3 || "'") end The only drawback to the above is that the entire resultset...
-
RodD created ticket #28
64-bit ODBC Failure: (22001) [Microsoft][ODBC SQL Server Driver]String data, right truncation
-
Gerard MARTINELLI modified a comment on discussion Help
After a lot of tries I finally understood and resolved my problem; Just to help in...
-
After a lot of tries I finally understood and resolved my problem; Just to help in...
-
I have the same problem. Even if I'm doing a little differently : I'm tring to select...
-
Hello I'm pretty new in REXXSQL but I'm practicing REXX since 1978 when I was in...
-
Rexx/SQL for MySQL and OOrexx crashes when many columns are retrieved
-
JM Buisson created ticket #26
RexxSQL Wrong fetch return
-
Rexx/SQL released /OldFiles/rxsql24_ora_w32.zip
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Hi, Configuration : System Windows 7 ultimate 64bits Last version aff OOResxx, RexxMySQL,...
-
Problems Compiling Rexx/SQL 2.6B3 with ooRexx 4.1.3 on CentOS 5.5
-
My limited understanding of compiling and installing ooRexx is that it requires more...
-
Problems Compiling Rexx/SQL 2.6B3 with ooRexx 4.1.3 on CentOS 5.5
1
