RE: [PHP-DB] What MDAC version for MSSQL?

Salve, What is QA? Also, I strongly suggest you turn on tracing in the ODBC Administrator while debugging this - it might catch something. You can also try installing one of our trial MS SQL Server drivers (Single Tier) as this may provide better error messages. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server office 781.273.0900 x 27 mobile 781.608.4127 -----Original Message----- From: Salve Tinkerworth [mailto:tinkerworth@hotmail.com] Sent: Thursday, July 25, 2002 9:20 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] What MDAC version for MSSQL? Oh yeah, I should mention that anytime I echo the the SQL statement before it runs and copy it into QA; it parses and runs without any error. "Andrew Hill" <ahill@openlinksw.com> wrote in message news:49260.206.148.108.250.1027648932.squirrel@mail2.openlinksw.com... > Salve, > > Not sure if the MDAC version is necessarily the culprit - it's probably > something else. > What do you have earlier in your script? Are you catching errors on the > connect? > > Best regards, > Andrew Hill > OpenLink Software > > > > Is there a recommended MDAC version for PHP when accessing SQL Server > > 2000? Right now the following statement successfully inserts data but > > always results with the die message: > > > > $result = mssql_query($sql1) or die('inserting campaign failed'); > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php