From the GP Blogs: How to Access Data from Other Companies from Dexterity, How to Fix Cannot Open Database Error, How to Customize Navigation Lists, Review of Microsoft Dynamics GP 2010 Cookbook: LITE

How to Access Data from Other Companies from Dexterity: David Musgrave from Developing for Dynamics GP shares the necessary steps and sample Dexterity code to read data from a company other than the current Microsoft Dynamics GP company: "Well, with my latest updates to the Support Debugging Tool, I came across this requirement. While developing the support for the Extender security objects, I realised that the Extender objects are stored on a per company basis and to obtain the descriptions for the various objects I would need to read the tables in companies other than the one currently logged into. I knew the method and so was able to implement this functionality, but I thought that it would make a good blog post in case others need to achieve a similar goal."

How to Fix "Cannot Open Database" Error During eConnect Adapter Integration: Mariano Gomez, the Dynamics GP Blogster, walks us through the step-by-step solution for an error experienced during integration: "Just recently, I was helping a client building a Fixed Assets integration. The requirement called for importing a number of asset records and have a method that could be reused as new assets are added to the organization's 15 different locations... that's the easy part! We were getting ready to run our first integration when the dreadful error came up: "ERROR: System.Data.SqlClient.SqlError: Cannot open database ‘XYZAB' requested by the login. The login failed"... The most likely cause of this error message is a problem with the eConnect COM+ configuration."