Main Board > Web Services

Setup EZWeb server on RedHat Linux 8.x Server

<< < (3/4) > >>

Mike King:
Well if the database is using SQL Server you might be able to use the Microsoft Linux connector.  Its not the easiest thing to setup but this link should get you started.

https://manual.pvxplus.com/?/PxPlus%20User%20Guide/Data%20Integration/Odbc%20Linking.htm

Basically you need to install unixODBC on your Linux box along with the Microsoft SQL Server ODBC Driver for Linux

nmartinez@bristolind.com:
Hi Mike,
Our JDE ERP's database is using IBM DB2.  We install "IBM System i Navigator Version 7.x " on all Windows computers, so we can choose "iSeries Access ODBC Driver" when creating the ODBC Data Source on the Windows computers (see attached file.)
Thank you.

Mike King:
There is a unixODBC driver for IBM DB2 -- perhaps that might work for you.

http://www.unixodbc.org/doc/db2.html

nmartinez@bristolind.com:
Hi Mike,
Where do you change %CONTENT_TYPE$  to "application/json"?  Is this a parameter to %PRINT_FN?  I looked via pxplus manual and could not find it..
Thank you!

Now if you want to return the data as JSON (common for intra-application data exchanges) you could put the values you want to pass back into an associative array and use the DIM LIST directive to generate the JSON.  You would then output that to %PRINT_FN and change %CONTENT_TYPE$ to "application/json".

Mike King:
You just set the global variable %CONTENT_TYPE$=... in your code that is generating the response.

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version