Hi Marcus,<br><br>I'm no expert on this (still having problem with it myself) but you can download unixODBC from <br><a href="http://www.unixODBC.org">www.unixODBC.org</a><br><br>that error looks nasty, good luck solving your problem.<br>
<br>Cheers, Ed<br><br><br><br><br><div class="gmail_quote">2009/1/22 Lorenz, Marcus <span dir="ltr"><<a href="mailto:Marcus.Lorenz@unilever.com">Marcus.Lorenz@unilever.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<div><span><font face="Arial"><font size="2"><span>Hello everybody</span>,</font></font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial"><font size="2">i have a
problem with the odbc_exec function in PHP<span> and i
hope i have addressed the right component in the execution chain of this
function for my problem</span>.<span> If not please let
me know.</span></font></font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial"><font size="2"><span>F</span>irst our
environment:</font></font></span></div>
<div><span><font face="Arial" size="2">- Red Hat Enterprise
Server 5.2</font></span></div>
<div><span><font face="Arial" size="2">- unixODBC (Version
?<span> How can i get that</span>)</font></span></div>
<div><span><font face="Arial" size="2">- FreeTDS stable
version available at the 16.12.2008</font></span></div>
<div><span><font face="Arial" size="2">- MsSQL Server 2005
Enterprise 64Bit.</font></span></div>
<div><span><font face="Arial" size="2">- PHP ADO
DB</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">The problem is, that
i can't execute any statements using parameter bindings<span> together with odb_execute</span>. If i include the
parameters into the query directly i get the expected results. If i pass them to
odbc_execute as an array i only get the following error:</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">odbc_mssql error:
[00000: ° ±ÿÂ] in EXECUTE("select top 1 * from
master.Importstatus WHERE importer=? order by id desc")</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">The odbc_prepare()
before<span> is executed successfully
and</span> returns a valid statement resource.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">The id 00000 normaly
means that the query could be executed successfully (then why is it issuing
th<span>i</span>s error?).</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">
<div><span><font face="Arial" size="2">This is (a part
of) the freetds.config:</font></span></div></font></span></div>
<div><span><font face="Arial" size="2">[global]<br> # TDS protocol
version<br> tds version =
8.0</font></span></div>
<div><font face="Arial" size="2"></font> </div>
<div>
<div><span><font face="Arial" size="2">This is (a part
of) the odbc.ini:</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">[ODBC Data
Sources]</font></span></div>
<div><font face="Arial" size="2"></font> </div>
<div><span><font face="Arial" size="2">[Default]<br>Driver
= /usr/local/freetds/lib/libtdsodbc.so<br></font></span></div>
<div><span><font face="Arial" size="2"><span>....</span></font></span></div>
<div><span><font face="Arial" size="2"> </font></span></div></div>
<div><span><font face="Arial" size="2">[<span>MSSQL_Server</span>]<br>Driver
= FreeTDS<br></font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">I'm developing the
same application under my own windows (i have to use
it...) environment <span>using the win32 odbc
library </span>and everything works fine. When i copy it to the enterprise
server using linux i get the descibed error.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">So any help would be
greatly appreciated.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div>
<div><span><font face="Arial" size="2">Thank you<span> very much</span>.</font></span></div>
<div><span><font face="Arial" size="2"></font></span> </div><font color="#888888">
<div><span><font face="Arial" size="2">Marcus<span> Lorenz</span>.</font></span></div></font></div>
<br>_______________________________________________<br>
unixODBC-support mailing list<br>
<a href="mailto:unixODBC-support@mailman.unixodbc.org">unixODBC-support@mailman.unixodbc.org</a><br>
<a href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br>
<br></blockquote></div><br>