Re: [opensuse] Adding php-mssql shared object to opensuse 10.3 to use freetds





Sloan wrote:
Moby wrote:
While this is not exactly what you asked for, we use php to connect to
MS SQL Servers on OpenSuse 10.3 via unixODBC.

PHP uses ODBC through unixODBC, unixODBC then uses the FreeTDS ODBC
drivers to connect to SQL. Works like a charm.

That's interesting - we didn't have any luck with that, couldn't ever
get the freetds drivers to connect successfully to the pc sql server and
ended up going with the easysoft odbc drivers, which worked like a charm
out of the box.

Does the pc sql server have to be operated in some sort of compatibility
mode or something, to allow interoperability with the freetds drivers?
I'm curious if we might have missed something.

Joe

No - we are using freetds-unixodbc version 0.63-1 - works like a charm out of the box. It's odbc driver is libtdsodbc.so and we are connecting to SQL Server 2000 and 2005 without any issues.


--
--Moby

They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety. -- Benjamin Franklin


--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx



Relevant Pages

  • Re: End-user software to query a warehouse?
    ... > worked, using ODBC, but now I'm battling a slightly different battle, with ... It really sucks that "ordinary" ODBC client ... applications can query the DB2 no problems, but when SQL Server ... with the API functions it uses to talk to IBM's drivers. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: [opensuse] Adding php-mssql shared object to opensuse 10.3 to use freetds
    ... PHP uses ODBC through unixODBC, unixODBC then uses the FreeTDS ODBC ... drivers to connect to SQL. ... Does the pc sql server have to be operated in some sort of compatibility ...
    (SuSE)
  • RE: Connecting to SQL Server
    ... It contains the latest ODBC. ... also integrated with the Windows XP Service Pack 1. ... require the use of older versions of the sqlsrv32.dll drivers. ... It is possible to set up and use alternative ODBC SQL Server data sources, ...
    (microsoft.public.windowsxp.security_admin)
  • ODBC Excel - SQL 2000 has but not 2005?
    ... I have a machine with SQL Server 2000 loaded and I have the ODBC ... drivers for Excel listed in the ODBC. ...
    (comp.databases.ms-sqlserver)
  • SQL Server ODBC Driver Ignores Authentication Setting
    ... set their ODBC connections with SQL Server Authentication, ... Microsoft Data Access Components 2.6 RTM, ... authentication to log into the database. ...
    (microsoft.public.sqlserver.security)