freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Quique Luna" <e-luna1 AT ti.com>
- To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: RE: [freetds] Problems getting results from MSSQL
- Date: Tue, 2 Dec 2003 08:33:39 -0600
This is my file...
Thank you for helping me...
-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of Thompson, Bill D
(London)
Sent: Tuesday, December 02, 2003 8:12 AM
To: 'FreeTDS Development Group'
Subject: RE: [freetds] Problems getting results from MSSQL
Hi Quique,
Your best bet (and you'll find us suggesting this to many people who have
strange problems when they first start up with FreeTDS),
is to generate a "TDSDUMP"
You can do this by setting the environment variable TDSDUMP to a filename,
e.g :
setenv TDSDUMP mydumpfile.dat
or
export TDSDUMP=mydumpfile.dat
Then when you rerun your test, you should find a log of everything that
freeTDS has done.
I guess you'll need to kill your test at some point. Leave this a little
longer than you might normally, as the TDSDUMP logging slows down freetds
quite a bit...
Then post us the file, if you can.
regards,
Bill
> -----Original Message-----
> From: Quique Luna [SMTP:e-luna1 AT ti.com]
> Sent: 02 December 2003 13:53
> To: freetds AT lists.ibiblio.org
> Subject: [freetds] Problems getting results from MSSQL
>
> Hi,
>
> I have RH 7.0 FreeTDS 0.61, Apache 1.3 and PHP 4.3.
>
> It seems that the installation was OK, I made a small script to test the
> connectivity to MSSQL and it worked
>
> <?PHP
> $db_conn = mssql_connect("myserver","myuser","mypassword") or die ("Could
> not Connect to the Database...");
> print "Connected...";
>
> mssql_select_db("db",$db_conn) or die("Could not select database...");
> print "Database selected...";
>
> mssql_close($db_conn);
> print "Closing...";
>
> ?>
>
>
> It works, but when I add the mssql_query($sql) it seems to be running for
> an
> infinite time... please help! << File: ATT510686.txt >>
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Attachment:
tdsdump.dat
Description: Binary data
-
[freetds] Problems getting results from MSSQL,
Quique Luna, 12/02/2003
- <Possible follow-up(s)>
-
RE: [freetds] Problems getting results from MSSQL,
Thompson, Bill D (London), 12/02/2003
- RE: [freetds] Problems getting results from MSSQL, Quique Luna, 12/02/2003
-
RE: [freetds] Problems getting results from MSSQL,
Thompson, Bill D (London), 12/02/2003
- RE: [freetds] Problems getting results from MSSQL, Quique Luna, 12/02/2003
- RE: [freetds] Problems getting results from MSSQL, Thompson, Bill D (London), 12/02/2003
- RE: [freetds] Problems getting results from MSSQL, Lowden, James K, 12/02/2003
Archive powered by MHonArc 2.6.24.