Hi, I am for the first time messing with mssql dal adapter and are really struggling to get it working to a SQL2008 server..
I have gotten the connection with FreeTDS working When I connect in python with. >>> conn = pyodbc.connect ('DSN=TS;UID=foo;PWD=bar') >>> cursor = conn.cursor() >>> cursor.execute("select * from INVENT where ID=3000") <pyodbc.Cursor object at 0x14591b0> >>> for row in cursor: ... print row Everything works.. But when connecting with dal: db = DAL('mssql://foo:bar@host/db?DRIVER={FreeTDS}', migrate_enabled=False) I get the.. <class 'pyodbc.ProgrammingError'> ('42000', '[42000] [FreeTDS][SQL Server]Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier. (4004) (SQLExecDirectW)') I tried to send ?DRIVER={FreeTDS}&TDS_VERSION=8.0 with no result.. And I cannot do a DSN connection with DAL: db = DAL('mssql://DSN=TS;UID=foo;PWD=bar', migrate_enabled=False) Any ideas? Sorry if this has been up before and I missed totally.. But I am really stuck here :) -- Regards Falk -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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.