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: Brian Bruns <camber AT ais.org>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: 0.53 and PHP 4.2.1 not returning results
  • Date: Thu, 11 Jul 2002 20:24:11 -0400 (EDT)


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





Archive powered by MHonArc 2.6.24.

Top of Page