Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. grossow

    Item Number Help

    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...
  2. grossow

    Macola File Sizes SQL

    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...
  3. grossow

    Item Locked causing orders to Lock.

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

    Help with log file??

    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.
  5. grossow

    XP Server Install Instructions

    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?
  6. grossow

    upgrade to sql2K can't login to Macola

    Also, upgrade your clients to MDAC 2.8.
  7. grossow

    XML or SQL Item Import

    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.
  8. grossow

    XML or SQL Item Import

    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...
  9. grossow

    Creating a Backup Company

    Check out infomine doc# 00.936.663 on the customer portal.
  10. grossow

    Upgrading to 7.6.200

    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.
  11. grossow

    Upgrading to 7.6.200

    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...
  12. grossow

    upgrading to 7.6.300

    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...
  13. grossow

    E-synergy and Macola Progression

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

    E-synergy and Macola Progression

    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...
  15. grossow

    Error getting DNS name when starting PWE

    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.
  16. grossow

    SQL hardware advice

    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...
  17. grossow

    Pentium XEONs

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

    Some workstation issues in 7.6.1

    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...
  19. grossow

    Printing Issues in 7.6.200GR Download

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

    PWE Login Error

    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?

Part and Inventory Search

Back
Top