Register Domain Name - Web Hosting Registration Services

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 ON SET 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 1 OLE 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 ARTICLES:

Cheap Internet Hosting, Business Web Hosting - Choosing The Right Web Host Package
With literally hundreds of web hosting providers competing for your business, it may be confusing to find the one that's right for your web site. A few key considerations can help you narrow down your choices to the most affordable and best options to meet your personal, professional or business web page needs.

Website Domain Name Registration Services from Access IT Solutions
Before you start building a website, choosing the right domain name is an important thing to do. Website domain name registration is necessary to have a website. The names are important because they enable clients or potential customers to know about your business or organization.

The Steps Of Web Hosting Domain Registration
For the many millions of people who have decided to keep pace with the growing popularity of the Internet by launching their own website, they are faced with a variety of decisions necessary to make the most of their online presence. After deciding the nature and content of your website you must then tackle the decisions associated with web hosting domain registration.

Website-Hosting-Offers.com Launches to Compare Leading Web Hosting Providers for Small Businesses
Website-Hosting-Offers.com announces the launch of a website featuring a select group of top web hosting providers, including reviews and side by side comparisons of all web hosting plans from these providers. Web hosting providers reviewed include Yahoo Web Hosting, 1&1 Web Hosting, iPowerWeb Hosting, and more. Site visitors can get informative web hosting reviews and articles that cater to everyone from beginning website builders to more experienced small business owners upgrading to a new web hosting plan.

Web Hosting And Domain Registration Basics
Web Hosting

Start Your Home Base Business With A Domain Name And Web Hosting
So you want to start an internet business where you can work at home and make tons of money The first part is easy to do

DiscountASP.NET Expands Global Reach for ASP.NET Web Hosting Services with European Data Center
DiscountASP.NET, a leading innovator in ASP.NET hosting, announces expanding their global reach into Europe with a new data center location in London, UK.

Web Hosting Service – What you Need to Know to Change Web Hosting Providers
When service at your web hosting company is lacking, or your web site grows in traffic so much that you outgrow your current account, you may find yourself needing to change hosting providers. It can be scary to think about everything you need to do.

Nexx Cuts Price on .com Domain Names Web Host Offers Exceptional Value on Domain Names
Nexx Online Inc., an innovative North American web host and ICANN Accredited domain name registrar, today cut the price of their .com, .net, .org, .info and .biz domain names to only $7.95 per year.

The Advantages Web Hosts Receive By Switching to ASP.NET Reseller Hosting
Many linux hosting resellers might find advantages of changing to a hosting service that sells Windows server hosting over Linux. While Linux is a very popular hosting solution, Windows offers multiple advantages that would benefit a number of customers. For this reason, it can be a very good product for hosts to resell.

Domain Name and Web Hosting Hell
Does GoDaddy really suck?I am in the process of registering more and more domain names so it seems natural to look for the best pricing deal.Registering multiple domain names can add up quickly, especially if you register both the NoDashVersion.

Domain Names and Web Hosting
Experienced webmasters know the value of a good and "sticky" domain name. Ever since Google started ranking higher and giving more weight to web sites which use relevant keywords in the domain name. A clear example can be seen after running a quick search using the term "SEO".

Internet Domain Registration – Top 10 Most Frequently Asked Questions on Domain Name Registration
Here are the top ten most frequently asked questions regarding on Internet domain name registration:Q1. Which characters are allowed in Internet domain names?A: For normal ASCII domain names, the letters a-z, the numbers 0-9, and one special character, the hyphen or dash "-".

Free Website Hosting Vs. Paid Website Hosting Basics
Web site hosting service companies on the Internet permit the user to make their web site accessible through the World Wide Web. There are huge numbers of companies that offer web space on their server for their customers and also offer Internet connectivity in general in a data center. There can be various types of web site hosting companies. The main classification is the free web site hosting and the paid web site hosting service companies.

The dos and don'ts of web hosting and domain names
When you make the decision to start a website for your business, it is a big step. Going from the world of offline business where clients are limited to geographical locations to online where the entire world is a potential client can be overwhelming.