RE: [PHP-DB] MS-SQL Server on PHP4/Apache/Linux

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: fabrizio.ermini@sysdat.it [mailto:fabrizio.ermini@sysdat.it] > 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 faermini@tin.it > loc. Meleto Valdarno Mail on GSM: (keep it short!) > 52020 Cavriglia (AR) faermini@sms.tin.it > > -- > 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 > >