1. Forum
  2. Usenet
  3. COMP.LANG.REXX

  • SQLCONNECT Returns -1

    From Gerard MARTINELLI@21:1/5 to All on Wed Feb 20 02:58:50 2019
    Hello,

    Under windows 8.1, I have just installed Regina (64 bits) and also rxsql26B3_odbc_w64_Regina.zip.

    My sample test is the following :

    /* ****************************************************************** */

    trace ?r
    4 *-* Call RXFuncAdd 'SQLLoadFuncs','rexxsql','SQLLoadFuncs'
    +++ Interactive trace. "Trace Off" to end debug. ENTER to continue.

    5 *-* Call SqlLoadFuncs

    6 *-* rc = sqlconnect(, , , "Mysql" )
    >=> "-1"
    exit;

    /* ****************************************************************** */


    I also tried with several other bases, for example :

    rc = sqlconnect(,"MyId" ,"MyPW" , "MyBase" )

    every time SQLCONNECT returns -1.

    The same code use to work with oobjectRexx (that I un-installed).

    Do i have to do something different with Regina ?

    Thanks a lot.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Gerard MARTINELLI@21:1/5 to All on Fri Mar 1 07:23:26 2019
    Le mercredi 20 février 2019 11:58:51 UTC+1, Gerard MARTINELLI a écrit :
    Hello,

    Under windows 8.1, I have just installed Regina (64 bits) and also rxsql26B3_odbc_w64_Regina.zip.

    My sample test is the following :

    /* ****************************************************************** */

    trace ?r
    4 *-* Call RXFuncAdd 'SQLLoadFuncs','rexxsql','SQLLoadFuncs'
    +++ Interactive trace. "Trace Off" to end debug. ENTER to continue.

    5 *-* Call SqlLoadFuncs

    6 *-* rc = sqlconnect(, , , "Mysql" )
    >=> "-1"
    exit;

    /* ****************************************************************** */


    I also tried with several other bases, for example :

    rc = sqlconnect(,"MyId" ,"MyPW" , "MyBase" )

    every time SQLCONNECT returns -1.

    The same code use to work with oobjectRexx (that I un-installed).

    Do i have to do something different with Regina ?

    Thanks a lot.

    I have resolved my problem. It was just a problem of cases for the username.
    I thought that this is only important for the user password, but it is also for the user name.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)