Microsoft Dynamics GP (Archived)

Can GP 2015 and GP 2010 properly co-exist on a WIndows 8 machine?

(0) Share

Report

Posted on by Tim Foster

8,515

After installing GP 2015 on my Windows 8 box, the GP 2010 client now produces VBA errors.

The error seems to be related to VBA no longer being able to set up an ADODB record set properly.

We reinstalled VBA components and MDAC 2.8 SP1. We reinstalled GP 2010. None of these worked.

I have searched for a solution and found none so far.

Thanks

TIm

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Where is the VBA error generated from? Just general access? Specific task or screen you are opening?

Guessing that GP2010 was working on the Windows 8 box first?

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (0)

Report
Copy link

Link copied!

This issue is related to these threads:

community.dynamics.com/.../148121.aspx

community.dynamics.com/.../150038.aspx

My VBA in GP 2010 is broken and it looks like GP2015 is broken too.

Will there be a fix forthcoming from Microsoft?

Wishing I was going to Convergence so I could open a ticket.

TIm

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

We have faced the exact same issue recently with Windows 8.1 and we could not find a solution yet.

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (0)

Report
Copy link

Link copied!

Have you filed an incident with support yet?

We did a "bare metal" install of GP 2015 to a fresh VM and it is still broken.

Is there a defect number to reference?

Tim

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report
Copy link

Link copied!

Not yet,

We might raise that in the convergence.

I will keep informed,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Regards, Mr. Tim!.

Could you post a screenshot of the error? If detailed the better. Possibly in Windows 8 (I have problems in Windows 7) Was there a replacement or upgrade Bookseller referred to IAQAADOConnection object.

In my case, I keep installed SQL Server 2012 and 2014. Dynamics GP 2010 GP in 2012 and 2015 in 2014. Different folders, other ODBC but again, it is in Windows 7.

I assume by now that the call to the connection string was altered and thus, you can not run.

Happy day.

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (0)

Report
Copy link

Link copied!

I don't think this will be particularly helpful, but here is what you asked for:

If you are experiencing this problem, you should be seeing the same thing.

This code is taken straight from the VBA developer's guide:

Public Sub foo()

Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim CoName As String

CoName = UserInfoGet.CompanyName

Set cn = Nothing
Set cn = UserInfoGet.CreateADOConnection

End Sub

The code errors on
Set cn = UserInfoGet.CreateADOConnection

I am opening a support issue.

Tim

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report
Copy link

Link copied!

Tim be sure to post what you get back from Microsoft - I have feeling you are not the only one with the situation or will not be the last at any rate.

Take care.

Was this reply helpful? Yes No
Verified answer

Tim Foster 8,515 on at

Like (0)

Report
Copy link

Link copied!

Confirmed by Microsoft Tech Support: Known Defect.

No workarounds.

Must wait for March Hotfix.

Tim

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Regards, Mr. Tim Foster.

In my case, if I was useful representation said, reiterating that had not yet seasoned with error for not having VBA solutions that incorporate business objects (mostly used for VS SDK Tools).

I confirm that fomented a possible workaround in another similar topic as it was closed.

Appreciate your collaboration.

Goodbye cordially.

Was this reply helpful? Yes No