FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Our Pleasure!

> -----Original Message-----
> From: Quique Luna [SMTP:e-luna1 AT ti.com]
> Sent: 02 December 2003 15:16
> To:   FreeTDS Development Group
> Subject:      RE: [freetds] Problems getting results from MSSQL
> 
> Sorry, I found the problem... in my freetds.conf file instead of writing
> version I wrote verspn that is why it was not working...
> 
> Thank you very much for your help!
> 
> 
> -----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:41 AM
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] Problems getting results from MSSQL
> 
> 
> Hi,
> 
> Nothing strange there....
> 
> couple of questions.
> 
> what is the TDS version you're using to connect to the server ?
> you should have an entry like this in freetds.conf
> 
> 
> [MYSERVER]
>     host = 123.456.78.45
>     port = 3001
>     tds version = 7.0
> 
> tds version should be 7.0 for SQL server 7 and  7.0 or 8.0 for SQL server
> 2000
> 
> 
> You did leave it a few seconds to complete before killing ?
> 
> Bill
> 
> 
> > -----Original Message-----
> > From:       Quique Luna [SMTP:e-luna1 AT ti.com]
> > Sent:       02 December 2003 14:34
> > To: FreeTDS Development Group
> > Subject:    RE: [freetds] Problems getting results from MSSQL
> >
> >
> > 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 << File: tdsdump.dat
> >>
> > << File: ATT110892.txt >>
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds