Need help ODBC on Linux connecting to another Linux machine

[Auriferous]

I have OE101C01_linux.tar
Installing on Oracle Enterprise Linux
Attempting to connect to RHEL running progress dataserver

I can run the installation and install things ok. I'm not sure what I need to do after this in order to create a system DSN so that I can connect via php. I tried using unixODBC but i'm getting errors. From what I understand I don't need to use unixODBC but am unsure what I need to do. Something with exporting variables?

Can anyone help me out or point me to some good info on this?

Thanks,

Bryan

 

[Cecil Snodgrass]

I have OE101C01_linux.tar
Installing on Oracle Enterprise Linux
Attempting to connect to RHEL running progress dataserver

I can run the installation and install things ok. I'm not sure what I need to do after this in order to create a system DSN so that I can connect via php. I tried using unixODBC but i'm getting errors. From what I understand I don't need to use unixODBC but am unsure what I need to do. Something with exporting variables?

Can anyone help me out or point me to some good info on this?

Thanks,

Bryan

Your trying to connect to an Oracle db from PHP, what do you need Progress for?

 

[Auriferous]

Not trying to connect to Oracle.. The OS is Oracle Enterprise Linux 5.2. Its basically RHEL 5

 

[vinod_home]

Did you setup the odbc on the database server and test connecting using sqlexp on the server.

you should be able to search the forums or progress knowledge-base for more information.

http://web.progress.com/openedge/support.html

ID: 21017
Title: "Two Sample PHP Programs to Access a Progress DB through ODBC"

 

[Auriferous]

Thanks for the help.. I'll check them out.

One question.. I have the driver installed. I was trying to use the driver manager from the package but it seems the only way to do it is through unixODBC?

 

[Auriferous]

Ok.. check out that article. The php side is not where i'm having trouble. I have openedge set up on a windows machine and have no problem setting up a windows DSN and connecting with php.

My problem is on how to configure a dsn on the linux machine. I have no problems configuing mysql with unixODBC but can't seem to get the progress driver to work.

Also to note is that the data server is on another linux machine. ..and like I said with the same situation on windows I can connect to the dataserver.

 

[Auriferous]

I get this error:


Warning: odbc_connect() [function.odbc-connect]: SQL error: [unixODBC][Driver Manager]Can't open lib '/usr/dlc/odbc/lib/pgpro1019.so' : libpgicu19.so: cannot open shared object file: No such file or directory, SQL state 01000 in SQLConnect in /var/www/html/SugarCRM/test.php on line 3
Connection Failed to SXNote


I checked and both of these files exist.

 

[rstanciu]

1) check the good library:

ls -al $DLC/odbc/lib/pg*
and modify the Driver entry if is the case.

2) a sample config file is into the odbc.ini on $DLC/odbc/example

3)
cd $DLC/odbc/lib ... and check if the shared libraries are ok ...
ldd *

because "Oracle Enterprise Linux" is a non-supported system for OpenEdge !!!!!


[ODBC Data Sources]
sports=Progress_SQL_Driver
[sports]
Driver=/usr/dlc/odbc/lib/pgpro1019.so

 

[rstanciu]

another ideea is to export this variable before startig the service/program who invoke the
odbc connection (.profile of apache ?).
In the case when you are in a "unsupported" configuration.

LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL;

 

[Auriferous]

Appreciate the pointers and especially the shell commands as I'm still a bit of a noobie on linux. I did not know that Oracle Enterprise Linux was unsupported... its really just RHEL... more so the CENTOS probably.

I will try your suggestions and see how it works out.

Thanks again!

Bryan

 

[Auriferous]

Also,

I did try.. LD_ASSUME_KERNEL=2.4.1

but not.. export LD_ASSUME_KERNEL;

I'm still new at working with environment variables. Could you possibly explain the difference in those two statements?

Also, is this something that would have to been done each time the machine is booted? Shouldn't the variables be set from a configuration file that runs each time the machine boots?

 

[rstanciu]

dont't worry ... tell me what he says:
cd $DLC/odbc/lib
ldd *

 

[rstanciu]

Oracle Enterprise Linux is an unsuppored version of OS , check this:

http://www.progress.com/progress_software/products/docs/bu_sep/openedge_10_availability_guide.pdf

we have to do a lot of "ln -s " to get him work's ...

 

[Auriferous]

[root@ftpsrv ~]# LD_ASSUME_KERNEL=2.4.1
[root@ftpsrv ~]# LD_ASSUME_KERNEL=2.4.1
[root@ftpsrv ~]# export LD_ASSUME_KERNEL
[root@ftpsrv ~]# cd $DLC/odbc/lib
bash: cd: /odbc/lib: No such file or directory
[root@ftpsrv ~]# ldd *
/bin/sh: error while loading shared libraries: libdl.so.2: cannot open shared object file: No such file or directory
[root@ftpsrv ~]# $DLC
[root@ftpsrv ~]# cd $DLC
[root@ftpsrv ~]# cd $DLC/lib
[root@ftpsrv lib]#

 

[Auriferous]

[ODBC Data Sources]
SXNote=Progress_SQL92_Driver

[SXNote]
Driver=/usr/dlc/odbc/lib/pgpro1019.so
DatabaseName=nxt
PortNumber=7150
HostName=192.168.136.195
LogonID=sysprogress
Password=123
APILevel=1
ConnectFunctions=YYN
CPTimeout=60
DriverODBCVer=03.60
FileUsage=0
SQLLevel=0
UsageCount=1
ArraySize=50
DefaultLongDataBuffLen=2048
DefaultIsolationLevel=READ COMMITTED
StaticCursorLongColBuffLen=4096

[ODBC]
InstallDir=/usr/dlc/odbc
Trace=0
TraceFile=odbctrace.out
TraceDll=/usr/dlc/odbc/lib/odbctrac.so
UseCursorLib=0

 

[rstanciu]

you are not exported the variavle DLC (Data Language Compagnie - the installation directory for Progress) , anyawy,
cd /usr/dlc/odbc/lib
ldd *

... what hi says ?

 

[rstanciu]

I thing you are miss the library libdl.so.2 , try to locate libdl.so.2 ??? what is says ?

 

[rstanciu]

The ideea is to validate your OS compatibility, to check if all shared libs are in place,
if you find a ldd error tell me.

 

[Auriferous]

Ok.. So why is odbc/lib show up in the root path but not in the other?

[root@ftpsrv ~]# cd /usr/dlc/odbc/lib
[root@ftpsrv lib]# cd /
[root@ftpsrv /]# cd root
[root@ftpsrv ~]# cd $DLC/odbc/lib
bash: cd: /odbc/lib: No such file or directory
[root@ftpsrv ~]#

 

[Auriferous]

libdl.so.2 is on the system in root.... /lib