Skip to Content.
Sympa Menu

freetds - RE: freetds-0.60 + unixODBC + sqlserver2000 + PHP

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Helio Cavichiolo Jr <hcav AT ig.com.br>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: freetds-0.60 + unixODBC + sqlserver2000 + PHP
  • Date: Wed, 9 Oct 2002 21:30:27 -0300


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);

?>





Archive powered by MHonArc 2.6.24.

Top of Page