Need information about ASP page VS Macola

[DavidGecko]

Hi!
I'm a web programmer and I'm trying to developp an ASP web site connected to Macola Software. I don't really know Macola and I have some questions :

1- In an ASP, I can connect my page with SQL Server or Access with ODBC and SQL language but, with Macola, can I do this ?

2- I'm looking for technical information about Macola software. I know SQL Server but Macola isn't it just a database right? How is Macola organized? Are there tables, fields that I can question like Sql Server or Access? If yes, Can I do it with Sql language ?

Thank you very much for your help!
David

 

[vbajock]

Macola is claims to be an ERP, but it is basically a financial accounting package with Manufacturing and Master Scheduling and a lot of other add-on modules available that you can cob into an integrated system of sorts. Macola has two available database engines. One version is based on Pervasive P-SQL, the successor to Btrieve. The other is based on MS Sql Server. There is also an ancient version, Macola 6x, still in wide spread use that uses any number of Btrieve backends. Both the PSQL and MS Sql versions work reasonably well with OLEDB or ODBC connections using ADO or ADO.net. ANSI Sql works well with PSQL, TSql of course is appropriate for SQL server. The database layouts for both versions are available on their web site, macola.com, but you need a log in to get them. Logins are supplied to licensed users of Macola. Some of the contributors to this forum also have this documentation.

 

[DavidGecko]

Thanks for your help! With this information, it's possible to linked an ASP page to show some products content in Macola, right ?

If some of the contributors to this forum have more information or documentation, i'm taker.

Thanks again!
David

 

[vbajock]

Yes

 

[dgillz]

David,

What are you going to do with your ASP? Macola has a weborders product which works reasonably well, but only on a MS SQL Platform. There are also a couple of third party solutions out there that work with and/or generate a web page from Macola data tables.

Please let me know if you need more info on these guys. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[DavidGecko]

Hi dgillz!
I developp a web site for a client. He wants to show and sell his products on his web site. My client has all of his products informations in Macola. So, I want linked my ASP page to show some products content.

Thanks for your help!
David

 

[MacolaHelp]

Global Software Solutions uses the asp methodology to link to the macola db from their MacWeb product. You might want to try their solution rather than re-invent. It works on both psql & sql & they actually have installs running successfully & have reference sites. Last time I tried to get reference sites on macola web orders/views, I had no luck.