Connection String for Connecting Tally

Question

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 8-Mar-13 0:19am

Munavar Ankathil

Updated 8-Jan-21 15:18pm

v2

Add a Solution

2 solutions

Solution 3

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.

Posted 8-Jan-21 15:18pm

shivakad

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Menon Santosh · Accepted Answer · 2013-03-08T00:51:00

Solution 1

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

Posted 8-Mar-13 0:51am

Menon Santosh

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