FreeTDS Development Group

[Helio Cavichiolo Jr <hcav AT ig.com.br>]

Em Qua 09 Out 2002 17:36, you wrote:
> > Warning: SQL error: [unixODBC]Statement option not
> > implemented, SQL state 08001 in SQLSetStmtOption in
> > /var/www/htdocs/traceability/rpelog02.php on line 5
>
> Helio,
>
> ODBC is not my specialty.  Do you know what statement option you're
> setting? There have been some discussions here recently about such things. 
> Not every one is implemented.
>
> --jkl

I'm just trying to do a simple select. I can't do any type of select. Today 
I've compiled unixODBC 2.2.3 and freeTDS 0.60 with protocol version 7.0. Now 
I have that message on connecting as shown bellow:

Warning: SQL error: [unixODBC]tds_connect failed, SQL state 08001 in 
SQLConnect in /var/www/htdocs/teste.php on line 3

And here is the "big program":

<?

$connect = odbc_connect("APIS", "as", "***********");
$query = "select nome from transportador";
$result = odbc_exec($connect, $query);
while (odbc_fetch_row($result)) {
  $nome = odbc_result($result, 1);
  echo "$nome<br>\n";
}
odbc_close($connect);

?>