[freetds] Freetds,unixODBC,RH Ent Linux

Joel West joel at joelwest.com
Fri Aug 20 17:43:22 EDT 2004


I just made this work. I used DBD::Sybase rather than ODBC.



On Fri, 20 Aug 2004, Walls Rob W Contr 75 CS/SCBS wrote:

> Trying to get RH Ent Linux 3 to talk to MS SQL. I'd like to use PHP to
> script it once it works.
>
> tsql -H [IP] -U [user] -p 1433
> And
> tsql -S TDS -U [user] -p 1433
> Connects to and queries the db just fine after making an entry in
> freetds.conf
>
> I think my problem may be no ODBC driver (.so file). There are many
> lib*odbc*.so files in /usr/lib, but no libtdsodbc.so file.
> So, I tried to compile FreeTDS with
> ./configure --with-tdsver=7.0 --with-unixodbc,
> But many errors occur, apparently because there's no sql.h, sqlext.h or
> odbcinst.h on the system.
>
> So I tried the RPM (v0.62.1-1). I never tried tsql before that, so I don't
> know what would have happened, but it doesn't provide the driver file.
>
> isql doesn't work. Apparently because the system DSN is not correctly set up
> (where's that driver anyway?).
> I used KDE's ODBCConfig GUI thingy to set up the DSN, but don't know what
> driver and setup to use. I tried various combinations of /usr/lib/libtds.so,
> /usr/lib/libtdsS, /usr/lib/libtdssrv.so (which all exist) for the setup and
> driver files, but no luck.
>
> For all I know, unixODBC may be the problem. The freetds docs talk about
> installing the Driver Manager BEFORE trying to compile. I'm not sure what
> that is or where to get it, but I though the ODBCConfig stuff would be the
> driver manager. Anyway, I'm hoping someone here can point me toward the
> answer.
>
>
> Rob Walls
> 75 CS/SCBS
> Hill AFB, UT 84056
> PH (801) 777-2230
> DSN 777-2230
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



More information about the FreeTDS mailing list