Eric
|
Posted: 02/17/2004, 8:25 AM |
|
Any advantages of using either the ODBC or the MSSQL drivers in PHP 4 to link to MS SQL 2000?
Thanks for any comments,
Eric
|
|
|
EMG
Posts: 35
|
Posted: 02/20/2004, 3:16 PM |
|
I have used the ODBC with M$$QL for a few years now with no problems. I like not having to install any extra extensions if I don't have to, especially since I am not the sys admin on my production web servers.
|
|
|
DonB
|
Posted: 02/21/2004, 7:11 AM |
|
The MSSQL Driver: There is more functionality available (MS SQL specific
features) and also Microsoft claims they are optimized for MS SQL in terms
of performance by reducing the overhead (you can find out more about this by
searching msdn.microsoft.com for DB Library) . The short explanation is that
ODBC driver is designed to cover all the database "bases" and the MS SQL
driver is designed to work with one in particular, so the latter one should
be better when performance is an issue.
In practice, I can't say I've seen any difference. A side note: When I
have the choice of using ODBC or ADO, I stick with ADO. I run into fewer
glitches and ADO has some nice features like being XML-aware, persistent
result sets, and being able to work with datasources that don't happen to be
a traditional relational database.
--
DonB
http://www.gotodon.com/ccbth
"Eric" <Eric@forum.codecharge> wrote in message
news:54032406043940@news.codecharge.com...
> Any advantages of using either the ODBC or the MSSQL drivers in PHP 4 to
link to MS SQL 2000?
>
> Thanks for any comments,
>
> Eric
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|