Search results for query: *

Alembic does make a utility that is painfully slow. I have used it and I am not impressed. Depending on your database size, it could take all weekend. In our environment this was not acceptable. My Exact consultant developed a SQL stored procedure to facilitate this. It is really slick and...

Run this query against the DB you wish to calculate file size. SET NOCOUNT ON /*DATABASE TABLE SPY SCRIPT Micheal Soelter 1/24/03 DESCRIPTION Returns TABLE Size Information SORTING USAGE @Sort bit VALUES 0 = Alphabetically BY TABLE name 1 = Sorted BY total space used by TABLE...

Use this query to find locked records in Macola. use msllockdb go select sessionid, tablename, rowid from maclocks exec sp_who greg

Open Ent Mgr and navigate to the tempdb. Right click and go to properties. You will want to increase the size of your tempdb. My tempDB is set to 512mb.

What do you mean by XP server? Microsoft has NT, Win2K Server, and Win 2003 Server. Are you running MS SQL? Also, what version of Macola?

Also, upgrade your clients to MDAC 2.8.

I may be wrong, but I think the exact-schema is for use with the item tables associated with Synergy not the item tables for use with inventory in MacolaES.

When you say XML server, do you mean the XML utility in MacolaES? You will need to use MS Access or a program like Data Junction. The best way to work this out is to create a new empty company and enter in an item manually. Then query the imitmidx_sql and look how Macola populated the...

Check out infomine doc# 00.936.663 on the customer portal.

You might have problems if you have custom page sizes, such as invoices or checks. Macola may not recognize the page size when it sends the command to the printer. They are many docs on printing on Exact's portal.

Vanessa, As long as you follow the directions you should be fine with upgrade process. The Pre_update is really the only added step. The issue is the individual workstations updates. Usually you will run into problems during the install process, typically fujitsu errors. Older machines will...

If you plan on upgrading to Macola ES, you will need to run MS SQL 2000 SP3 or SP3A. The install checks for this. Depending on user count, I would run at least 1 gig of ram in the SQL box. Are you planning on converting just your master data, or do you want to convert everything? This answer...

By the way, It will run on earlier version of Macola. I have it running on 103F.

The integrator will download customers back to Progression. The application works well. It uses XML to facilitate the data movement. There are some issues though. You want to make sure that your data is clean. For example the email field in the arcusfil_sql needs to be properly formated. If...

I think your problem is with the macdsn.dll. Yours is probably dated 5/29/2002. This is in your macsql/macola7x directory. You need the one dated 1/16/2001.

The hardware docs are ok and they are a good starting point. I usually base requirements per individual site. For smaller sites I usually suggest a single RAID5 setup with 3 disks. I do suggest 15k drives if money is not an issue. I view a smaller site to be 5-10 users. Over 15 users, I...

No problems with the Xeon processor. I notice more performance with split backplanes and 15k disks than with a processor upgrade.

My experience with this has been network issues, such as name resolution. Is there a delay when first browsing through the Macapps directory? Can you ping the server by name? Macola will be more likely to react to small network issues than some other applications. Things like network card...

There are actually two different downloads. The latest being dated 10/13/2003. Make sure you use the latest.

What authentication method is being use on SQL server? Make sure that it is set to mixed mode. Have you tried renaming the macola7.ini and the macola shared directory,then reinstalling Macola?