|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
import pymssql
conn = pymssql.connect(host=".",user="sa",pwd="123",db="school")
import pandas
sql2 = "select * from Table_1"
s1 = pandas.read_sql(sql2,conn)
df = pandas.DataFrame(s1)
以上是我写的,但是一直显示错误,返回如下:
Traceback (most recent call last):
File "<ipython-input-30-56d07b6455d5>", line 2, in <module>
conn = pymssql.connect(host=".",user="sa",pwd="123",db="school")
File "src\pymssql.pyx", line 582, in pymssql.connect
TypeError: connect() got an unexpected keyword argument 'pwd'
麻烦大家帮忙看看问题,那个密码应该怎样获取,我登录sql的账号密码确实是这个啊
本帖最后由 wongyusing 于 2019-2-19 23:35 编辑
官方的游标是下面的写法,自行参考
- conn = pymssql.connect(server, user, password, "tempdb")
复制代码
- conn = pymssql.connect(
- host=r'dbhostname\myinstance',
- user=r'companydomain\username',
- password=PASSWORD,
- database='DatabaseOfInterest'
- )
复制代码
|
|