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:
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
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 =
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)
-
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
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 module
db = DAL('mssql://user1:pass...@servicogente.com.br/coelba')
File /Users/rochacbruno/Dropbox/gente/web2py/gluon/dal.py,
6 matches
Mail list logo