＆quot“ sawarning：未指定驱动程序名称； PYODBC使用dsn Engine = sa.Create_engine（sqlalchemy_database_url）期望这是预期的。
几次检查后，使用PYODBC使用PYODBC有问题。
来自SQLalchemy Import create_engine 来自sqlalchemy.ext.declarative Import dectarative_base 来自sqlalchemy.orm导入会话者 import pyodbc
SQLALCHEMY_DATABASE_URL = f"mssql+pyodbc://user_one:secret@DESKTOP-6T5DDMB\mypassword/Billy+Driver=SQL+Server+Native+Client+11.0',echo=True"
engine = create_engine(SQLALCHEMY_DATABASE_URL)
SessionLocal = SessionMaker（AutoCommit = false，autoflush = false，bind =引擎）
Having issues connecting to my sql-server using pyodbc after several checks.
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
import pyodbc
SQLALCHEMY_DATABASE_URL = f"mssql+pyodbc://user_one:secret@DESKTOP-6T5DDMB\mypassword/Billy+Driver=SQL+Server+Native+Client+11.0',echo=True"
engine = create_engine(SQLALCHEMY_DATABASE_URL)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
因此，经过Stackoverflow进行了彻底的研究，我发现使用错误的连接字符串缺少了我的代码中的一些语法。
错误：
f“ mssql+pyodbc：// user_one：secret@desktop-6t5ddmb \ mypassword/mypassword/billy+driver = sql+server+server+server+server+server+client+client+11.0'，echo = true”
导入sqlalchemy作为
mssql+pyodbc：// desktop-6t5ddmb \ mypassword/billy？driver = sql+server+server+server+server+server+本机+client+11.0 </code = sa.createe_engine（sqlalchemhchemy_database_url）
和Windows使用Windows和Windows验证。
So after a thorough research from stackoverflow i discovered i was missing some syntax from my code using a wrong connecting string.
wrong:
f"mssql+pyodbc://user_one:secret@DESKTOP-6T5DDMB\mypassword/Billy+Driver=SQL+Server+Native+Client+11.0',echo=True"Right:
import pyodbc
import sqlalchemy as
mssql+pyodbc://DESKTOP-6T5DDMB\mypassword/Billy?driver=SQL+Server+Native+Client+11.0engine = sa.create_engine(SQLALCHEMY_DATABASE_URL)
And this is applicable when using Windows Authentication.
如果您像我一样疯狂，因为您 do 在URI 和中具有“驱动程序”参数指定名称； PYODBC使用dsn-less connections 警告时，这是可以预期的，然后让我节省一些时间：
出于某种奇怪的原因，“驱动程序”参数必须为 seludcase ：
不正确并且会产生警告：
mssql+pyodbc：//@{server} .sacredheart.edu/shudw？driver = odbc+驱动程序+驱动程序+13+for+sql+sql+servermssql+pyodbc：// pyodbc：// 。
MSSQL+PYODBC：//@{server} .sacredheart.edu/shudw？driver = odbc+驱动程序+驱动程序+13+for+sql+serverIf you are going crazy like I was because you do have the "driver" parameter in the uri and your queries are running correctly but with the
SAWarning: No driver name specified; this is expected by PyODBC when using DSN-less connectionswarning, then let me save you some time:The "driver" parameter for some odd reason MUST be lowercase:
Incorrect and will produce warning:
mssql+pyodbc://@{server}.sacredheart.edu/SHUDW?Driver=ODBC+Driver+13+for+SQL+Servermssql+pyodbc://@{server}.sacredheart.edu/SHUDW?DRIVER=ODBC+Driver+13+for+SQL+ServerCorrect:
mssql+pyodbc://@{server}.sacredheart.edu/SHUDW?driver=ODBC+Driver+13+for+SQL+Server