phthon 连接sql server数据库执行存储过程报错,求大侠解决
16lz
2021-01-22
刚学习python,试着用python写一个脚本去执行一个存储过程,但是在连接数据库的时候一直报错,我用的是python的adodbapi中的connect去连接的:
#coding=utf-8
importcgi
importadodbapi
fromadodbapiimportconnect
server='109.123.100.11'
user='user_name'
password='password'
database='dbname'
sp='dbo.spname'
parameter="2014"
db=connect('DataSource=%s;InitialCatalog=%s;UserID=%sPassword=%s;'%(server,database,user,password))
运行时报错,看上去是连接时报错了,请各位大侠帮忙看一下,给跪了~~:
Traceback(mostrecentcalllast):
File"C:\Users\workspace\testdatabase\main.py",line13,in<module>
db=connect('DataSource=%s;InitialCatalog=%s;UserID=%sPassword=%s;'%(server,database,user,password))
File"C:\Python33\lib\site-packages\adodbapi\adodbapi.py",line116,inconnect
raiseapi.OperationalError(e,message)
adodbapi.apibase.OperationalError:(InterfaceError("WindowsCOMError:Dispatch('ADODB.Connection')failed.",),'Erroropeningconnectionto"DataSource=109.123.100.11;InitialCatalog=dbname;UserID=user_namepassword=password;"')
#coding=utf-8
importcgi
importadodbapi
fromadodbapiimportconnect
server='109.123.100.11'
user='user_name'
password='password'
database='dbname'
sp='dbo.spname'
parameter="2014"
db=connect('DataSource=%s;InitialCatalog=%s;UserID=%sPassword=%s;'%(server,database,user,password))
运行时报错,看上去是连接时报错了,请各位大侠帮忙看一下,给跪了~~:
Traceback(mostrecentcalllast):
File"C:\Users\workspace\testdatabase\main.py",line13,in<module>
db=connect('DataSource=%s;InitialCatalog=%s;UserID=%sPassword=%s;'%(server,database,user,password))
File"C:\Python33\lib\site-packages\adodbapi\adodbapi.py",line116,inconnect
raiseapi.OperationalError(e,message)
adodbapi.apibase.OperationalError:(InterfaceError("WindowsCOMError:Dispatch('ADODB.Connection')failed.",),'Erroropeningconnectionto"DataSource=109.123.100.11;InitialCatalog=dbname;UserID=user_namepassword=password;"')
3 个解决方案
#1
#我用的是pymssql
defconnect_db():
returnpymssql.connect(
host ='hostname',
database ='databasename',
user ='userid',
password ='password'
)
更多相关文章
- 字体图标的引入和通过媒体查询改变导航样式
- HTML样式和常用选择器
- 字体图标的引用和自定义样式/媒体查询的使用
- 数据库的CURD操作、PDO本质与原理的学习
- CSS之伪类选择器和简单盒子简单案例
- 伪类选择器与盒模型常用属性
- 伪类选择器-结构伪类、根据位置选择匹配
- 7.4——常用标签与应用场景之表格与单元格
- css伪类选择器和盒模型