On server_1: I am running:-
Windows 2003 Web Edition SP2
PHP 5.2.5, QuickBooks Pro 2006
QODBC server edition 10.00.00.266
The QuickBooks data file is on server_2. Using QB Pro 2006, on server_1, I can connect to the data file on server_2 using QuickBooks on server_1.
I have set up the QODBC and have the System DSN as "QuickBooksData" (the default install was named "QuickBooks Data" but I removed the space to ensure it wasn't that causing my problems). Running a VB script supplied with the QODBC on server_1 I can connect to this DSN and submit queries.
Using the very simple PHP script attached:-
I get a time out with no error.
In order to discount the ODBC configuration of server_1, I then created a test DSN to MySQL called "TestMySQL". This works with the VB script.
If I edit the PHP script to read:-
$strODBCName = 'TestMySQL';
I get a connection and can build queries and display the MySQL data. This would seem to indicate that there is something critically wrong between PHP and QODBC.
Can someone suggest a way of troubleshoot this please as there appear to be no errors I can capture in PHP and the server even log shows nothing.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<title>QODBC PHP Script To Display SQL Results</title>
Show Results<br />
$strODBCName = 'QuickBooksData';
$oConnect = odbc_connect($strODBCName, '', '');