RuthO 12/12/2008 3:26:19 PM

Method 'CreateADOConnection' of object 'DUserInfo' failed

This is actually a VBA error, not VS Tools, but I ran across it and didn't want to lose it. Not suprisingly, David Musgrave provided the answer.

Method 'CreateADOConnection' of object 'DUserInfo' failed

I have upgraded a client from GP9 to GP10 and have replaced
retrieveglobals9.dll with UserInfoGet in the VBA code.  This works 100% when
logging in using the user 'sa' but give the following error when logging in
using any other user :-

Method 'CreateADOConnection' of object 'DUserInfo' failed

Below is the code I am using :-

Dim cnn as new ADODB.connection
Dim cmd as new ADODB.command
Set cnn = UserInfoGet.CreateADOConnection
cnn.DefaultDatabase = UserInfoGet.InterCompanyID
cmd.ActiveConnection = cnn

Please could anybody give me advice on what to do?

Thanks a lot




Version: GP 10
Section: Visual Studio Tools for Dynamics GP

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables