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

Salve, I can't think that the .html extension would cause this behavior, but it might cause your app to slow down a bit if it's lot lots of non-php code on the .html pages on the server. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server -----Original Message----- From: Salve Tinkerworth [mailto:tinkerworth@hotmail.com] Sent: Friday, July 26, 2002 10:46 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] What MDAC version for MSSQL? Query Analyzer Thanks Andrew, I'll give it a try. I have users using the code right now. It works for a while then it will bomb. If I make a change to the script (using interdev) and re-save it, it miracuously starts working again. Very strange. I'm not actually changing anything just re-saving the file. One other thing funky, which I vehemently complaigned about, is that this app uses the .html extension instead of .php for all it's files. From what I've read this is not recommended. Do you think that would cause any of this strange behaviour? Salve "Andrew Hill" <ahill@openlinksw.com> wrote in message news:033e01c234b6$d1f3e730$eb0ba8c0@usnet.private... > 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php