Re: Connect to MS SQL server on diff machine

Thanks. I think I may just have needed to install the Client Tools from the SQL Server CD (and exclude the database server). Hope this works, I'll let y'all know. nicole www.aeontrek.com "Ray Hunter" <rhunter@enterasys.com> wrote in message news:59358A738F45D51186A30008C74CE250E8148A@slc-exc1.ctron.com... > You have to make sure that php loads that module, if it does not then you > cannot connect to the database... > > If you can get the dbx module to load you might be able to use the dbx mssql > connection. However, I am not 100% sure if that will work, because it will > probably use the php_mssql.dll to access the database. > > Try it and see... > > > > Thank you, > > Ray Hunter > Firmware Engineer > > ENTERASYS NETWORKS > > > -----Original Message----- > From: Nicole Amashta [mailto:430ntr3k@bellsouth.net] > Sent: Thursday, March 07, 2002 9:34 AM > To: php-windows@lists.php.net > Subject: [PHP-WIN] Connect to MS SQL server on diff machine > > > 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 > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >