使用pyodbc，隐藏用户名/ pw连接到Web2Py DAL中的MSSQL数据库(Connect to MSSQL dataBase in Web2Py DAL using pyodbc, hidden username/pw)

 尽管有很多谷歌搜索，但还没有找到满意的答案。 我也是web2py和SQL Server的新手，所以也许我从一开始就以错误的方式解决了这个问题，除了我已经设置好的解决方案之外还有一个更好的解决方案。 无论如何： 
 
 我正在将一个web2py应用程序从一个MSSQL Server连接移动到另一个，因为出于体制原因，我不应该直接“看到”新的连接字符串，包括密码等。 
 
 我已经通过让所有者隐藏了我可以运行的.pyc文件中的所有细节而没有看到任何内容来解决这个外部web2py。 
 
DATA_CONNECTION = imp.load_compiled('DATA_CONNECTION', 'N:\\location')
cnxn                = DATA_CONNECTION.getMyConnection() #produces a pyodbc connection
 
 我的问题是，如何在不将.pyc文件中隐藏的所有受保护信息输入到连接字符串中的情况下，让web2py DAL接受相同的'cnxn'？ 
 
 这是我之前使用的连接字符串（使用我的网络凭据作为用户/ pw）。 新连接在.pyc文件中有一个我无法看到的显式用户名/密码： 
 
db = DAL('mssql://DRIVER={SQL Server};SERVER= XXX-011;DATABASE=MyDB;TRUSTED_CONNECTION=yes;migrate_enabled = False')

Have not found a satisfactory answer to this despite much googling. I am also new to web2py and SQL Server in general, so perhaps I have approached this problem in the wrong way from the start and there is a better solution outside what I have already set up. Anyway:
 
I am moving a web2py app from one MSSQL Server connection to another, the wrinkle being that for institutional reasons I should not directly "see" the new connection string, including password etc.
 
I have gotten around this outside web2py by having the owner hide all the details in a .pyc file that I can run but not see any contents. 
 
DATA_CONNECTION = imp.load_compiled('DATA_CONNECTION', 'N:\\location')
cnxn                = DATA_CONNECTION.getMyConnection() #produces a pyodbc connection
 
My question is, how do I get the web2py DAL to accept this same 'cnxn' without entering all the protected information hidden in the .pyc file into the connection string?
 
This is the connection string I was using before (using my network credentials as the user/pw). The new connection has an explicit username/pw in the .pyc file that I cannot see:
 
db = DAL('mssql://DRIVER={SQL Server};SERVER= XXX-011;DATABASE=MyDB;TRUSTED_CONNECTION=yes;migrate_enabled = False')

原文：https://stackoverflow.com/questions/26847936