Skip to Content.
Sympa Menu

freetds - [freetds] Are these errors related to FreeTDS/UnixODBD? Please help.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: David Vaughan <dvaughan AT am-a.com>
  • To: "'freetds AT lists.ibiblio.org'" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Are these errors related to FreeTDS/UnixODBD? Please help.
  • Date: Wed, 6 Apr 2005 13:53:21 -0700

I apologize in advance for the length of this post....

We are transitioning over to a new webserver (from Mandrake to Fedora 2). I
have everything installed on the Fedora to pull data from MSSQL 7. I have
installed UnixODBC(v 2.2.8), FreeTDS (v 0.62.4-1), and the FreeTDS-UnixODBC
support package (v 0.62.4-2mdk.i586.rpm). I used the "mdk" version of the
freetds-unixodbc package b/c it was the only one I could find compatible
with my FreeTDS version. Anyway, it appeared to work as data is being into
the website, just like it was on the old server. However I am also getting
errors when it trys to pull some of the data. ALL these queries work
perfectly fine and are currently in production on the old server. I even
retested them by inserting them in Query Analyzer and isql. No problems, so
I am positive there is nothing wrong with the queries, but it is something
else. Here are some examples of errors, AND you will see data being pulled
in just fine under "Agreement Date" and "Renewal Date" using similiar SQL
queries.

Warning: odbc_exec(): SQL error: ? ? ???QL state 00000 in SQLExecDirect in
/var/www/html/.php/mssql.php on line 69

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result
resource in /var/www/html/.php/mssql.php on line 71
Agreement Date: 1998-10-01

Renewal Date: 2005-07-01
Primary Investment Consultant:
Warning: odbc_result(): supplied argument is not a valid ODBC result
resource in /var/www/html/protected/accounts/acct_information.phtml on line
215

So, has ANYONE seen anything like this before? Really puzzling me. If the
queries are accurate (and they 100% are), how is it some are working and
pulling in data while others are not? My only concern was that I used that
"mdk" version as I mentioned above. I am considering reverting back to an
older stable version of FreeTDS, one that comes with a supported
freetds-unixodbc package. I see on the freetds site these two:

-freetds-0.62.1-1.i586.rpm
-freetds-unixodbc-0.62.1-1.i586.rpm

Any thoughts? I'm going nuts.





========================================================================

This message is intended only for the designated recipient(s). It may
contain confidential, privileged or proprietary information. If you are not
a designated recipient, you may not review, modify, copy or distribute this
message or its contents. If you receive this message in error, please
notify the sender by reply e-mail and delete this message.

Thank you.

========================================================================



  • [freetds] Are these errors related to FreeTDS/UnixODBD? Please help., David Vaughan, 04/06/2005

Archive powered by MHonArc 2.6.24.

Top of Page