Interesting problem here, hopefully someone else has come across this b/c I'm stuck. We are moving webservers from an older Mandrake box to Fedora Core 2. Our website pulls in MSSQL 7 data using basic SQL queries. The queries work perfectly fine, as the current webserver utilizes them without error and is doing so right now. However, now I'm trying to duplicate this same success on the new Fedora box and running into problems.
When I login to our website as a client some of the data is being displayed as it should, but then other pages are not displaying the data and instead giving me errors like this:
Warning: odbc_exec(): SQL error: ؘ¯ãXø¥?𾥺¨¬ SQL state 00000 in SQLExecDirect in <path>/mssql.php on line 69
Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in <path>/mssql.php on line 71
My question is how can some of this data be pulled in without error and other data not. Again, keeping in mind I know all these queries work perfectly fine. I even reran them in Query Analyzer to confirm. I'm very lost on this one.
Thanks in advance lads and gents. Any insight is appreciated.
