Re: Connect to MS SQL server on diff machine

Just install the client tools from the SQL Server CD (if you have this). Well, I just did this and now I will see if the rest works ... stay tuned .... nicole www.aeontrek.com "Nicole Amashta" <430ntr3k@bellsouth.net> wrote in message news:20020307163248.16222.qmail@pb1.pair.com... > OK, I have Apache and PHP 4.0.6 installed. I want to be able to access an MS > SQL Server, but I don't want to install SQL Server on the web server. What > files are needed in order to do this? > > Normally, I have no problem with this because I typically have MS SQL Server > installed on the web server. > > The only file I know of to put in the system32 root is ntwdblib.dll. But are > there any others? (Aside from enabling the php_mssql.dll). > > I still get the unable to load php_mssql.dll even though the file exists and > the extension_dir path is set to where I keep this extension. > > This works in all cases where I have the SQL Server running on the same > machine as PHP/Apache, etc. So I am guess I am just missing some other files > for this to work. ANyone encounter this scenario and realized how to resolve > this? > > Any help or direction is appreciated! > > TIA, > > -- > Nicole Amashta > Web Applications Developer > www.aeontrek.com > >