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 Files (x86)\Intel\Intel(R) Management Engine Components\iCLS\;C:\Program Files\Intel\Intel(R) Management Engine Components\iCLS\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Calibre2\;D:\Applications\Regina;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;d:\applications\Cobol.4.7.6\GnuCOBOL\bin;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\Jim\AppData\Local\Microsoft\WindowsApps;d:\applications\Nmap;d:\applications\Rexx;
I currently have the rexxsql dll's and executables in the same directory as my rexx executables - I tried a different folder, but received the same error.
I must be missing something here. I would appreciate any help in resolving this issue. As I said, I'm new to integrating SQL into my rexx programs. Thanks again. Jim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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 Files (x86)\Intel\Intel(R) Management Engine Components\iCLS\;C:\Program Files\Intel\Intel(R) Management Engine Components\iCLS\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Calibre2\;D:\Applications\Regina;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;d:\applications\Cobol.4.7.6\GnuCOBOL\bin;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\Jim\AppData\Local\Microsoft\WindowsApps;d:\applications\Nmap;d:\applications\Rexx;
I currently have the rexxsql dll's and executables in the same directory as my rexx executables - I tried a different folder, but received the same error.
I must be missing something here. I would appreciate any help in resolving this issue. As I said, I'm new to integrating SQL into my rexx programs. Thanks again. Jim