1,105,546 Community Members

Move from mssql to sqlsrv driver on PHP

Member Avatar
Misheki
Newbie Poster
8 posts since Mar 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

I have a PHP shopping cart system and it's using MS SQL for the backend. Currently it's using the mssql driver. Now I want to move it to Windows Azure and I'm required to change the driver to sqlsrv 2 in order for it to work there.

Can anybody tell me if I really need to change the way my db queries are written or can I just retain them and will still work under the new sqlsrv driver?

Example: mssql_connect() -- current syntax which ideally should be sqlsrv_connect() under sqlsrv driver, but will it still work as is?

Thanks in advance! :)

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

Here is an example of how it should look. The connect is different, and as far as I see the query parameters are reversed.

Member Avatar
Misheki
Newbie Poster
8 posts since Mar 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 0 [?]
 
0
 

Thanks Pritaeas!

I think this means I have to change the way my queries are written. Sounds like a lot of work. :P

Question Answered as of 2 Years Ago by pritaeas
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: