[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