Software Information |
Navision Attain Database access via C/ODBC in ASP.NET Application
Navision Software was purchased by Microsoft and now it is supported by Microsoft Business Solutions together with Microsoft Great Plains, Axapta, Solomon, Microsoft Retail Management System and Microsoft CRM. Navision has extremely strong position on mid-size European and US markets, plus it has excellent manufacturing solution. Our goal is to help IT departments to support and tune Navision with in-house expertise and skills.The topic of this article is Navision database access from ASP.NET application via C/ODBC interface. Our goal will be ASPX page accessing Navision Customers. Let's begin 1. In our case we will use Navision Attain 3.6 with Navision Database Server, Navision Application Server and Navision Client. These components are installed on Windows XP. You also need to install C/ODBC component form Navision Attain CD. 2. Let's create ODBC DSN for Navision data access. Select Control Panel -> Administrative Tools -> Data Sources (ODBC). Then select System DSN tab and press Add button. We'll use C/ODBC 32-bit data access driver. We'll name Data Source Name Navision, Connection leave Local. As the database (Database button) select Program FilesNavision AttainClientdatabase.fdb (demo database). Then click Company button - we'll use CRONUS demo company. It is important for C/SIDE correct database access to setup proper options for C/ODBC connection. Press Options button and look at the options available - we'll need Identifiers parameter - it defines identifiers types, which will be transferred to the client application. In order to work correct with MS SQL Server 2000 with C/ODBC source we need to use these type: "a-z,A-Z,0-9,_". Now DNS is done. Let's create Linked Server. 3. Open MS SQL Server Enterprise Manager. Open server tree for the server, which you plan to use, for this server open Security folder and Lined Servers. With right click select New Linked Server in context menu. In the dialog box opened in the Provider Name select Microsoft OLE DB Provider for ODBC Drivers. Let's name our Linked Server NAVISION. In Data Source string enter ODBC DSN name - NAVISION in our case. Linked Server is ready! Let's select tables list and look at the data from Navision Attain database. 4. Next we need to create small stored procedure for sales data selection. Here is the text of the procedure:SET ANSI_NULLS ONSET ANSI_WARNINGS ON GO CREATE PROCEDURE NavisionCustomers AS DBCC TRACEON(8765)SELECT No_, Name, Address, City, Contact FROM OPENQUERY(NAVISION, 'SELECT * FROM Customer') RETURN Let's clarify some points here. TRACEON(8765) directive allows us to work with the data of variable length, returned by C/ODBC driver. Without it we can not select Navision tables fields - we will have these errors: OLE DB error trace [Non-interface error: Unexpected data length returned for the column: ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1'].Server: Msg 7347, Level 16, State 1, Line 1OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL].Ship_to_Filter'. The expected data length is 250, while the returned data length is 1. OPENQUERY command opens linked server and gives it execution request, and returns record set selected. Directives ANSI_NULLS and ANSI_WARNINGS are required - they provide the possibility of the execution for heterogeneous requests. To test the procedure you can give its name in MS SQL Query Analyzer - EXEC NavisionCustomers 5. Now we need to create ASP.NET application. Let's use free RAD environment ASP.NET WebMatrix. You can get infor and download it at http://asp.net/webmatrix . You need .NET SDK 1.1 installed, before WebMatrix installation. 6. Launch WebMatrix, select creation of the Data Pages -> Editable Data Grid in the wizard screen. Let's keep all the defaults suggested. On the access page created we'll change the header to Navision Attain Customers, select Verdana font and the font size desired. Next place on the page the component SqlDataSourceControl and tune it's - Connection String : server='(local)'; database='Alba';trusted_connection=true (change server and database name to your actual names), and SelectCommand - as EXEC NavisionCustomers 7. For our Data Grid, which will show customers, define DataSource as SqlDataSourceControl1, and DatKeyField - as No_ 8. Next switch to code edition mode and make these changes: ? In the DataGrid_Delete method let's correct the request for the customer deletion to the one we need ? Change DataGrid_Delete code, base on the fields we plan to use 9. Launch our application and test it. This is it! Happy customizing, implementing and modifying! If you want us to do the job - give us a call 1-866-528-0577 or 1-630-961-5918! help@albaspectrum.com Boris Makushkin is Lead Software Developer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, serving Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, Miami, Montreal, Toronto, Vancouver, Moscow, Europe and internationally ( http://www.albaspectrum.com ), he is Microsoft CRM SDK, Navision, C#, VB.Net, SQL, Oracle, Unix developer.
MORE RESOURCES: Unable to open RSS Feed $XMLfilename with error HTTP ERROR: 404, exiting |
RELATED ARTICLES
Guide to Software Marketing IntroThis concise article will tell you in plain English how you can promote your software easily and effectively.Submit your softwareI recommend submitting your software to upload. Should I Use Windows Update? Should one use Windows Update?This topic has good and valid arguments on both sides. Some would say keeping your windows up to date is essential in keeping it free of the newest, worst viruses and the like. Introduction To ISDN, Part III: PAP Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we know how the ISDN link comes up (interesting traffic), and some scenarios that might cause the link to stay up, we need to look at ISDN authentication schemes. The two methods Cisco certification candidates must be familiar with are PAP and CHAP. Microsoft Great Plains Jewelry - Implementation & Customization Overview Each Industry and market niche has business specific and unique requirements to ERP/Accounting System. Microsoft Business Solutions Great Plains is ERP platform, ready for third party modules additions and customizations, plus being SQL Server-based system it opens you wide spectrum of integration options and tools. The Hidden Power of Online Manual Writing software manuals is boring, isn't it? We often think: "My software is easy to use. The user interface is intuitive. Microsoft Great Plains Project Accounting - Overview For IT Director/Controller Microsoft Business Solutions is now in process of creating so called Microsoft Suites: Microsoft Financials, Microsoft Logistics, Microsoft Manufacturing, Microsoft Professional Services - this last one will be based on Solomon Project module. The long story of Great Plains Software Project Accounting - it was originally created by MatchData, which was bought by Great Plains in late 1990-th and renamed into Great Plains Project Accounting. Microsoft Great Plains Reporting - Overview for Developer Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Ukraine IT Myths Dispersed While Ukraine is becoming a new popular IT outsourcing destination, there are still many myths about it and no clear understanding of the opportunities outsourcing to Ukraine can present. Let us look closely at some of those myths and find out whether there is any truth behind them. Microsoft Great Plains: Government & Non-Profit Organization - Workflow Implementation Usually workflow & messaging is realized in CRM and then transactions are just logged into Accounting/ERP/MRP. In the case of Microsoft Business Solutions products: Microsoft Great Plains, Navision, Solomon, Axapta the natural CRM choice would be Microsoft CRM. A Symons Mark II Function Point Counting Example I provide, here clear explanations and a count of function points, using the Symons Mark II method.We start by identifying the subprocesses (entry, exit, read, write) for each functional process; The size of a functional process is the sum of its data movements (entry, exit, read, write) and the size of a piece of software is the sum of the sizes of all of its functional processes. Fundraising Software - How Can That Help Me? Fundraising software lets you connect with donors in a way that is unlike any communication you've ever had before. You can diversify your fund raising efforts with software and manage all of your day-to-day activities. Huddle Up; Groupware on Three It could just be me, but my experiences with document collaboration remind me of a football game. It sounds crazy, I know, but working with a group and sending emails off to other members of the group caries with it that familiar uneasy sensation of Thanksgiving Day football games, where I often play quarterback and just as often wonder whether members of my family will catch the pass, and if they do, what they will do with the ball. Microsoft Great Plains: If You are Orphan Client - What to Do and FAQ Microsoft Business Solutions Great Plains, former Great Plains Software eEnterprise, Dynamics and Dynamics C/S+ is very popular ERP and since 1994 has been successfully implemented for mid-size and mid-size to large companies in the USA, Canada, UK, Australia, New Zealand, South Africa and Middle East. During the economic recession time 2001-2004 the majority of businesses cut to virtually zero their IT/computer support expenses and stayed with hardware and software. 10 Steps To Secure And Manage Your Passwords Passwords protect your most sensitive personal, financial and business information. They are the key to accessing membership, financial, and other web sites that you are a member of. Microsoft Great Plains customization - Freight Forwarding/Transportation industry example Microsoft Business Solutions Great Plains version 8.5, 8. 10 Things You Can Do With Photoshop CS2 That You Couldnt Do Before Now Is Photoshop CS2 worth the upgrade? You bet it is! Here are just 10 things you can do with this fantastic new version of Photoshop that were impossible (or difficult) to do with previous versions:1. Manipulate objects in the Adobe BridgeThis new generation of file browser enables you to look at photographs and artwork in detail before you open the file, process multiple Camera Raw images, flip through pages in PDF documents, size, rate and organise your work in a convenient and highly user-friendly way. Scrap Booking Online: Word Perfect or Corel Graphics Suite? Scrapbooks are very popular these days. I think that almost everyone wanted to capture family histories and stories in any which way they can. Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation At the end of XX century, in the late 1990th Great Plains Software eEnterprise was recognized as one of the leader on the midsize to large corporate ERP market. Due to the nature of eEnterprise architecture - it is Great Plains Dexterity based application and Dexterity imposes some specific to the database access and table structure - eEnterprise was subject to relatively inexpensive customization. Google Brings the Earth to Your Desktop Google Inc. has launched a new software package that allows you to see satellite images on your desktop. Five Reasons for Using an O/R Mapping Tool So, why should you use any O/R mapping tool? I am not talking about a specific tool but rather all O/R mapping tools in general. There are a number of reasons for using an O/R mapping tool but before I dive into that, let me give you a brief overview of what an O/R mapping tool really is. |
home | site map | contact us |