Skip to Content.
Sympa Menu

freetds - Re: 0.53 and PHP 4.2.1 not returning results

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Jason Lane" <kbdrand AT hotmail.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: 0.53 and PHP 4.2.1 not returning results
  • Date: Thu, 11 Jul 2002 18:17:39 -0500


I did get it to work. The Query I was using was "SELECT * FROM
aradmin.shr_location". When I did a "SELECT count(*) FROM
aradmin.shr_location" it worked fine. I guess it has something to do
with the types of columns it was trying to return.

Right now I'm just doing some total reporting so it's mainly count
statements but eventually I might have to figure out why I was getting
that error.


-----Original Message-----
From: bounce-freetds-144831 AT franklin.oit.unc.edu
[mailto:bounce-freetds-144831 AT franklin.oit.unc.edu] On Behalf Of Brian
Bruns
Sent: Thursday, July 11, 2002 10:52 AM
To: TDS Development Group
Subject: [freetds] Re: 0.53 and PHP 4.2.1 not returning results

Please post the script you're using including the SQL query. I'm
assuming
you've tried a simple query like "select @@version" and it fails too?
Also, you may wish to create a cgi version of PHP and do testing using
that from the command line instead of going through apache. If you do
that you can set the TDSDUMP environment variable and get a trace of
what's going on.

Brian

> I'm running Apache 2.0.36 with PHP 4.2.1 and FreeTDS 0.53. I am
connecting
> to a MS SQL 7.0 server and the connection works fine. I can connect,
and I
> can use mssql_select_db to pick my database, but once I try and run a
> query it just stops the script execution. I never get any values
returned.
> I've compiled FreeTDS with the 7.0 version, and I'm putting the
> Environment Variables in my PHP script with ver 7.0 as well.
> I would love to view the documentation on freetds.org but every time I
try
> to access that information it throws up a 'You are not authorized
> message.'.
>
> I've had the MS DBA take a look at hte logs from my query and the
query is
> actually returning to my box, but I guess FreeTDS is not returning the
> data for some reason.
>
> Please help! My next step will be to move this code over to a Windows
box,
> which I would like to avoid if at all possible.

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




Archive powered by MHonArc 2.6.24.

Top of Page