FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

MS SQL does not understand the TDS 5.0 protocol (the default) so you must
configure it to use either 4.2 or 7.0 (for MS SQL 7).  The 7.0 support is
pretty new and since I no longer have access to a MS SQL dataserver, I'm
not sure how well I'll be able to help people who have problems with it.
So, I would recommend using 4.2 anyway.  The configure flag is

./configure --with-tdsver=4.2

I've heard reports of problems with php4b3 that have since been fixed in
the CVS versions, although I don't know specifics.

Brian

On Wed, 22 Dec 1999, Francis Smit wrote:

> Hi,
>     I've tried on and off to get freeTDS to run in PHP
> connecting to a MSSQL Server 7.0 DB,  and failed,
> is there a rpm available?
> If not could could some one tell me exact ./configure
> command lines that have worked?, I'm building PHP4.0b3
> as an apache module on Red Hat Linux 6.1.
> 
> Thanks for any help.
> 
> p.s. I did once get it to work going to a sybase db
> across the web, but I need to hook up to a NT server
> with MSSQL server, also am I only supposed to put
> software on the linux box, or is there something I need to
> do on the NT end as well??
> 
> Andreas Tille wrote:
> 
> > Hello,
> >
> > when I announced to build a Debian-Package from FreeTDS-JDBC I was
> > asked to do it with FreeTDS as well.  No I'll possibly use it
> > myself and I'm considering to package it.
> >
> > Now I have some questions:
> >
> > 1) What is the purpose of the file
> >
> >      /usr/interfaces
> >
> >    I tried to check the sources but didn't found a place, where it
> >    is really needed.
> >    The reason for this is that it conflicts with the Debian policy
> >    for placing files.  If it is really needed it should go anywhere
> >    under /usr/share (because it is a plain ASCII-file and so it
> >    is architecture independent).  I'd like to suggest to place it
> >    in
> >      /usr/share/freetds/interfaces
> >    and I'd like to know, if this change would require any changes to
> >    the source.
> >    May be you could think about such kind of location for your
> >    distribution or you could make the location configurable at
> >    compile time.
> >
> > 2) *How* usable is the ODBC driver.  While reading the README file,
> >    I wonder if this should/could go into a Debian package.  However,
> >    ODBC would be the real clue in the FreeTDS package.
> >
> > 3) I was not able to run the samples from the samples dircetory.
> >    It would be really helpfull for me if someone could give me a
> >    hint, what to fill into the connection data.  I run FreeTDS-JDBC
> >    successfully and perhaps somebody could tell me what I have to
> >    write in the configuration section of the three examples, if
> >    I could successfully access my database with the following
> >    JDBC-connection:
> >
> >        Class.forName("com.internetcds.jdbc.tds.Driver");
> >        Class.forName("com.internetcds.jdbc.tds.SybaseDriver");
> >
> >        String url      = "jdbc:freetds://sql03/db";
> >        String user     = "TestUser" ;
> >        String password = "password";
> >
> >        Connection cx  = DriverManager.getConnection(url, user, password);
> >
> >    I have certain problems with the items I have to fill in the
> >    C files.
> >
> > Kind regards
> >
> >         Andreas.
> 
> --
> 
>                                            Grisly    . oo
>                                                       `oO
> Francis Smit
> 
> 
> Knowledge By Design/OzTel
> Suite 201, 683 George st
> Sydney 2000 NSW
> 
> mailto:francis AT kbd.com.au
> 
> Tel: +61 2 9212 1399
> Fax: +61 2 9212 5727
> ___________________________________
> m$: How can we stuff you up today?
> 
>