Miles
|
| Posted: 05/05/2004, 1:00 AM |
|
Why, even if is possible to use Informix within PHP, Codecharge does not support it?
There is a workaround or a future patch?
Thanks.
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 05/05/2004, 12:09 PM |
|
CodeCharge Studio supports Informix.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Miles
|
| Posted: 05/06/2004, 6:42 AM |
|
So sorry for the stupid question.
I didn't check it on the program, but I read only the manual that obviously should be an older version.
Sorry again and thanks
Giuseppe
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/06/2004, 11:52 AM |
|
Not a problem.
Though we support all databases via ODBC, therefore I didn't suspect that our documentation would list any specific databases.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Miles
|
| Posted: 05/07/2004, 1:26 AM |
|
Sorry to bother you again, but under the PHP Databse Library dropdownlist there is no explicit Informix.
Maybe I could use ODBC, but could I then deploy the project to Linux?
Here is what the manual says:
The server-side database connections in PHP are implemented using database libraries. Each library contains code that encapsulates the functions needed to carry out database operations. Currently, there are libraries for Interbase, mSQL, MySQL, ODBC, Oracle, Oracle OCI, PostgreSQL, SQL Server, SQL Anywhere and Sybase.
Figure 7-14: Selecting a PHP Database Library
If the database that you intend to use is not among the list of Figure 7-14, you should find out if there is an ODBC driver for the database so that you can connect to the database through ODBC. For instance, if you intend to use a Microsoft Access database, you could create an ODBC DSN for the database then configure the server-side connection to connect through ODBC. Of course, a Microsoft Access database can only be located on a Windows machines so this precludes deploying the database on a different platform other than Windows
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/07/2004, 10:32 AM |
|
PHP for Linux supports ODBC connectivity.
Take a look at iODBC:
http://oplweb.openlinksw.com:8080/matrix/matrix.vsp?type=st
http://www.iodbc.org/index.php?page=languages/php/odbc-phpHOWTO
http://ie.php.net/manual/en/ref.uodbc.php
However, I admit that we support all databases via ODBC assuming that both the database and ODBC are standards-compliant and therefore should work correctly themselves. But it happens that various databases bring their own issues that we may need to resolve individually when reported to our support. Therefore I cannot guarantee that this will work 100% but if you encounter any isues then you can contact our support.
We will also consider offering the direct connectivity to Informix within PHP if we see more demand/requests for it.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Miles
|
| Posted: 05/31/2004, 10:18 AM |
|
After long investigation (I'm new to PHP) I found that there is a library called ADODB that abstract the connection to various DBMS.
Do you plan to use it in the future?
Thanks
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/31/2004, 1:43 PM |
|
We use currently use PHPLib library and I believe that this is what allows us to provide support for all the various databases. I don't kow of any plans of moving to ADODB and therefore I suspect that there was no such need, nor requests.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
notapplicable
Posts: 1
|
| Posted: 10/04/2004, 12:30 PM |
|
Quote peterr:
We use currently use PHPLib library and I believe that this is what allows us to provide support for all the various databases. I don't kow of any plans of moving to ADODB and therefore I suspect that there was no such need, nor requests.
Hmmmm... I have a need! ADOdb is the only method I have to reliably access our SQL Server from our Linux PHP/Apache box.
Actually I thought it already had support for it, but have realized that it was the ASP ADODB stuff, not the php ADOdb library. 
Is there any way I can add the support myself?
|
|
|
|
huflueck
|
| Posted: 03/01/2005, 6:53 AM |
|
Hello Miles
If you still couldn't access your Informix database from PHP/Linux use unixODBC together with a recent InformixClientSDK and CodeCharge ODBC/Informix type server connection. Works fine.
BTW: There's a bug in PHP v4.3.x to compile native Informix support for PHP, so just use unixODBC.
Kind regards
John
|
|
|
|
