Hello,
I'd like to create an ODBC connection to the progress 8.3B database used by our MFGPRO 8.6E ERP, in order to make queries on it for various report purposes. The final client application would be an internal php site hosted on a different server. You can see the my configuration details at the end of this post.
I downloaded the ODBC driver UDA Single-Tier 5.1 Lite Edition, (15 days trial version), and installed it on my workstation to test it.
I first had an error message saying "system error 126 SLQSTATE=IM003" testing the connection within the windows XP ODBC utilitary, wich I found was caused by a missing dll (esql32.dll). So I installed the Progress client on my workstation, wich solved this problem.
Now, I'm having another problem on testing the connection: it sends me the error code "CONNECTION ERROR : unable to allocate server handle SQLSTATE=S1000 ".
I must admit I'm totally blocked at this point, and any help would be greatly appreciated!
Thanks by advance.
Configuration of the MFGPRO server:
-Windows 2000 5.00.2195 SP4
-Progress 8.3B
-MFG/PRO 8.6 E
Configuration of the test workstation.
-Windows XP Pro SP2
Configuration of the final desired client of the odbc connection:
-Windows 2000 5.00.2195 SP4
-Apache web server 2.2.4
-PHP 5.2.1
-MySQL 5.0.27
I'd like to create an ODBC connection to the progress 8.3B database used by our MFGPRO 8.6E ERP, in order to make queries on it for various report purposes. The final client application would be an internal php site hosted on a different server. You can see the my configuration details at the end of this post.
I downloaded the ODBC driver UDA Single-Tier 5.1 Lite Edition, (15 days trial version), and installed it on my workstation to test it.
I first had an error message saying "system error 126 SLQSTATE=IM003" testing the connection within the windows XP ODBC utilitary, wich I found was caused by a missing dll (esql32.dll). So I installed the Progress client on my workstation, wich solved this problem.
Now, I'm having another problem on testing the connection: it sends me the error code "CONNECTION ERROR : unable to allocate server handle SQLSTATE=S1000 ".
I must admit I'm totally blocked at this point, and any help would be greatly appreciated!
Thanks by advance.
Configuration of the MFGPRO server:
-Windows 2000 5.00.2195 SP4
-Progress 8.3B
-MFG/PRO 8.6 E
Configuration of the test workstation.
-Windows XP Pro SP2
Configuration of the final desired client of the odbc connection:
-Windows 2000 5.00.2195 SP4
-Apache web server 2.2.4
-PHP 5.2.1
-MySQL 5.0.27