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