ODBC设置没有问题,可以连接。

组件测试连接没问题。

运行起来就报错。

报错信息:
(-2147352567, '发生意外。', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '[Oracle][ODBC][Ora]ORA-12154: TNS: 无法处理服务名\n', None, 0, -2147217843), None)
Traceback (most recent call last):
File "D:\Program Files (x86)\ShadowBot\shadowbot-5.12.31\python\lib\runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "D:\Program Files (x86)\ShadowBot\shadowbot-5.12.31\python\lib\runpy.py", line 85, in _run_code
exec(code, run_globals)
File "D:\Program Files (x86)\ShadowBot\shadowbot-5.12.31\python\lib\site-packages\xbot_interpreter.py", line 87, in <module>
main()
File "D:\Program Files (x86)\ShadowBot\shadowbot-5.12.31\python\lib\site-packages\xbot_interpreter.py", line 47, in main
try:
File "C:\Users\zjzwy\AppData\Local\ShadowBot\users\103990756052623361\apps\471a97d9-f31a-4d11-967d-f713b138b02a\xbot_robot\main.py", line 9, in main
oracle = xbot_visual.database.connect(conn_str="Provider=MSDASQL.1;Password=******;Persist Security Info=True;User ID=jxwy_user;Data Source=jxwyC", _block=("main", 1, "连接数据库"))
File "<string>", line 89, in wrapper
File "<string>", line 84, in wrapper
File "<string>", line 9, in connect
File "<string>", line 28, in open
File "<string>", line 32, in open
File "<COMObject ADODB.connection>", line 3, in Open
File "D:\Program Files (x86)\ShadowBot\shadowbot-5.12.31\python\lib\site-packages\win32com\client\dynamic.py", line 287, in _ApplyTypes_
result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args)
pywintypes.com_error: (-2147352567, '发生意外。', (0, 'Microsoft OLE DB Provider for ODBC Drivers', '[Oracle][ODBC][Ora]ORA-12154: TNS: 无法处理服务名\n', None, 0, -2147217843), None)