Filemaker ODBC PHP Problem

[Musa Ulker]

Hello,

I have a php website and want to access filemaker database and show information from that db.

System: Windows 2003

Filemaker Server version:

ODBC Driver: DataDirect SequeLink 5.5 Client for ODBC

PHP Version: 5+

PHP ODBC Library: Installed

Web Server: IIS 6

Here are the steps that I've done:

- Filemaker server was installed successfully

- Our db is installed on filemaker server.

- ODBC driver installed.

- Created a new ODBC dsn for filemaker server.

- Used classical PHP ODBC library to access and query the tables.

Everything works fine. But on local development enviorment and local server deployment machine..

When I run the PHP code on my computer where I have a apache-php installation on windows, it runs successfully.

I upload the files to the webserver and configured as properly. The php pages are working when I open them on server remote desktop.

But the problem is when PHP pages are called from internet the ODBC driver gives an error that I cannot find a way to understand it:

Unable execute query: DB Error: unknown error SELECT topic, Created_by FROM KnowledgeBase [nativecode=S1000 [DataDirect][ODBC SequeLink driver]Error on input or output to a file.]

I cannot resolve it. How can I solve this problem?

Your regards,

Musa

[Rishali]

Hi,

As per your description it seams when you transfer your php code as well as database to the server odbc conection stops working...

If that is the case then you have to add your system ip to the servers remote connection then it will work ...

hope it solves your problem ..

All the best

-Rishali