PHP + SQL SERV2005

[emetib]

My OS is ...

Win XP Pro w/IIS 5.1

 

Have both MySQL and SQL Sev2005 Developer installed and they are working fine.

 

Are there any tips/links to read for PHP to work with mysql and sql serv2005?

 

 

Read ...

 

http://msdn.microsoft.com/en-us/library/bb264561.aspx

 

http://www.esmondtech.com/?p=54

 

 

Ready to install php and have a few questions now.

 

 

Does it matter if Windows Script 5.6 is installed before or after PHP 5.2.5 installer?

 

HOW/WHERE do I Add C:/PHP, the directory in which PHP 5 is installed, to the PATH System environment variable. OR how do I confirm it is already set?

 

Is this done from cmd?

 

???

[roopurt18]

I don't have a windows machine in front of me, but I recall setting the PATH variable by doing the following:

 

1. Right-click 'My Computer' and select properties.  This opens a windows with tabs...

 

2.  One of the tabs (forget which) will have a button labeled 'Environment' I think.

 

3.  Clicking that button will open up a screen where you can set environment variables, one of which will be PATH.

 

#2 and #3 might be iffy, but I know you configure the path somewhere in the screen that comes from 'My Computer' -> Properties.

 

You might also try start -> run -> msconfig.

 

There are various ways you can connect to MS SQL:

a. PHP's mssql_*() functions.

b. PDO

c. ODBTP (Google it, also works wonders with FoxPro)

[emetib]

Thanks for that tip about environment variables :>

 

I may have some questions so I'll let you know. Googelin it now that I have a clue!

 

Didn't see any posts about making this PHP - MS SQL 2005 work and believe it is very useful information.

 

Some of us are geeks and others are gurus!

 

cheers,

emebit