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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > 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