Click here to Skip to main content
14,878,230 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hii

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

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


Pls Give me a replay

Thanks
Posted
Updated 8-Jan-21 15:18pm
v2

[__b__]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=(192.168.1.201); PORT=6300
as per your ip address and port.
   
open tally with following connection

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


make sure tally is running and the client is opened state
it is for tally ERP
   
v2
Comments
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();
TallyDataAdapter.Fill(TallyDataSet);
TallyCollectionConnection.Close();
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

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