tanveer Posted May 5, 2009 Share Posted May 5, 2009 Hello all, Is it possible to connect to MSSQL server 2008 from linux? Currently I am using freetds to connect to a MSSQL server 2000. Our DBA team upgraded to 2008 and most probably freetds doesn't support 2008 yet. Thanks in advance. Link to comment https://forums.phpfreaks.com/topic/156927-connect-with-mssql-server-2008/ Share on other sites More sharing options...
Yesideez Posted May 5, 2009 Share Posted May 5, 2009 If you're using PHP, yes it is possible and you're best off using the in-built MSSQL functions: http://uk.php.net/mssql I've tried using Microsoft's DLL libraries to do this myself and found they weren't developed enough. After playing with the above functions I was able to connect to a MSSQL database and access it just like I was accessing a MySQL database. Note that MysQL calls won't work - you'll need to use MSSQL calls. By this I mean LIMIT doesn't work, you need to manipulate the TOP function to emulate this. Link to comment https://forums.phpfreaks.com/topic/156927-connect-with-mssql-server-2008/#findComment-826630 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.