macmsl.dll error 1

[impress]

We are running 7.6.300b on sql and get this error on one of the machines (XP) while printing standard financials. error "the following error occured in macmsl.dll Timeout Expired"
I think this has to do with odbc connection timeout setting. Anyone know how to fix this? if i press ok on error i can continue pringing all the financial reports.

 

[NEmacGuy]

From Exact's InfoMine
Doc ID : 01.536.761
---------------------------------------------------------

Question:
Windows XP workstations have a wait or timeout state and never complete when printing large reports or data intensive processes in Progression. Other workstations such Windows 98 and Windows 2000 print the same reports with out hesitation. What could cause this issue?

Answer:
The default maximum number of ephemeral TCP ports for Microsoft Windows is 5000. To increase the maximum number of ephemeral ports you must set the following registry parameter:

WARNING: The incorrect use of Windows Registry Editor may cause serious problems that may require a reinstall of the Windows operating system. Exact Software cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Step1:

From Windows Start, Run, Regedt32.exe

Select, Hkey_Local_Machine\System\CurrentControlSet\Services\Tcpip\Parameters

From the Edit Menu, Select NEW, Select DWORD Value. Type the Value Name: MaxUserPort, select Enter.

Double Click on the new value name, MaxUserPort, from the Value window, select Decimal, set the Value data to 10000, select OK.

Step2:

From the Edit Menu, Select NEW, Select DWORD Value. Type the Value Name:TcpTimedWaitDelay, select Enter.

Double Click on the new value name, TcpTimedWaitDelay, from the Value window, select Decimal, set the Value data to 30, select OK

 

[edgare]

Thanks i will try that here is the text of error i had but I think your reg fix should fix it. Thanks again.

MSL Technical Error Info:

An error occured in MacMSL.dll (ver. 76.300.10.5)
DB Provider Error: Native Error number: 0
Error number: 0x80004005
Timeout expired
COM Error: Error
Code = 0x80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for SQL Server
Description = Timeout expired
Op : F3, fhWrite
Table or Script: [SQL-SERVER].[DATA_10].DBO.[STMNTWRK_SQL]

MSL Error Info:
Type: Error on insert..
Function: OpfhWrite.