函数库怎么连接sqlserver数据库

MaxKB
1

函数库怎么连接sqlserver数据库呢，不是mysql是ms的sqlserver，有连接的教程和方案嘛？3Q

2

首先需要在容器中安装依赖库，后续在函数库中使用依赖库连接数据库即可，具体连接脚本如何写可以咨询AI。

3

参考脚本：

import pymssql

def execute_sql_query():
    # 定义连接信息
    server = 'xx.xx.xx.xx'
    port = '1433'
    database = 'xxx'
    username = 'xxx'
    password = 'Password123@xxx'

    # 建立连接
    cnxn = pymssql.connect(server=server, port=port, user=username, password=password, database=database)
    # 创建游标对象
    cursor = cnxn.cursor()

    # 执行SQL查询
    cursor.execute("SELECT * FROM Customers")

    # 获取查询结果并格式化输出
    result = "success：\n"
    rows = cursor.fetchall()
    for row in rows:
        result += str(row) + "\n"
            
    return result
4

image
image1144×314 13.7 KB

容器里已经安装过 pymssql 了。。

5

估计是库版本和数据库版本不兼容。
https://blog.51cto.com/u_16402631/12782039

6

已经查询成功，感谢。

1 个赞
7

感谢大佬,经过旧版组件+AI推理,成功了

8

我这边报错 libodbc.so.2: cannot open shared object file: No such file or directory

9

用了这个脚本报了这个错是什么原因 我把py脚本放到容器里面 用命令行跑都能出结果 但是用函数调试就出不来结果
Traceback (most recent call last):
File “/opt/py3/lib/python3.11/site-packages/rest_framework/views.py”, line 506, in dispatch
response = handler(request, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/maxkb/app/apps/common/auth/authentication.py”, line 93, in run
return func(view, request, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/maxkb/app/apps/function_lib/views/function_lib_views.py”, line 59, in post
request.data))
^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/request.py”, line 220, in data
self._load_data_and_files()
File “/opt/py3/lib/python3.11/site-packages/rest_framework/request.py”, line 283, in _load_data_and_files
self._data, self._files = self._parse()
^^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/request.py”, line 358, in _parse
parsed = parser.parse(stream, media_type, self.parser_context)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/parsers.py”, line 66, in parse
return json.load(decoded_stream, parse_constant=parse_constant)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/opt/py3/lib/python3.11/site-packages/rest_framework/utils/json.py”, line 31, in load
return json.load(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/usr/local/lib/python3.11/json/init.py”, line 293, in load
return loads(fp.read(),
^^^^^^^^^
File “”, line 499, in read
File “/opt/py3/lib/python3.11/site-packages/django/http/request.py”, line 410, in read
raise UnreadablePostError(*e.args) from e
django.http.request.UnreadablePostError: [Errno 104] Connection reset by peer