FreeTDS Development Group

[Richard Rowell <richard AT bowmansystems.com>]

On Wednesday 09 January 2002 13:02, you wrote:
> Hi,
>
> I have Freetds 0.53 connecting to a MSSQL 2000 box...
> I can't seem to pull information out of the database. I can insert, but not
> pull data out.
>
> Am I using the wrong code? Here is the code that is not working. It seems
> to be failing on the $result line since when I comment that line out, I at
> least get an error. If that line isn't commented then all I get is "Page
> cannot be displayed".
>
> Any Ideas or suggestions?
>
> mssql_connect(DB_HOST, DB_USER, DB_PW) or DIE("Error: Server failed to
> respond.");
> mssql_select_db(DB_NAME) or DIE("Error: Could not connect to table.");
> $query = "SELECT * FROM test where id = '$id'";
> $result = MSSQL_QUERY($query) or DIE("Error: Could not handle Query.");
> $r = MSSQL_FETCH_ARRAY($result) or DIE("Error: Could not process result.");
>       $data = $r["data"];

We had similar problems before with an older version of freetds 
(specifically, we could do selects fine till we did and update/insert then 
selects returned empty sets from that point forward) We got it to work fine 
with PHP4.1/Freetds .52/Linux 2.4.16 connecting to both SQL Server 7 & 2000 
databases however.