Here is a working example using server authentication on a server called win2003, with a sqlserver instance name hcnsql07 and connecting to a database called hcn using default ports
(I've added a couple of other parameters for performance. Investigate lazy_tables, it makes a huge difference. ) db_ps_1TE = DAL('mssql://tim:password@win2003\hcnsql07/hcn', lazy_tables=True, pool_size=10) On Monday, 11 November 2013 07:10:43 UTC+11, Ariya Owam-aram wrote: > > Dear all, > > I have to connect mssql database which is locate on another server by > using pyodbc. > > It working if connect by using > > pyodbc.connect(DNS=dns;UID=user_name;PWD=password) >> <pyodbc.Connection at 0x391bdc0> >> > > But I can't connect with DAL() > > db = >> DAL("mssql://userName:passw...@203.xxx.xx.xxx\SQLExpress,1433/myDatabase") > > > return error as follow > >> Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not >> found, and no default driver specified (0) (SQLDriverConnect)') > > > As searching from web2py google group, I also try: > > db = >> DAL("mssql://userName:passw...@203.xxx.xx.xxx\SQLExpress,1433/myDatabase?Driver={FreeTDS}") > > > return error as follow > > Error: ('08001', '[08001] [unixODBC][FreeTDS][SQL Server]Unable to connect > to data source (0) (SQLDriverConnect)') > > --------------------------- > in my /etc/odbc.ini > > [TS] >> Description="ODBC Connection via FreeTDS" >> Driver=FreeTDS >> Server=203.xxx.xx.xxx >> port=1433 >> Database=myDatabase > > --------------------------- > in my /etc/odbcinst.ini > >> [FreeTDS] >> Description=FreeTDS >> Driver=/usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so >> Setup=/usr/lib/x86_64-linux-gnu/odbc/libtdsS.so > > --------------------------- > in my /etc/freetds/freetds.conf > > ### Did not change anything ### > > --------------------------- > in my /etc/freetds/tds.driver.template > >> [TDS] >> Description = FreeTDS Driver for Linux & MSSQL on Win32 >> Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so >> Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so > > --------------------------- > in my /etc/freetds/tds.dsn.template > > [DSN_NAME] > >> Description = Descripton of you DSN connection. >> Driver = TDS >> Trace = No >> Database = myDatabase >> Server = 203.xxx.xx.xxx >> Port = 1433 >> TDS_Version = 8.0 > > > > > Thank you very much > Ariya > > -- 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.