Tally ODBC to Base Data Extraction

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Tally ODBC to Base Data Extraction

Postby Mahendra » Tue Jan 27, 2015 12:39 pm

Dear Experts,

I have requirement to extract data from tally ERP software to Calc, and for the same using Base to registere Database via Tally ODBC. While Selecting Data source screen and trying to Organise the data source i am getting Error Screen Headed by " ODBC Config Wrapper" :roll: and detailing "the setup routines for the tally odbc driver could not be found. Please re-install the driver" :oops:

My query is Whether i require to go to the config screen before registering the ODBC Source or no need to go in depth?

As in case i skip the config screen of Data Source selection, the Export is taking too long and not successfull.

Please guide in the matter. :?:

Thank you in advance.
Attachments
odbc Error Screenshot.JPG
Error Disply
Open Office 3.4.0
Win XP SP3
Mahendra
 
Posts: 3
Joined: Thu Nov 20, 2014 8:41 am

Re: Tally ODBC to Base Data Extraction

Postby eremmel » Wed Jan 28, 2015 10:08 am

The only thing I can think of is a mismatch between 32-bit Base and a 64-bit ODBC driver. You might verify this.
On W7 ODBC config tool is:
64 bit: c:\Windows\system32\odbcad32.exe
32 bit: c:\Windows\SysWOW64\odbcad32.exe
You normally configure ODBC via Windows first and test the connectivity.
When that is working you try to access it via Base.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8.2 for real life with ORB; AOO4.1.3,LO5.2.5.1 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 916
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: Tally ODBC to Base Data Extraction

Postby Mahendra » Fri Jan 30, 2015 2:30 pm

Dear eremmel,

Thanks for your Prompt reply in the matter,

But my Operating system is 32Bit Windows Xp SP3 and the same is not configuring.

I have shared the screenshot. Test of Connectivity is successful, but not importing data.

If the details are insufficient please reply.

thanks in advance.
Open Office 3.4.0
Win XP SP3
Mahendra
 
Posts: 3
Joined: Thu Nov 20, 2014 8:41 am

Re: Tally ODBC to Base Data Extraction

Postby eremmel » Fri Jan 30, 2015 8:17 pm

You schreenshot indicates that you try to configure/organize ODBC via Base (as you told before). Can you prevent that and set/configure your ODBC source via Windows, so you only have to pickup the name of your odbc resource and try to connect?

I've experience with some source writing of ODBC and the interface is rich and has many details. Sometimes clients (like Base) do not match (has the wrong assumptions) of a ODBC source. So you might also run into an interoperability issue.

What do you mean with 'but not importing data'. Your information so far indicates a connectivity issue.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8.2 for real life with ORB; AOO4.1.3,LO5.2.5.1 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 916
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: Tally ODBC to Base Data Extraction

Postby Mahendra » Sat Feb 07, 2015 10:00 am

ODBC Test.JPG
ODBC Connectivity Test
Yes Eremmel,

I tested connection in 3rd Step "Set up and User Authentication", Screen shot attached.

database got saved.

Further "but not importing data" mean table wizard is not opening.

in Table opening Wizard no data get poped up. which problem is stopping the table opening command is not understood.

can you guide to find the prob and to solve.

And what is "interoperability issue." u mentioned in your reply?


Thanking you
Attachments
ODBC Table Wiz.JPG
Table Wizard
Open Office 3.4.0
Win XP SP3
Mahendra
 
Posts: 3
Joined: Thu Nov 20, 2014 8:41 am

Re: Tally ODBC to Base Data Extraction

Postby eremmel » Sat Feb 07, 2015 1:01 pm

From you last screen shot I see that tables are retrieved from system. What happens when you try to open a table (double klick) on it? Do you see the data? I've impression that this is not the case according your description, but you are also taling about Wizard and that is something different. It is very likely that you can not change (and examine?) the table definition.

What about making a query to select some data like "select * from Ledger", does that show some data?

When you like to trace some ODBC stuff you might checkout this microsoft articel. It might also possible that Tally has its own logging/tracing system, that that is something for Tally's documentation / forum to search.

With "interoperability issue" I mean that there is a protocol mismatch in expectations between the various software layers.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8.2 for real life with ORB; AOO4.1.3,LO5.2.5.1 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 916
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 3 guests