Easy Sell Internet Info
Home  |  About  |  Articles  |  Reports  |  Links  |  Site Map    
Welcome to Easy Sell Internet Info!
Technology Articles
•
•
•
•

Home
:: About Us
:: Contact Us
:: Article
:: Reports
:: Links
:: Site Map

Related Links

Microscopes

Powered Roller Conveyors

Chain Conveyors

It Consultants London

Rack Pc
Navision Attain Database access via C/ODBC in ASP.NET Application
By Boris Makushkin


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 Files\Navision Attain\Client\database.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

For more information about this article and/or the author visit http://asp.net/webmatrix

For more information, news and articles see:

Pallet Conveyors - Pallet Conveyors
...s pallet conveyors at the local factory. He has to make sure that the pallet conveyors are working property as well as using them to ensure that they do their job properly. Although his job is not v...
Visit Pallet Conveyors...

It Consultants London - It Consultants London
...ve service and they`ll be able to find suitable solutions for companies that will be perfect for their needs. it consultants london can help to support existing systems or can recommend what types of...
Visit It Consultants London...

Cr2032 Battery - Cr2032 Battery
...ess the open button nothing happens and you now have to manually use the key to access the building. Chances are the cr2032 batteryhas stopped working within the unit. Batteries of this nature do ha...
Visit Cr2032 Battery...

Prototype - Prototype
...o move your product forward you`ll find companies like Thompson Precision can do precisely that. They have been working in the engineering business for many years know and they can help you to produc...
Visit Prototype...

Small Pc - Small Pc
...g PC`s that used to take up half of your desk. Today with a Small PC you can reclaim valuable desk space, also a Small PC looks a lot neater than its contemparory full sized cousins. Not that you ha...
Visit Small Pc...

Bluetooth Earpiece - Bluetooth Earpiece
... Earpiece and says that it has really made a difference to her life. Before she got the Bluetooth Earpiece she had to carry her phone with her everywhere and often, she told me that she would end up ...
Visit Bluetooth Earpiece...

Computer Network Support - Computer Network Support
...hen it comes to networks the chances are you`ll need some form of computer network support to help with your company`s systems. Larger organizations tend to have their own IT techies who know all the...
Visit Computer Network Support...

Solid State Relay - Solid State Relay
...Every day our well established company ship hundreds of thousands of Solid state relay switches all over the world. Solid state relay is a fairly new invention in the engineering world, but it is an ...
Visit Solid State Relay...

Embedded Computers - Embedded Computers
...ready to start work straight away so companies can benefit from their technology right from the start. The world wide-web is the place to look for new embedded computers because on the internet there ...
Visit Embedded Computers...

Pre Term Fibre - Pre Term Fibre
...erm fibre in offices around the city centre of Manchester. He really enjoys his job, particularly because installing pre term fibre means that he gets to travel around the city every day going to dif...
Visit Pre Term Fibre...

Test Automation Tools - Test Automation Tools
... Automation Tools are the software or programs used in the performance testing of software automatically. Test Automation Tools actually control the execution of tests, the comparison of actual end pr...
Visit Test Automation Tools...

Fibre Patch Leads - Fibre Patch Leads
...tch Leads can make much better alternatives as they are far lighter that their copper colleagues. What`s more, Fibre Patch Leads can be easier to install than copper leads and anyone who works within...
Visit Fibre Patch Leads...

Hard Drive Disposal - Hard Drive Disposal
...re outdated and you have just placed a large order for state-of-the?art replacements. This presents you with a problem as you have information stored on the hard drives of the computers that needs to...
Visit Hard Drive Disposal...

Exhibition Services - Exhibition Services
...ies who want to put on exhibitions in various locations up and down the country. The exhibition services they offer cover a wide range of things from stands to personnel to make sure the exhibition ...
Visit Exhibition Services...

Epos Tills - Epos Tills
...t fashion superstore the other day to get some cheap clothes for myself and my family to take on our annual summer holidays. There are some amazing bargains to be had in shops like this and it really...
Visit Epos Tills...

Exhibition Stand Design - Exhibition Stand Design
... just a case of throwing together a couple of tables, plonking a Television and VCR on top and blue-tacking some posters to display boards at the back. A thoughtful and professional Exhibition Stand ...
Visit Exhibition Stand Design...

Air Conditioning Hampshire - Air Conditioning Hampshire
...s become a little unbearable and for offices in the South of the county, air conditioning hampshire can be ideal. Currently plenty of offices that are South of the border are benefiting by having air...
Visit Air Conditioning Hampshire...

Reed Switch - Gettign The Right Reed Switch
...ing case. Within this case, these blades are held a particular distance apart while the case protects the contacts from corrosion because outside air can`t reach inside. The contacts extend outside th...
Visit Reed Switch...

Software Engineer - Software Engineer
... and polishing it, as if it were a wooden sculpture, not a series of logic instructions. The problem here is that you cannot engineer art. Programming falls somewhere between an art and a science....
Visit Software Engineer...

Computer Training - Computer Training
...rs are here to stay and plenty of people have come to rely on them over the past few years. Imagine not being able to surf the web when you liked or type word documents as part of your daily duties? ...
Visit Computer Training...

Industrial Ethernet Switch - Industrial Ethernet Switch
... the Industrial Ethernet Switch from Korenix is ideal in dusty or dirty scenarios. Information won`t be interrupted at all when this type of switch is in action and you can imagine that the services ...
Visit Industrial Ethernet Switch...

Restaurant Tills - Restaurant Tills
...e to view the Restaurant tills. Obviously, if you are in a high street burger chain then the Restaurant tills are one of the most obvious features in the room with a plethora of people to take your m...
Visit Restaurant Tills...

Telescopes - Telescopes
...ey will be able to answer all queries. To gaze at the stars powerful Telescopes are used and they can help people of all ages look into the night sky. It`s a fascinating hobby and novice astronomers...
Visit Telescopes...

Network Cabling - Network Cabling
...rk cabling know how important it is for their customers to have the cables installed on time and within the set budgets. Whether the network cabling requirements are for fibre optic, electrical or ...
Visit Network Cabling...

Automated Software Testing - Automated Software Testing
...ftware testing is a test method conducted to gather the information about the quality of the product or service and the performance of the same. Software testing also find out whether the objective of...
Visit Automated Software Testing...

Clive Roberts - Clive Roberts
...Clive Roberts worked as the lead developer on a VB6 project to deliver a front-end application to Local Government. Councillors used the application during their `surgeries` with the public to record...
Visit Clive Roberts...

Meade Telescope - Meade Telescope
... things to do with stars. At first my parents thought it was quite a strange hobby for him to get into but, over the years, his dedication to the field has really made them quite proud of him. Last ...
Visit Meade Telescope...

Syma Spare Parts - Syma Spare Parts
...lled Apache helicopter and since Christmas he`s managed to master the controls. When he first got the machine he did struggle at first learning how to control it in a smooth manner. Due to this the ...
Visit Syma Spare Parts...

3d Building Rendering - 3d Building Rendering
...heir disposal today which they can use to market potential developments. They no longer have to use rather dreary plans to promote their schemes; they can use a 3d Building renderingservice instead. ...
Visit 3d Building Rendering...

Cisco Training - Cisco Training
... you always wanted to work with computers but you haven`t got the right qualifications to make it happen? Don`t worry if you find that your qualifications fall short of the mark because there are tra...
Visit Cisco Training...

Police Earpiece - Police Earpiece
...what they`ll be facing when they report for duty. One day they could be stopping motorists to check their vehicles and the next they might be arresting somebody for shoplifting. It`s vital that the ...
Visit Police Earpiece...

Rack Mount Pc - Rack Mount Pc
... the moment and you are looking at ways that you can create a little extra space for your workers. You have toyed with the idea of installing rack mounted computers that could be the ideal solution t...
Visit Rack Mount Pc...

Cnc Turning - Cnc Turning
...ys a workshop might still be involved but a machine will carry out the process. Moreover, the machine will be receiving its instructions from another machine. A computer will send detailed instructio...
Visit Cnc Turning...

Hard Drive Destruction - Hard Drive Destruction
... would happen if information that was stored on your company`s hard drives fell into the wrong hands? Your competitors would have a field day with their newfound knowledge and your business would suf...
Visit Hard Drive Destruction...

Cat5e Cable - Cat5e Cable
...is an industry standard type of manufactured cable used to create computer and telephone networks. Computer networks can be found in office buildings throughout the world and most of them will be equi...
Visit Cat5e Cable...

Air Conditioner - Air Conditioner
...els like we have had a summer this year what with all the rain we`ve had so far. June was indifferent, air conditioner July was a washout and August is proving to be a bit hit and miss....
Visit Air Conditioner...

3d Images - 3d Images
...n fully briefed on the property brochure we were producing for a well known developer, having just six months to get the whole thing done in time for the launch of the new estate the pressure was on a...
Visit 3d Images...

Lineshaft - Lineshaft
...chase a lineshaft for your business you want the very best. Whether you require one for simply moving objects from A to B, for use on production or packaging lines and even on order picking stations,...
Visit Lineshaft...
Click For More Detailed Information on:
best placing to you ::future testing ::uses computers ::religious technology ::your plasma for you ::mean science pro ::technology external ::my application 4 u online ::future anyway ::best technology thought
Home  |  About Us  |  Contact Us  |  Articles  |  Special Reports  |  Links  |  Site Map
Copyright © 2003-2012. All Rights Reserved.


Valid CSS!