Click here to Skip to main content
14,875,030 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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)')
>>>
Posted
Updated 17-Apr-19 3:08am

1 solution

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

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900