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:[EMAIL PROTECTED]]
> 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: [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]
