Navision attain list approach via c/odbc in asp.net concentration - software
Navision Software was purchased by Microsoft and now it is supported by Microsoft Affair Solutions at once with Microsoft Great Plains, Axapta, Solomon, Microsoft Retail Management Arrangement and Microsoft CRM. Navision has enormously bright arrangement on mid-size European and US markets, plus it has exceptional manufacturing solution. Our goal is to help IT departments to assist and tune Navision with in-house expertise and skills. The topic of this commentary is Navision file contact from ASP. NET claim via C/ODBC interface. Our goal will be ASPX page accessing Navision Customers.
1. In our case we will use Navision Attain 3. 6 with Navision File Server, Navision Attention Attendant and Navision Client. These gears are installed on Windows XP. You also need to bed in C/ODBC element form Navision Attain CD.
2. Let's coin ODBC DSN for Navision data access. Choose Be in command of Panel -> Administrative Tools -> Data Sources (ODBC). Then decide on Arrangement DSN tab and press Add button. We'll use C/ODBC 32-bit data approach driver. We'll name Data Font Name Navision, Correlation leave Local. As the file (Database button) cliquey Curriculum FilesNavision AttainClientdatabase. fdb (demo database). Then click Business close - we'll use CRONUS demo company. It is chief for C/SIDE accurate folder contact to setup appropriate options for C/ODBC connection. Press Options close and look at the options obtainable - we'll need Identifiers parameter - it defines identifiers types, which will be transferred to the client application. In order to work accurate with MS SQL Attendant 2000 with C/ODBC basis we need to use these type: "a-z,A-Z,0-9,_". Now DNS is done. Let's conceive Allied Server.
3. Open MS SQL Attendant Activity Manager. Open attendant tree for the server, which you plan to use, for this head waiter open Collateral folder and Lined Servers. With right click choice New Coupled Head waiter in circumstance menu. In the dialog box opened in the Giver Name decide on Microsoft OLE DB Contributor for ODBC Drivers. Let's name our Allied Ma?tre d' NAVISION. In Data Basis filament enter ODBC DSN name - NAVISION in our case. Associated Ma?tre d' is ready! Let's choose tables list and look at the data from Navision Attain database.
4. Next we need to build small stored course of action for sales data selection. Here is the text of the procedure: SET ANSI_NULLS ON SET ANSI_WARNINGS ON GO
CREATE Method NavisionCustomers AS
DBCC TRACEON(8765) SELECT No_, Name, Address, City, Acquaintance FROM OPENQUERY(NAVISION, 'SELECT * FROM Customer')
Let's filter some points here. TRACEON(8765) directive allows us to work with the data of alterable length, returned by C/ODBC driver. Devoid of it we can not decide on Navision tables fields - we will have these errors:
OLE DB error trace [Non-interface error: Unexpected data chunk 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 donor 'MSDASQL' returned an unexpected data duration for the fixed-length feature '[MSDASQL]. Ship_to_Filter'. The predictable data extent is 250, while the returned data chunk is 1.
OPENQUERY be in charge opens coupled ma?tre d' and gives it execution request, and takings background set selected. Directives ANSI_NULLS and ANSI_WARNINGS are compulsory - they endow with the leeway of the execution for diverse requests. To test the method you can give its name in MS SQL Query Analyzer - EXEC NavisionCustomers
5. Now we need to build ASP. NET application. Let's use free RAD background ASP. NET WebMatrix. You can get infor and download it at http://asp. net/webmatrix . You need . NET SDK 1. 1 installed, beforehand WebMatrix installation.
6. Launch WebMatrix, choose construction of the Data Pages -> Editable Data Grid in the wizard screen. Let's keep all the defaults suggested. On the admittance page bent we'll alteration the heading to Navision Attain Customers, cliquey Verdana font and the font size desired. Next place on the page the element SqlDataSourceControl and tune it's - Association Cord : server='(local)'; database='Alba';trusted_connection=true (change head waiter and catalog name to your concrete names), and SelectCommand - as EXEC NavisionCustomers
7. For our Data Grid, which will show customers, characterize DataSource as SqlDataSourceControl1, and DatKeyField - as No_
8. Next alter to code copy mode and make these changes:
? In the DataGrid_Delete logic let's adjust the ask for for the consumer deletion to the one we need
? Change DataGrid_Delete code, base on the fields we plan to use
9. Launch our appliance 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 generally Microsoft CRM, Microsoft Great Plains customization company, helping Chicago, Boston, San Francisco, San Diego, Los Angeles, Houston, Dallas, Atlanta, Miami, Montreal, Toronto, Vancouver, Moscow, Europe and worldwide ( http://www. albaspectrum. com ), he is Microsoft CRM SDK, Navision, C#, VB. Net, SQL, Oracle, Unix developer.
Best Practices In Choosing Association Monitoring Software
Blue Cross and Blue Buffer of Hawaii (HMSA) found itself with a fast getting bigger association and data center. Our exchange ideas devices, servers, and software were all developing in density and we knew that we would have to power knowledge to gain advance be in command of of our IT systems and network.
Microsoft CRM and No-Frills Cadillacs
In today's big business world it's all but hopeless to avoid Microsoft. Any you're using MS applications, budding your own, or negotiating your company's acquisition by this techno-behemoth.
Twelve Effects You Be supposed to Know to Save on Mainframe Software
Do you want to get characteristic software at a acceptable price? Whether you work at home or just need good software for your own computer, you are faced with an approximately endless choice of central processing unit software. Organization because of the options can from time to time be a major task.
How to Make Own CMS
Every day millions of new web credentials emerge on the Internet, and the sum of web management tools is emergent simultaneously. These tools are as a rule referred to as Contented Management Systems, CMS for short.
Call Alert Notifications - Free Answering Android Software for PCs
If you're online using a dialup Internet connection, you'll in all probability want to download one of the free call alert software applications like Callwave or AOL Call Alert that can answer, record, and advance incoming calls to your home, bureau or cell phone. In fact, if you run a small business, Call Wave also offers a devoted commerce fax ceremony too.
Microsoft Great Plains: If You are Soul Client - What to Do and FAQ
Microsoft Big business Solutions Great Plains, earlier Great Plains Software eEnterprise, Dynamics and Dynamics C/S+ is very all the rage ERP and since 1994 has been effectively implemented for mid-size and mid-size to large companies in the USA, Canada, UK, Australia, New Zealand, South Africa and Center East. At some point in the financially viable depression time 2001-2004 the best part of businesses cut to in effect zero their IT/computer aid expenses and stayed with hardware and software.
5 Easy File Management Tips in Microsoft Word
How many steps does it take you to locate and open your Word documents? Try these tricks to rationalize how you find and open the files you use most often:Opening DocumentsWith a category of choices, how do you open a file? Here are the principles plus a number of the ivories shortcuts:? File > Open? Open toolbar close (usually 2nd from the left on the Accepted toolbar)? [Ctrl] + O? [Ctrl] + F12? [Ctrl] + [Alt] + F2Selecting More Than One FileOnce you are in the Open dialog box, choose more than one file to open:? To decide on nonadjacent files in the Open dialog box, click one file, and then hold down [Ctrl] and click each bonus file.? To choose adjacent files in the Open dialog box, click the first file in the sequence, and then hold down [Shift] and click the last file.
Spyware Protection: A Must for Any Home Computer
Now that spyware is the free most precarious danger to home computers coupled to the internet today, being paid your hands on some sort of spyware and adware defense is critical. Spyware has outpaced laptop viruses in its prevalence, and in the kind of dent it can do to your system.
New Web-Based HR Tool is Max From NAS, Hannibal, and InfoLink
Three abundantly respected names in Human Funds have fixed armed forces to endow with companies with a revolutionary blend of military that make the hiring course more cost-effective and effective. The business joins three companies: NAS Recruitment Communications, a acknowledged director in the expert field of human store communications, Hannibal, Inc.
The Religious conviction And Thinking Of Small Internet Business
I have at all times had a bias to focus on the positive. We, all of us, know the denial information in circle and governments.
Microsoft CRM Customization - Giving out In/Out-Going Email Messages
We would like to give you more than a few situations, when you may need custom advance and training to build up Microsoft CRM functionality. This overview is for programmer, software developer, IT specialist, folder administrator.
Microsoft Great Plains GL: All-purpose Ledger - Overview For Consultant
Microsoft Big business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be by far localized). Great Plains Catalog check is appealing robust and here we would like to give you highlights on average functionality as well as what could be added to its accepted features.
Free Software - Able Alternatives to Budget-Busting Software
When you buy a computer, it most possible comes with Microsoft Windows preinstalled. And when you need a word processor, spreadsheet, or other software, you in all probability buy it from a laptop store.
The Death of Windows
I have all the time regretted how Microsoft price gouges and rips off cpu users. I actually be disappointed Windows XP activation.
Preventive Maintenance Software Companies
Several software companies aim programs for precautionary maintenance. Most of the defensive maintenance software companies be the source of programs for conveniences and businesses.
Microsoft Great Plains customization - Cargo Forwarding/Transportation activity example
Microsoft Affair Solutions Great Plains edition 8.5, 8.
Mozilla Vs. Firefox
For those who are doubtful on the differences concerning the Mozilla box (Netscape is also analogous to Mozilla aside from they're two altered companies) and Firefox / Thunderbird, here it is: Mozilla is a absolute container gist it comes with email, browser, concentrate on book, newsgroup, and chat applications integrated.FireFox is a stand-alone browser application.
Great Plains Ability Customization Options - Overview For Developers
Looks like Microsoft Great Plains becomes more and more popular, fairly since of Microsoft muscles at the back of it. Now it is beleaguered to the whole spectrum of horizontal and vertical promote clientele.
MultiNational Corporation ERP Implementation - Microsoft Affair Solutions Great Plains
If you look back to the history, you will see that ERP for large in public traded circle had to be built upon very dependable hardware (more expected non-Intel hardware: mainframe, Sun sparc, etc.), brawny folder platform: Oracle, DB2, Ingress, Sybase and trustworthy OS: UNIX.
Cisco CCNA Certification: Befitting A Truly Costly CCNA.
I've been dynamic in the Cisco Guarantee track for four years, running my way from the CCNA to the desirable Cisco Expert Internetwork Knowledgeable title, and for the duration of that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates. The CCNA is an exciting establishment to your Cisco career, but just having the official recognition basically isn't enough.
|home | site map|
|goldenarticles.net © 2018|