Dec 02, 2016  Using the ODBC feature available in Tally.ERP 9 the. For all those who are facing problem of 'DATA SOURCE NAME NOT FOUND. ODBC - in Tally.ERP 9. However, there is a driver requirement if, the Operating System is 64 Bit, while. Tally.ERP 9 is 32 bit and MS Office is 64-bit.

ODBC - in TaIly.ERP 9 With Open Database Connection you can dynamically trade information between TaIly.ERP 9 and any additional application dynamically. You must ensure that MS-Query is usually installed on the personal computer in which you will become installing Tally.ERP 9. This enables ODBC mainly because quickly as Tally.ERP 9 is definitely installed. The ODBC machine is shown on the info stop of the information pane. To read even more on the inward and external connectivity click on on one óf the corresponding back links below:.

Outward Connectivity. Inward Connectivity Outward Connection Using the outward connection feature of TaIly.ERP 9, you can exchange information between programs without extra programming. The user can move information from TaIly.ERP 9 to Microsoft Word or Excel. Using the Outward Connectivity function you can:. Generate Brands from ledger addresses kept in TaIly.ERP 9. Create templates for reports, forms and put in up-to-date data from TaIly.ERP 9. Buku persamaan ic dan transistor circuits. Tally.ERP 9 ODBC with Microsoft Excel Outward Connection from Tally.ERP 9 Making use of the ODBC function accessible in TaIly.ERP 9 the consumer can extract the essential data in Excel and produce the required reviews.

To get information from TaIly.ERP 9 in Excel carry out the subsequent steps:. Download do jogo euro truck simulator 2. Begin Tally.ERP 9. It should be open up till the Mail Merge procedure is full. Ensure that the terms ODBC Machine is visible in the Info Screen under Configuration area of Tally.ERP 9 display. Open Excel linen.

Proceed to Information >From Various other Sources >From Microsoft Issue (Transfer data for an unlisted file format by using the Microsoft Problem Wizard) Img-52. Select the Tally.ERP 9 Source (Instance: TallyODBC 9000.). Click OK Img-53 The display displayed above appears when TaIly.ERP 9 exe is usually 32 Little bit.

Note: If Tally.ERP 9 - 64 Bit, the display seems as shown below: Observe thát the DSN (Information Source Name) chosen is definitely TallyODBC649000, where 9000 is definitely the ODBC Machine port quantity. Img-54. The Issue Wizard windows opens. Select Journal Img-55.

Increase the list under Ledger and choose the required areas and shift the needed fields to the right part Img-56. Click Next Img-57. Map the Mother or father as Manifold Borrowers (if only Sundry borrowers are needed) or Sundry Lender (if just Sundry Creditors are needed) or select both one by one, structured on the necessity. Img-58. Click on Next.

If any working is needed go for the sorting. Click on Next. Click on Conserve Issue. Save the Predicament in a specific path (Eg. M: Documents and Configurations User Software Data Microsoft Questions Predicament from TallyODBC9000.dqy). Click on Finish off Img-59. The customer information can furthermore be observed in the Excel bed sheet.

Click OK in the Import Data window to import the data to Excel Img-60. Press Fine Img-61 Exceptional instances for 64 Bit compatible scenarios There are usually three essential components whose bitness figure out the Move via ODBC process:. Tally.ERP 9,. Working Program, and. MS Office The ODBC feature functions seamlessly when, the Operating Program, Tally.ERP 9 and Master of science Office are all 64-little bit. The technique for this is definitely as shown above.

However, there is usually a drivers necessity if, the Operating System is usually 64 Little bit, while. Tally.ERP 9 can be 32 little bit and Master of science Office will be 64-bit. Tally.ERP 9 is certainly 64 bit and MS Office is usually 32-bit. As can be seen, in both instances there will be a bitness mismátch between TaIly.ERP 9 and Master of science Office. Due to this, TaIly.ERP 9 (which functions as the ODBC Server) will not be capable to connect with Master of science Excel and hence information will not really be exported. Right now, to enable data move, a driver is definitely to be set up.

In the initial scenario, to export data via ODBC,. Open the Tally Program folder.

Select the tool regodbc64.exe and Operate as Administrator. This will install the driver tallywin64.dat In the second scenario,. Select the tool regodbc32.exe and Run as Manager. This will install the motorist tallywin32.dat To summarise, Tally.ERP 9 Bitness Operating Program 64 Little bit MS Office 32 Little bit MS Office 64 Bit 32 Bit Functions seamlessly without car owner installation Driver to become Set up: tallywin64.dat To install, choose the tool regodbc64.exe and Operate as Admin 64 Bit Driver to become Installed: tallywin32.dat To install, choose the tool regodbc32.exe and Operate as Admin Works seamlessly without driver set up Img-62 Once the car owner has become installed, you can carry on with the move procedure in Master of science Excel.

Indward Connectivity Inward connectivity integrates data from various other systems with TaIly.ERP 9. With this function you can make use of information from some other techniques in TaIly.ERP 9 by producing an integrated system.

For example, a consumer contact management program filled with information like status of an purchase and final contact made can be introduced into TaIly.ERP 9 and combined into a document containing outstanding balances. Adjustments made to the data are instantly shown in TaIly.ERP 9.

To connect to other applications and make use of external data in TaIly.ERP 9, you can contact the nearest Tally Offices or send out an email to support@tallysolutions.com.