TKnTexas55

ODBC Quandary

Discussion created by TKnTexas55 on Jul 24, 2018
Latest reply on Jul 24, 2018 by jrenfrew

We upgraded our accounting software to Great Plains 2015 from Great Plains 2010.  I want to be able to query the SQL tables directly, create some relationships between tables.  I was able to do this in GP2010.  When I try to do it, I do not get the datatables.  The Great Plains Administrator is trying to help me, but he does not know FileMaker Pro.  We are using Ver17.

 

This is the ODBC connections I have on my computer.  The SQL Server Native Client 11.0 are for the GP2015,  Ver10 is for the old GP2010. 

 

I have a blank table, that I want to create the TOs for the data I need.

I open Manage External Data Sources.  Click New

I am only see three sources.  The two GP2015 I am seeing are the two created weeks ago, when we upgraded.  The two I created today are not showing.  Any thoughts or suggestions from ODBC experts?

Outcomes