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

Henrique Damasceno Vianna henrique.vianna at terra.com.br
Wed Aug 16 13:30:01 BST 2006


Daniel,

I've this problem with php once and there was nothing to do with 
freeTDS. Try to limit your output in SQL query. It's probably the write 
of a great number of tuples in your php code that's causing that behaviour.

Regards,
Henrique

cadastros at daniellima.net wrote:
> Folks,
>
> I've tried the command php and got this answer:
>
> Segmentation fault
>
> What the hell is this?
>
> Att
>
> Daniel Lima
>
> Subject:
> RE: [unixODBC-support] Prompt ok, PHP no.. :(
> From:
> Stefan Radman <Stefan.Radman at ctbto.org>
> Date:
> Tue, 15 Aug 2006 10:46:49 +0200
> To:
> "Support for the unixODBC project" <unixodbc-support at easysoft.com>
>
> 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
>>>
>>>       
>
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
>
>
>
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
>
> Esta mensagem foi verificada pelo E-mail Protegido Terra.
> Scan engine: McAfee VirusScan / Atualizado em 15/08/2006 / Versão: 4.4.00/4830
> Proteja o seu e-mail Terra: http://mail.terra.com.br/
>   



-------------------------------------------------------------------------
Somente as pessoas nomeadas no endereco podem abrir esta mensagem,
se voce recebeu por engano, por favor reenvie para qualquer delas,
comunicando o fato e elimine esta mensagem. E expressamente proibido abrir,
divulgar ou copiar esta mensagem ou seus arquivos no todo ou em parte.

-- 
Esta mensagem foi verificada pelo sistema de antivírus e
 acredita-se estar livre de perigo.





More information about the unixODBC-support mailing list