Re: What MDAC version for MSSQL?
| From: | Salve Tinkerworth | Date: | Fri, 26 Jul 2002 15:46:16 +0000 |
| Subject: | Re: What MDAC version for MSSQL? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20820@lists.php.net to get a copy of this message | ||
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
>
> V8&Lnews: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
>
>