freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Problem with SQL Server 2005 Express

From: "Jesse McLen" <jesse_mclen AT hotmail.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] Problem with SQL Server 2005 Express
Date: Thu, 01 Mar 2007 10:28:59 -0600

Hi,

I have setup freetds (tried alll recent versions) with unixodbc on my Suse Linux box. Using protocol 8.0 or 7.0, I can query the database fine using isql.

However, in php (5.1.2) using protocol 7.0, I get an error. Using protocol 8.0 I can see the tables and their fields, but no matter what I do, I can't get any results. Using the odbc_result_all() command, I get NO ROWS.

Using interakt PHP adodb in Dreamweaver, I can actually see the tables and their fields. Nothing I've tried returns any results at all. Again, everything works fine using isql on the linux box.

Thank you for any help you can offer.

_________________________________________________________________
With tax season right around the corner, make sure to follow these few simple tips. http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTips.aspx?icid=HMFebtagline

[freetds] Problem with SQL Server 2005 Express, Jesse McLen, 03/01/2007