sql定位指定服务器,连接到SQL时“定位指定的服务器/实例时出错”

我使用Python2.7将下面的代码连接到sql实例class SqlConnector:

def __init__(self, driver, sqlserver_ip, database, **kwargs):

if 'port' in kwargs:

conn_string = 'DRIVER='+ driver + ';SERVER='+ sqlserver_ip +';PORT=' + kwargs['port'] + ';DATABASE=' + database + ';trusted_connection=yes;'

else:

conn_string = 'DRIVER='+ driver + ';SERVER='+ sqlserver_ip + ';DATABASE=' + database + ';trusted_connection=yes;'

print conn_string

self.conn = pypyodbc.connect(conn_string)

self.cur = self.conn.cursor()

def __enter__(self):

return self

def query(self, query_string):

self.cur.execute(query_string)

return

def get_all_table_columns(self):

columns = [column[0] for column in self.cur.description]

return columns

def get_all_table_rows(self):

rows = self.cur.fetchall()

return rows

def __repr__(self):

conn_string = 'DRIVER='+ driver + ';SERVER='+ sqlserver_ip + ';DATABASE=' + database + ';trusted_connection=yes;'

return conn_string

def __exit__(self, exc_type, exc_val, exc_tb):

if self.conn or self.cur:

# close cursor

self.cur.close()

# close connection

self.conn.close()

我的SQL实例类似于“hostname\PEWKA”，但下面的错误说明(u'08001', u'[08001] [Microsoft][SQL Server Native Client 11.0]SQL

Server Network Interfaces: Error Locating Server/Instance Specified

[xFFFFFFFF]. ')

这是使用pypyodbc连接SQL实例的正确方法吗？从中找不到太多的信息。在

任何人都会很感激的。在

谢谢