Posted by Erwin Moller on 08/23/05 15:49

Hi group,

I am probably going to develop a webapp for some company.
They want SQL Server as database, which is fine with me.
They have W$ machines for webserver (IIS5 I expect)
Their first choice for scriptinglanguage was VBscript/ASP and allthough I
can do that, I prefer coding in PHP, so maybe I can talk them over to PHP.
:-)

Now before I really screw up: Are there any issues with SQLServer as
database and PHP as language?
If I am going to enter a minefield, I'll just stick with VBscript. :-(


I found two approaches: MSSQL 'direct' and ODBC.

Direct connect (using ntwdblib.dll):
http://nl2.php.net/manual/en/ref.mssql.php

and odbc:
http://nl2.php.net/manual/en/faq.databases.php#faq.databases.mssql

Most comments on php.net do not make it sound very easy to set up a direct
connection using ntwdblib.dll.
(dll versions, service packs, etc, and more things I cannot control.)

Is it wiser to set up a DSN and ODBC maybe?

I won't be doing a lot of funky stuff, no transactions, cursors, and such I
expect...

Does anybody have any advise?
Certain things I should pay extra attention to?


Thanks for your time!

Regards,
Erwin Moller

• Next in forum: Re: Postponing execution time out
• Prev in forum: Problem of sorting table
• Thread view: PHP on W$/IIS communicating with remote W$ SQL Server.

[Reply to this message]