php-odbc remote server

[periko]

Hi.

I got a server running pervasive 7.x on linux centos 5.6, I want to connect from other server running apache+php 5.x. using php-odbc library.

But I had not been able to make this, in the db server works, but my apache+php server cannot access my remote server over odbc.

This is possible or they must in the same server as the db?

On windows I can access from any station via ODBC.

Thanks!!!

[atreyu]

I know nothing about pervasive, but in general network connectivity terms...

Can the apache server see (ping) the pervasive server?

Is there a firewall on the pervasive server that might restrict connectivity?

What do the system log files on the pervasive server show (/var/log/messages, /var/log/secure)?

Is there a pervasive log that you can check?

Is there anything in the apache/php logs on the apache server (/var/log/httpd/error_log)?

[periko]

Apache && Pervasive can see each other, no fw between them.

odbc_connect don't a have field where to put my server IP, how can I make this possible?

Thanks!!!

[atreyu]

I think maybe you need to properly configure your odbc.ini file?

[periko]

I think maybe you need to properly configure your odbc.ini file?

This is my odbc.ini example

[db22a]
Description=Pervasive ODBC Engine Interface
DBQ=db22a
Driver=/usr/local/psql/lib/libsrde.so
OpenMode=0

This entry is setup by my pervasive odbc client, I have try to use settings like server=ip, others watching some odbc settings and won't work.

Any tip will be appreciated, thanks!!!