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: "Castellano, Nicholas" <Nicholas_Castellano AT acml.com>
  • To: "'TDS Development Group'" <freetds AT franklin.metalab.unc.edu>
  • Subject: RE: freetds-0.60 + unixODBC + sqlserver2000 + PHP
  • Date: Mon, 14 Oct 2002 17:10:56 -0400


So...the first link you provided seems to work...the second one
doesn't...what's the difference between the two?

Cheers,
--nick

-----Original Message-----
From: bounce-freetds-145195 AT franklin.oit.unc.edu
[mailto:bounce-freetds-145195 AT franklin.oit.unc.edu]
Sent: Monday, October 14, 2002 3:04 PM
To: TDS Development Group
Subject: [freetds] RE: freetds-0.60 + unixODBC + sqlserver2000 + PHP


Can you send me the options you use to compile php and apache? Perhaps the
problem can be there.

The entire script is this:

<?

echo "Conectando...<br>\n";
$connect = odbc_connect("APIS", "sa", "********");
echo "Executando a query...<br>\n";
$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);
echo "Fim\n";

?>

This script can be run from these URLs:

http://200.182.158.3/cgi-bin/teste.php
and
http://200.182.158.3/teste.php


Em Seg 14 Out 2002 17:43, you wrote:
> Uhhhhhhmmm, well, "it works for me".
>
> That is, I just installed apache-1.3.27, php-4.1.2, ap-php-4.1.2, and
> php-odbc-4.1.2. I was able to write a simple select query and execute
> it, get results back, and format them in a table. This was with an
> unpatched current FreeTDS from CVS.
>
> So, what's different in your environment? Can you post the rest of
> your php script (remove any passwords of course)?
>
> [I see that freddy77 just committed another fix for odbc...I just
> updated my FreeTDS source, rebuilt, and reinstalled, and made sure it
> still works...with or without his most recent change]
>
> Anyway, I attached the php script that I scraped together based on a
> couple of examples from http://www.php.net/ ... perhaps it will give a
> clue as to what's going wrong in your script?
>
> Cheers,
> --nick
>
> -----Original Message-----
> From: bounce-freetds-145195 AT franklin.oit.unc.edu
> [mailto:bounce-freetds-145195 AT franklin.oit.unc.edu]
> Sent: Monday, October 14, 2002 12:59 PM
> To: TDS Development Group
> Subject: [freetds] RE: freetds-0.60 + unixODBC + sqlserver2000 + PHP
>
>
> Nothing changed. I still got the same message:
>
> Warning: SQL error: [unixODBC]Statement option not implemented, SQL
> state 08001 in SQLSetStmtOption in /var/www/htdocs/teste.php on line 7
>
> Lines 6 and 7 are:
>
> $query = "select nome from transportador";
> $result = odbc_exec($connect, $query);
>
> Helio
>
> Em Seg 14 Out 2002 15:10, you wrote:
> > So we probably need the SQLGetInfo() call to return a code
> > indicating that we don't support ExtendedFetch. Can you try this
> > patch and let me know if it makes any difference?
> >
> > Cheers,
> > --nick
> >
> > -----Original Message-----
> > From: bounce-freetds-145195 AT franklin.oit.unc.edu
> > [mailto:bounce-freetds-145195 AT franklin.oit.unc.edu]
> > Sent: Monday, October 14, 2002 12:05 PM
> > To: TDS Development Group
> > Subject: [freetds] RE: freetds-0.60 + unixODBC + sqlserver2000 + PHP
> >
> > Lowden, James K wrote:
> > >>From: Helio Cavichiolo Jr [mailto:hcav AT terra.com.br]
> > >>Sent: October 14, 2002 9:22 AM
> > >>
> > >>As you can see here, in the PHP function call:
> > >>
> > >>#ifdef HAVE_SQL_EXTENDED_FETCH
> > >
> > > ^^^^^^^^^ This should be undefined, no?
> > >
> > >>/* Solid doesn't have ExtendedFetch, if DriverManager is used, get
> > >>Info,
> > >> whether Driver supports ExtendedFetch */
> > >> rc = SQLGetInfo(conn->hdbc, SQL_FETCH_DIRECTION, (void *),
> > >>srollopts, sizeof(scrollopts), NULL);
> > >
> > > FreeTDS's ODBC library doesn't support ExtendedFetch. Why would
> > > HAVE_SQL_EXTENDED_FETCH be defined? I would expect this code not
> > > to be compiled (#ifdef tests FALSE).
> >
> > Not if it is compiled against a driver manager. PHP has a lot of
> > stuff like this for direct linking against drivers.
>
> ---
> You are currently subscribed to freetds as:
> [Nicholas_Castellano AT acml.com] To unsubscribe, forward this message to
> $subst('Email.Unsub')
>
>
> The information contained in this transmission may contain privileged
> and confidential information and is intended only for the use of the
> person(s) named above. If you are not the intended recipient, or an
> employee or agent responsible for delivering this message to the
> intended recipient, any review, dissemination, distribution or
> duplication of this communication is strictly prohibited. If you are
> not the intended recipient, please contact the sender immediately by
> reply e-mail and destroy all copies of the original message. Please
> note that for certain accounts we do not accept orders and/or
> instructions by e-mail, and for those accounts we will not be
> responsible for carrying out such orders and/or instructions. Kindly
> refrain from sending orders or instructions by e-mail unless you have
> confirmed that we accept such communications for your account. Please
> also note that to satisfy regulatory requirements we review the
> outgoing and incoming e-mail correspondence of staff members serving
> certain functions.


---
You are currently subscribed to freetds as: [Nicholas_Castellano AT acml.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that for certain accounts we do not accept
orders and/or instructions by e-mail, and for those accounts we will not be
responsible for carrying out such orders and/or instructions. Kindly refrain
from sending orders or instructions by e-mail unless you have confirmed that
we accept such communications for your account. Please also note that to
satisfy regulatory requirements we review the outgoing and incoming e-mail
correspondence of staff members serving certain functions.






Archive powered by MHonArc 2.6.24.

Top of Page