I have a web2py app (running on Ubuntu Linux) that has to connect to a
MS SQL Server.
I installed pyodbc, and the FreeTDS ODBC driver.
I defined a driver in odbcinst.ini, etc, etc. And could now connect
from the command line, via isql, to the remote database.
In web2py, the following connection string:
db = SQLDB('mssql://myuser:[email protected]:PPP/mydatabase) #
(PPP being the port number)
did not work. I traced the matter down to gluon/sql.py lines 833-836:
the engine being created did not seem to be actually using the port
number that was passed in via the connection string.
The port is parsed via regex on line 827, but then is not actually
used in creating the pyodbc connection.
Also, the engine was assuming that the ODBC driver was named 'SQL
Server' (mine was named 'FreeTDS').
To make it work temporarily, I ended up commenting out
#self._pool_connection(lambda : pyodbc.connect(cnxn))
and replacing it with:
self._pool_connection(lambda : pyodbc.connect
('SERVER=xxx.x.x.x;PORT=PPP;DATABASE=mydatabase;UID=myuser;PWD=mypassword;DRIVER=
{FreeTDS}'))
(which basically hardcodes my connection and bypasses the connection
string in any models - not great).
So, my question is, what's the right way to fix this? Can you extend
the connection string syntax so that we can pass in the driver name,
and also use the port that is passed in?
(For example, SQLAlchemy allows other arguments in the connect string,
like mssql:// ... /mydatabase?driver={FreeTDS} )
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
