When you move to remote connections and want to compile ODBC support into
PHP on a *nix box, you will need a Driver Manager in the mix as well as the
There is a HOWTO on compiling the iODBC Driver Manager with PHP at
Basically, it involves getting the iODBC SDK and
Let me know if you require assistance.
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 7:22 PM
> To: olinux
> Cc: php-db
> Subject: Re: [PHP-DB] testing ODBC + MSSQL connection locally
> > I would like to begin learning ODBC. Will I be able to set this up on my
> > single local machine?
> The ODBC functions are build in when you are running PHP on a
> Windows Box. If you are running on a (nix box you have to compile
> PHP with support for ODBC.
> > Also, What about connecting to MS SQL server remotely? Will i
> simply need an
> > IP Port and user/pass?
> If The MS SQL Server is configured to use TCP/IP you can use this
> to communicate with the server. If the Server uses named pipes
> you can uses this from a Windows box only.
> The MSSQL Server can be accessed using ODBC or the native mssql_*
> functions. You can enable the mssql functions by uncommenting
> ;extension=php_mssql.dll in php.ini. This requires that you are
> running on Windws and you install the client tools from MS SQL
> Server on yor PHP box.
> With ODBC and native MSSQL you can access remote or local databases.
> - Frank
> > Thank you
> > olinux
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]