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 scriptinglangua ge 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):
and odbc:
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
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 scriptinglangua ge 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):
and odbc:
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