FreeTDS Development Group

["Andersen, Al" <AndersenA AT HQISEC.ARMY.MIL>]

I've got a problem with using FreeTDS on my Linux server with unixODBC and
Apache/PHP. From my Linux box, I can make connections to my MSSQL 7.0
database on the NT server, and I can also retrieve data OK with ISQL. The
problem is that I can't retrieve TEXT data using Apache/PHP.

I'm familiar with this problem using Apache/PHP/ODBC on an NT 4.0 web
server. You have to set some PHP.INI variables to do things right. However,
on my Linux box, no matter what variables I set, unixODBC/TDS keeps bombing
out on me when I try to retrieve TEXT data, regardless whether it contains
apostrophe's or not. I don't have this problem with unixODBC/ODBC-Bridge
(well, at least not with *getting* the data).

Does anyone else have this problem? If not, could someone give me some
pointers as to what I might be doing wrong?

FreeTDS v0.53
PHP v4.1.1
unixODBC v2.1.1
Apache v1.3.22
SuSE v7.3 Professional

Here's the pertinent PHP.INI info:

magic_quotes_gpc     = Off #MSSQL
magic_quotes_runtime = On  #MSSQL
magic_quotes_sybase  = On  #MSSQL
odbc.defaultlrl      = 131072 #128K

Here's how I make my connection/call to the MSSQL database from Linux
Apache/PHP:

  $odbc_db     = "ists";         # SQL Server database name
  $odbc_dsn    = "isec_sts";     # SYSTEM DSN name (unixODBC)
  $odbc_server = "isec_cis_dev"; # SQL Server name (symbolic)
  $odbc_pwd    = "xxxxxxxxxx";   # SQL Server password
  $odbc_uid    = "xxxxx";        # SQL Server user id

$odbc_connect_string =
"DSN=$odbc_dsn;Servername=$odbc_server;Database=$odbc_db;UID=$odbc_uid;PWD=$
odbc_pwd";

(I *must* use SQL_CUR_USE_ODBC. Otherwise strange things happen)

$connection = odbc_connect ($odbc_connect_string, "", "", SQL_CUR_USE_ODBC)
or die ("Can not connect to $odbc_dsn.");

(Call a stored procedure on the MSSQL server, with appropriate parameters)

$sql = "EXEC ISTSLoadRecord $p_id_user, " . "'" . $s_id_suspense . "'";

$resultset = odbc_exec ($connection, $sql) or die ("Can not perform query");

# The first 3 lines are sample non-text data (bit, date, varchar). They
work.
# The last 2 lines are text data. They bomb.

if (odbc_fetch_row ($resultset))
{
  $is_from = odbc_result ($resultset, "f_is_from");
  $s_date_created  = substr (odbc_result ($resultset, "f_date_created"), 0,
10);
  $s_subject       = odbc_result ($resultset, "f_subject");
  $s_comment       = odbc_result ($resultset, "f_comment");
  $s_description   = odbc_result ($resultset, "f_description");
}

Here's the error messages:

Warning: SQL error: [unixODBC][Driver Manager]Option value changed, SQL
state 01S02 in SQLGetData in /xxx/apache/html/edit.php on line 190

Warning: SQL error: [unixODBC][Driver Manager]Driver can not bind
parameters, SQL state S1000 in SQLGetData in /home/apache/html/edit.php on
line 191

The same code, using an ODBC-Bridge DSN (and no SQL cursor parameter in the
connect call), retrieves the text data OK.

Any ideas?

-Al Andersen