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:
You 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:
Information about the new connection objects in VBA that replace the RetrieveGlobals.dll and RetrieveGlobals9.dll files in Microsoft Dynamics GP 10.0
For more information about technical support options for Microsoft Business Solutions partners, customers, and ISVs, visit the following Microsoft Web site: