VBA Snippets: Adding an SQL ODBC Connection in Microsoft Dynamics GP

MicrosoftThis post is part of the series on VBA Snippets.

There is an ADO connection available to VBA within Microsoft Dynamics GP which you can use, but there are some steps you need to follow to use it.

The first step is to declare the variable which will hold the connection.

Private madoConn AS ADODB.Connection

Then you need to create the connection which this example does using a Connect

Continue Reading Ian Grieve’s Article on their blog

VBA Snippets: Adding an SQL ODBC Connection in Microsoft Dynamics GP

This post is part of the series on VBA Snippets. There is an ADO connection available to VBA within Microsoft Dynamics GP which you can use, but there are some steps you need to follow to use it. The first step is to declare the variable which will hold the connection.

Blog Syndicated with Ian Grieve’s Permission

Author: Ian Grieve

Share This Post On