Forum Post: RE: DataDirect being called by Progress

[clive@applog.co.nz]

Sorry I did not fully detail the problem. I want to call the odbc from a unix machine not a windows machine. The dataserver does not handle xml data types ( yes I can load a view to handle this ) but the supplier of the DB has said you change the DB in any way then all the issues you log may be chargeable as you have changed the DB. The samples are all windows based and the ERP is based on unix. I have got the ODBC connect to work using the sample code which is compiled C code so the system should work I just want it to work with progress 4gl. Progress 11.4 on red hat. SQL 2014 in server 2008 Datadirect odbc. So this would be easy if it was windows based. Clive Biddulph Analyst/Programmer Applied Logic Systems Ltd Level 1, 1 Marewa Road, Greenlane, Auckland 1051 | PO Box 74-552, Market Road, Auckland 1546 Ph +64 9 520 1853 Fax +64 9 520 8051 Email clive@applog.co.nz Web www.appliedlogicsoftware.com The information contained in this email is intended for the recipient(s) only. It may contain privileged or confidential information. If you are not the intended recipient of this email, you must not copy, distribute or take any action that relies on it. If you have received this email in error, please notify the sender immediately and then delete the message. Whilst Applied Logic Systems Ltd uses virus scanning software, we exclude all liability for viruses or similar in this email or in any attachment. From: Peter Judge [mailto:bounce-pjudge@community.progress.com] Sent: Friday, 26 September 2014 12:57 a.m. To: TU.OE.General@community.progress.com Subject: RE: [Technical Users - OE General] DataDirect being called by Progress RE: DataDirect being called by Progress Reply by Peter Judge You can look at the SQL Dataserver product which allows you to write normal ABL against a MSSQL database. If you just want to use ODBC, you can use the sample and approach at this page: community.progress.com/.../2179.integrating-datadirect-cloud-and-progress-easyl-into-openedge-using-the-odbc-bridge-sample-applications.aspx . You will need to modify src\OpenEdge\Data\ODBC\DriverManagerLib.i to point to the ODBC .so and will need to recompile the ABL, but after that it /should/ work. -- peter Stop receiving emails on this subject. Flag this post as spam/abuse.

Continue reading...