RE: [PHP-DB] testing ODBC + MSSQL connection locally
| From: | Andrew Hill | Date: | Tue, 10 Jul 2001 14:52:46 +0000 |
| Subject: | RE: [PHP-DB] testing ODBC + MSSQL connection locally | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-10214@lists.php.net to get a copy of this message | ||
olinux,
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
ODBC Drivers.
There is a HOWTO on compiling the iODBC Driver Manager with PHP at
www.iodbc.org.
Basically, it involves getting the iODBC SDK and
using --with-iodbc=/path/to/odbcsdk
Let me know if you require assistance.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Frank M. Kromann [mailto:frank@frontbase.com]
> Sent: Monday, July 09, 2001 7:22 PM
> To: olinux
> Cc: php-db
> Subject: Re: [PHP-DB] testing ODBC + MSSQL connection locally
>
>
> Hi,
>
> > 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: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>