FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

If you run a sp_help on the table that will give you the column 
definitions, we could check that for what might be at fault.

Brian

On Thu, 11 Jul 2002, Jason Lane wrote:

>           
> X-UID: 6380
> 
> 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')
> 
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to leave-freetds-1229