[unixODBC-support] Prompt ok, PHP no.. :(

Stefan Radman Stefan.Radman at CTBTO.ORG
Tue Aug 15 09:46:49 BST 2006


Ever tried executing php from the command line instead of using apache?
What's the result?


Some hints:

Permissions on odbc.ini/odbcinst.ini
http://mail.easysoft.com/pipermail/unixodbc-support/2005-February/000365
.html 

Library search path
http://www.easysoft.com/developer/languages/php/apache_odbc.html#appc


Stefan

> -----Original Message-----
> From: unixodbc-support-bounces at easysoft.com 
> [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of 
> cadastros at daniellima.net
> Sent: Monday, 14 August, 2006 19:34
> To: unixodbc-support at easysoft.com
> Subject: [unixODBC-support] Prompt ok, PHP no.. :(
> 
> Lets see if I can make any progress here :D
> 
> I'm using SuSe 9.3, PHP 4, Apache 2 with unixODBC and FreeTDS.
> 
> I made all the things that I had to connect to my SQL Server.
> 
> In prompt it works greatfully:
> 
> isql -v MSSQLTestServer X x
> 
> When it comes to PHP I did:
> 
> $connect = odbc_connect("MSSQLTestServer", "X", "x");
> $query = "SELECT * FROM products";
> $result = odbc_exec($connect, $query);
> 
> while(odbc_fetch_row($result)) {
>  $field1 = odbc_result($result, 1);
>  $field2 = odbc_result($result, 2);
>  print("$field1 $field2\n");
> }
> 
> odbc_close($connect);
> 
> In isql mode it works fantatisc but in PHP it seens that no aswers ins
> given... I think PHP is not able to talk to unixODBC and FreeTDS.
> 
> The PHP error is somethink like "Empty page" (apache error)...
> 
> Somebody makes any idea of what is wrong..
> 
> Thanks
> 
> Daniel LIma
> 
> P.S: I've tried every single tip that I found on php help about
> odbc_connect...
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 




More information about the unixODBC-support mailing list