0.53 and PHP 4.2.1 not returning results

Jason Lane kbdrand at hotmail.com
Fri Jul 12 18:29:24 EDT 2002


Sorry, I was out today. I'll try and run that on Monday.

-----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 6:24 PM
To: TDS Development Group
Subject: [freetds] Re: 0.53 and PHP 4.2.1 not returning results

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


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



More information about the FreeTDS mailing list