|
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.
|
