Skip to Content.
Sympa Menu

freetds - RE: [freetds] Problems getting results from MSSQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Thompson, Bill D (London)" <bill_d_thompson AT ml.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Problems getting results from MSSQL
  • Date: Tue, 2 Dec 2003 15:11:24 -0000

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





Archive powered by MHonArc 2.6.24.

Top of Page