Connect to MAS 90 from ASP

By Todd Martin • November 8th, 2009

Sage MAS 90 ERP and Sage MAS 200 ERP have an e-Business application for users who wish to have an internet store for customers (B2B) and consumers (B2C). These are great, out of the box, applications if you want to keep your site simple and to the point. Most everything is configured through the accounting interface. HTML can be added in the descriptions to give the site a custom look without having to have a programmer develop your shopping cart. During the check out process it will charge the credit card with Sage payment services or PcCharge and all the transactions flow through the accounting system No import or export. It is really a great application but like I stated before it is a very basic, out of the box, solution.  It lacks in Search Engine Optimization (SEO), Suggestive Selling, Social Media Links, Tell a Friend/E-Mail info, PDF of page, Human Readable URLs, and many other features and functions that most of today’s commerce websites have.

Due to this limitation of the basic out of the box solution, customers have:

  1. Modified the built in e-business templates with HTML code to create some of these functions.
  2. Export to SQL or Access and develop a website accessing the data from those applications and importing into sales orders.
  3. Customize the ProvideX code that the application is written in.
  4. Wrap e-business within another site.
  5. Create a site using ASP to read ODBC direct from the application. Then importing or filling in the shopping cart for the user to check out using built in function.

There might be combinations of the above list or others that I have not listed. MBA was working with a client trying to create the ASP read from ODBC and we realized that there were a few people out there trying to figure out how to do this. This blog will document a few key elements needed to read from the ODBC driver using ASP. This is for version 4.x or greater.  Hopefully this will help others trying to do the same thing. This is not meant to be the only way to do it nor the correct way to do it. It is just one way that we did it and it worked.

MORE INFO

Links: MBA Business Software – ASP Web Applications accessing MAS 90

  • Share/Bookmark
Comments(0) Sage MAS 200, Sage MAS 90

This website uses IntenseDebate comments, but they are not currently loaded because either your browser doesn't support JavaScript, or they didn't load fast enough.

 

Leave a Comment

You must be logged in to post a comment.

« | Home | »