与Tally odbc连接？ [英] Tally odbc connection with Python ?

问题描述

我尝试了一些方法，但它不工作我使用pyodbc for python 连接到tally odbc我尝试了dsn但也没有用，请帮帮我！



我的尝试：



>>> import pyodbc

>>> conn = pyodbc.connect（'DSN = TallyODBC64_9000; SERVER =（{local}）; DRIVER = Tally ODBC DRIVER64; PORT = 9000'）

Traceback（最近一次调用最后一次）：

文件< pyshell＃1>，第1行，< module>

conn = pyodbc.connect（'DSN = TallyODBC64_9000; SERVER =（{local}）; DRIVER = Tally ODBC DRIVER64; PORT = 9000'）
pyodbc.InterfaceError：（'IM002'，'[IM002] [Microsoft] [ODBC驱动程序管理器]未找到数据源名称且未指定默认驱动程序（ 0）（SQLDriverConnect）'）

>>>

i tried some methods but it not working i using pyodbc for python to connect to tally odbc i tried the dsn also but didn't work please help me out!

What I have tried:

>>> import pyodbc
>>> conn = pyodbc.connect('DSN=TallyODBC64_9000;SERVER=({local});DRIVER=Tally ODBC DRIVER64;PORT=9000')
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
conn = pyodbc.connect('DSN=TallyODBC64_9000;SERVER=({local});DRIVER=Tally ODBC DRIVER64;PORT=9000')
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
>>>

推荐答案

参见连接数据库·mkleehammer / pyodbc Wiki·GitHub [ ^ ]并按照链接检查连接字符串的具体格式。

See Connecting to databases · mkleehammer/pyodbc Wiki · GitHub[^] and follow the links to check the specific format of the connection string.

这篇关于与Tally odbc连接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！