Skip to Content.
Sympa Menu

freetds - Re: MSSQL Queries not working?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Richard Rowell <richard AT bowmansystems.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: MSSQL Queries not working?
  • Date: Wed, 9 Jan 2002 13:57:22 -0600


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.




Archive powered by MHonArc 2.6.24.

Top of Page