[freetds] Simple queries failing

Ken Tozier kentozier at comcast.net
Fri Sep 1 12:48:52 EDT 2006


Thanks for replying.

I figured out what the problem was. Turns out it was PHP related not  
FreeTDS.

Ken

On Sep 1, 2006, at 12:32 AM, jklowden at schemamania.org wrote:

> On Thu, Aug 31, 2006 at 03:56:36PM +0000, kentozier at comcast.net wrote:
>> Hi
>>
>> I developed an application with MySQL and am now in the process of  
>> translating the queries to work with MSSQL but am having a  
>> terrible time trying to get even the simplest queries to work with  
>> freetds. For example, the following query works in MySQL (and even  
>> works with MSSQL if I use Aqua Data Studio) but fails when run  
>> through freetds
> ...
>> Are there some environment variables that would block such simple  
>> queries from working in freetds?
>
> Please provide more information.  Best would be a TDSDUMP log of your
> results.
>
> *All* queries work in FreeTDS, insofar as the library merely  
> communicates your
> query to the server and its results back to you.
>
> Make sure you're actually connecting.  Try your qeury with tsql,  
> then look at
> your result processing loop.
>
> HTH.
>
> --jkl
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds




More information about the FreeTDS mailing list