Hello community,
as this is my first post here, I will introduce myself first. My name is Marcel and I am an interface-coder at a medium-size software-company which creates webshops.
I am responsible to connect the webshop to an ERP-system (like GWS, Sangross, DIACOM, SAP etc.pp) with XML, SOAP, Rest or similar webservices.
So: Now one customer is using a VPN-Tunnel and wants me to connect from our linux-machine over the tunnel to a progress-database.
Our webshop is based on php so I decided to connect through odbc and open a connection to a remotehost through the vpn-tunnel.
The tunnel works like a charm but now I am on a blind alley barking the wrong tree. (and english is not my native language so never mind)
What exactly do I have to do to get this piece of code working:
Please consider myself dumb and goofy because I absolutely do not have ANY idea how to even start.
Which drivers should I use? Where do I get them (we do not own Progress here)? How do I write an odbc.ini,odbcinst.ini and make php use them?
A lot of questions but as I even tried everything else and nothing worked, I need the help of you
Kind regards,
Marcel
as this is my first post here, I will introduce myself first. My name is Marcel and I am an interface-coder at a medium-size software-company which creates webshops.
I am responsible to connect the webshop to an ERP-system (like GWS, Sangross, DIACOM, SAP etc.pp) with XML, SOAP, Rest or similar webservices.
So: Now one customer is using a VPN-Tunnel and wants me to connect from our linux-machine over the tunnel to a progress-database.
Our webshop is based on php so I decided to connect through odbc and open a connection to a remotehost through the vpn-tunnel.
The tunnel works like a charm but now I am on a blind alley barking the wrong tree. (and english is not my native language so never mind)
What exactly do I have to do to get this piece of code working:
PHP:
<?php
$server = 'localhost';
$database = 'sanitaer';
$user = 'sansys';
$password = 'myfantasticpassword';
$port = '2502';
$isolationlevel = 'READ UNCOMMITTED';
$connection = odbc_connect("DRIVER={Progress OpenEdge 10.2B Driver};Hostname=localhost;Port=2552;Db=sanitaer;UID=sansys;PWD=Progress;DIL=READ UNCOMMITTED", $user, $password);
$sql = "SELECT kdnr from SANITAER.PUB.kund";
$rs = odbc_exec($connection, $sql);
print $rs;
print odbc_result_all($rs);
odbc_close($connection);
?>
Please consider myself dumb and goofy because I absolutely do not have ANY idea how to even start.
Which drivers should I use? Where do I get them (we do not own Progress here)? How do I write an odbc.ini,odbcinst.ini and make php use them?
A lot of questions but as I even tried everything else and nothing worked, I need the help of you
Kind regards,
Marcel