Accpac slow posting time cards/invoices etc..

[mrkoko]

Hey, I'm new to accpac and this forum. I am running Sage Accpac ERP 100 version 5.4 and SQL Server on MS Server 2003. When posting time cards for example, from a workstation with accpac, the process is extremely slow (like 20 minutes to post a few records). If we do the same post but from the server station the posting is done immediately. Does anyone have any ideas ? Just a side note, the rest of our network runs Novell.

 

[Jay Converse]

Are you sure it's SQL Server? That sounds like a Pervasive problem.

 

[mrkoko]

Yep positive it's SQL server.

 

[Jay Converse]

If it's SQL2005, convert to the Native Driver, that will help.

 

[ettienne]

SQL server is slow in certain processes, especially posting transactions. You should try running some PJC functions or a Misys schedule on SQL, it is dearthly slow.

What version of SQL server? If you are using SQL 2005 then you can switch to the SQL 2005 Native Client and pick up some speed.

Do you get the same posting speed at all computers? It may be that the one posting the timecards is just a crappy one, the workstation determines the posting speed.

 

[mrkoko]

I actually now have found that I get the majority of the slow down only on one machine. The catch is that (hardware at least) the slow desktop for posting is the same config as one of the desktops that posts quickly.

How do I convert the the native SQL driver ?

 

[Jay Converse]

Well, you _think_ it's the same hardware, but it could be a lousy NIC, or a bad port on the switch.

If you don't see the SQL Native Client on the list of ODBC drivers, there's a client installer that comes with the database, or you can download it from Microsoft. Just delete your current ODBC name, and recreate it with the different driver.

 

[ettienne]

If you used the Server name in Accpac's Database Setup then delete the ODBC data source on the workstation, Accpac will automatically create a new one using the SQL Native Client, provided that:
1. You are running 5.4
2. You have installed the SQL 2004 Native Client
3. You have used the Server name in Accpac Database Setup
4. The user has rights to create ODBC data sources

 

[ettienne]

2. You have installed the SQL 2004 Native Client

Should have been:
2. You have installed the SQL 2005 Native Client