To use ODBC from PHP/Linux to a Win32/MSSQL server you will need to link an
ODBC Driver Manager into your PHP build.
There is a complete HOWTO on this at: www.iodbc.org, where you will also
find the open source iODBC Driver Manager.
Fabrizio is correct, however - you will need to alter your mssql_functions
to odbc_functions.
Many of the ODBC functions directly parallel the mssql ones, so a porting
job shouldn't be that onerous even if you did not use an abstraction layer
in your code.
You may also download free, non-expiring trial ODBC Drivers from
www.openlinksw.com
Please let me know if I may assist in any way.
Best regards,
Andrew
--
Andrew Hill - OpenLink Software
Director Technology Evangelism
Universal Data Access Integration
http://www.openlinksw.com
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 23, 2001 8:18 AM
> To: Manuel Prieur; PHP-DB
> Subject: Re: [PHP-DB] MS-SQL Server on PHP4/Apache/Linux
>
>
> > I currently use PHP4/IIS to access a MS-SQLServer 7.0 with "mssql_*"
> > functions ("php_mssql70.dll" extension).
> >
> > I plan to move my website on PHP4/Apache/Linux, and I am
> wondering if thoses
> > functions will work and how, as I didn't find any explanations on it in
> > documentation.
> >
> I think the functions could work very well, but they will be totally
> useless since it does not exist a linux client for Ms-Sql.
>
> Porting your app to linux will require also the use of a different
> backend (I hope you used a DB abstraction layer).
>
> If this is not feasible, your only choice to access to MS-Sql from
> linux is using an ODBC client ported to linux (but you will have to
> chenage your code as well). You will find them easily on the list
> archive, I don't remember well the names and I don't want to give
> you a wrong link.
>
> HTH, bye
>
>
> /\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
>
> Fabrizio Ermini Alternate E-mail:
> C.so Umberto, 7 [EMAIL PROTECTED]
> loc. Meleto Valdarno Mail on GSM: (keep it short!)
> 52020 Cavriglia (AR) [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]
>
>
--
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]
