FreeTDS Development Group

["Jason Lane" <kbdrand AT hotmail.com>]

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