[web2py] MSSQL Connection not working with instance name and without port

Hi Guys, i am able to connect to our MSSQL Database with the following command: *cnxn = pyodbc.connect('SERVER=dbhost\dbinstance;DATABASE=dbname;UID=dbuser;PWD=dbpassword')* *(By the way: We use FreeTDS as Driver but i removed it from this example)* If i use the PyDAL with this String: *DAL('

[web2py] MSSQL connection

Hi guys. Newbie (of sorts) here. 20+ years in programming including Python but not for a couple of years now. But now I have the first time opportunity to build my application in web2py ~ so not a newbie but yes a web2py newbie. Any quick start guides/guide for dummys style for adapting the defa

[web2py] mssql connection URGENT!

The below connection statement was working fine and the SQL Servers's instance was HELPDESK/HELPDESK. dbh = DAL("mssql2://username:password@HELPDESK/HS2000CS", migrate_enabled=False) Now, our vendor change the name of instance to HELPDESK/HELPDESK_VM. I tried, dbh = DAL("mssql2://username:pa

[web2py] mssql connection

Dear all, I have to connect mssql database which is locate on another server, I use pyodbc for and it work well from pyodbc.connect() But I cant set it work on DAL() Thank you very much Ariya -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/w

[web2py] MSSQL connection error

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.

[web2py] MSSQL Connection error on MacOS

HI, I am trying connection to MSSQL using standalone DAL, but I am getting this error: Traceback (most recent call last): File "baixar_arquivos.py", line 10, in db = DAL('mssql://user1:pass...@servicogente.com.br/coelba') File "/Users/rochacbruno/Dropbox/gente/web2py/gluon/dal.py", line