the best answer to that threat is freetds which I actually have had success from Linux but is it supported by web2py?
On Thursday, July 18, 2013 5:26:33 PM UTC-7, Niphlod wrote: > > plenty of references around the web.... it's a PITA to connect to MSSQL > from a linux "client" but take advices even related to other programming > languages to fix the odbc driver "bugs" and "intricacies", like > http://stackoverflow.com/questions/10728290/mssql-servers-native-odbc-driver-for-linux-and-php-5-4 > > On Thursday, July 18, 2013 9:50:04 PM UTC+2, greenpoise wrote: >> >> this is my URI >> >> db = DAL('mssql://sa:rms123@192.168.1.40/SQLEXPRESS/HQ') >> >> >> >> this is the error I get: >> >> Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL >> Server' : file not found (0) (SQLDriverConnect)") >> >> >> I have pyodbc and all installed.. I tried changing the pool_size to >> 20..nothing...Tried using the hostname instead of the IP, nothing.. >> >> >> >> -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.