Article ID: 912960 - View products that this article applies to.
This article describes how to upgrade an application that uses the Crypto.dll file so that it instead uses the GPConn.dll file or the GPConnNet.dll file in Microsoft Dynamics GP. The Crypto.dll file works only with versions of Microsoft Great Plains that are earlier than version 9.0.
Microsoft Dynamics GP 9.0 and 10.0 include a change in the password policy that affects Dexterity in Microsoft Dynamics GP and also affects the Crypto.dll file. Therefore, you must replace code that calls the Crypto.dll file by using code that calls the new GPConn.dll file or the new GPConnNet.dll file.
To enable integrating applications to connect to the SQL database by using logon credentials for Microsoft Dynamics GP users, two additional software components are provided: GPConn.dll and GPConnNet.dll. The GPConn.dll component provides COM and Win32 interfaces to create a database connection. The GPConnNet.dll provides a Microsoft .NET interface to create a database connection. Both components take logon credentials for a Microsoft Dynamics GP user in plain text format and return a connection to the database. Both .dll files require that registration keys be passed into them. Because these keys must be generated for your organization, you must open a Dexterity support incident to request keys for the new .dll files. You will not be charged for the initial support incident to request the keys. However, you may be charged for any additional support incidents about how to implement a solution. You will also receive documentation for the .dll file that you need.
If you are specifically using either of the .dll files from Visual Basic for Applications (VBA) or from VBScript in Integration Manager, the best integration option is to use the RetrieveGlobals9.dll file that is available on the Mod/VBA samples pages. In these situations, download the updated RetrieveGlobals9.dll file instead of requesting keys for the GPConn.dll file or the GPConnNet.dll file. To download the RetrieveGlobals9.dll file, visit the following Microsoft Web site:
https://mbs.microsoft.com/partnersource/documentation/howtoarticles/modifiervbasamples90.htm?printpage=falseYou can open a Dexterity support incident to obtain help that is unavailable in the documentation. You will not be charged for the initial support incident to request the .dll files. However, you may be charged for any additional support incidents about how to implement a solution.
For more information about the new connection objects in VBA that replace the RetrieveGlobals.dll and RetrieveGlobals9.dll files in Microsoft Dynamics GP 10.0 , click the following article number to view the article in the Microsoft Knowledge Base:
936115For more information about technical support options for Microsoft Business Solutions partners, customers, and ISVs, visit the following Microsoft Web site:
(http://support.microsoft.com/kb/936115/ )Information about the new connection objects in VBA that replace the RetrieveGlobals.dll and RetrieveGlobals9.dll files in Microsoft Dynamics GP 10.0