[freetds] basic install OK but can't get PHP to work
kenn
kenn at printussery.com
Thu Jul 27 14:16:55 EDT 2006
Lowden, James K wrote:
>> From: kenn
>> Sent: Thursday, July 27, 2006 9:12 AM
>>
>>
>
>> Then I installed php4-odbc but have not been successful connecting
> ...
>> I get the following error:
>>
>> we are trying to connect Warning: odbc_connect(): SQL error:
>> [unixODBC][Driver Manager]Data source name not found, and no default
>> driver specified, SQL state IM002 in SQLConnect in
> /var/www/eve/index.php
>> on line 6 couldn't connect
>
> PHP is using FreeTDS's ODBC driver and the Driver Manager, unixODBC,
> can't find the server. It looks like your odbc.ini isn't correct. If
> so, isql won't work either.
>
> In case it matters, you might not need ODBC. There is a PHP mssql
> extension that works with FreeTDS and does not use ODBC. (It uses
> db-lib.)
I actually don't seem to have an odbc.ini ... I somehow got the idea
that it wasn't essential, so I probably misread something -- will check.
I don't know that I need ODBC -- I just want to achieve read-only access
to an existing mssql database ...
Two questions in that regard: 1. Do you know what packages I would need
to install in order to use db-lib -- I can't seem to find a Debian
package that includes the right stuff.
2. In looking around for it, I did find php4-sybase ... Can that be
used to achieve my goal? Or am I looking at this incorrectly?
Thanks.
kennM
More information about the FreeTDS
mailing list