Click here to Skip to main content
15,799,398 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

When i tried to Connect my C# application with Tally , Getting an Error "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

My connection String Is

private static OdbcConnection TallyConnection = new OdbcConnection("PORT=9000;DRIVER=Tally  ODBC Driver;SERVER={(local)}");

Pls Give me a replay

Updated 8-Jan-21 16:18pm

open tally with following connection

OdbcConnection TallyCon = new OdbcConnection("DSN=TallyODBC_9000");

make sure tally is running and the client is opened state
it is for tally ERP
Share this answer
Munavar Ankathil 8-Mar-13 7:08am    
Thanks santhosh
Tally connectin is ready But when I Try to fill the dataset i getting another error "The connection has been disabled."
My code is below

OdbcCommand TallyCommand = new OdbcCommand("SELECT StockItem.$Name, StockItem.$Parent FROM TESTER.TallyUser.StockItem ORDER BY StockItem.$Name", TallyConnection);
OdbcDataAdapter TallyDataAdapter = new OdbcDataAdapter(TallyCommand);
DataSet TallyDataSet = new DataSet();
return TallyDataSet;
Menon Santosh 8-Mar-13 7:11am    
you might be try to access some temporary tables of tally that is why it is disabling connection, check that the table is temporary or not
please execute tally folder regodbc32.exe file.
it will create odbc 32bit driver and use following query string for data access 
DRIVER={Tally ODBC Driver}; SERVER=(; PORT=6300
as per your ip address and port.
Share this answer

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