Page 3 of 3 < 1 2 3
Topic Options
#44533 - 02/10/15 10:33 AM Re: Query AR and AP via ODBC [Re: Yann]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
Please post a screen shot of the DSN you are using as well as a screen shot from the properties tab of AdagioODBCv2.dll

Top
#44544 - 02/10/15 01:58 PM Re: Query AR and AP via ODBC [Re: Michael Mulrooney]
Bob Wisener Offline
Adagio Conductor

Registered: 03/19/02
Posts: 554
Loc: Vancouver, BC
The problem could be data related. You may want to connect to AP sample data to confirm your setup.
_________________________
Bob Wisener
Dakota Software

Top
#44561 - 02/11/15 01:17 PM Re: Query AR and AP via ODBC [Re: Michael Mulrooney]
Yann Offline
Adagio Scholar

Registered: 10/26/06
Posts: 94
Loc: BC, Canada
Here are the 2 screen Shots...

ODBC Properties

DNS

Top
#44562 - 02/11/15 02:18 PM Re: Query AR and AP via ODBC [Re: Yann]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
Hi Yann,
The ODBC Properties looks OK.
The DSN has * for the Table Selection, please change to AP81B* to minimize the tables returned to MSAccess

In an earlier screen shot of the Visual Connection Expert you show Red&Yellow pointer for the 3 keys from APTransactions_ap81btrn.
It is my understanding that these only were displayed for ODBC 8.5 and are not there ( at this time ) in ODBC 9.1


Top
#44573 - 02/12/15 03:38 PM Re: Query AR and AP via ODBC [Re: Michael Mulrooney]
Michael Mulrooney Offline
Adagio Virtuoso

Registered: 02/07/02
Posts: 839
Loc: Vancouver, BC
As noted, all of Yann's ODBC properties and DSN information was correct. The problem was tracked down to an issue with the shipping AdagioODBCv2.DLL (2.1.7.133) and is fixed with AdagioODBCv2.DLL (2.1.7.155) or greater which will ship with the next release.

Top
#44610 - 02/17/15 07:51 AM Re: Query AR and AP via ODBC [Re: Michael Mulrooney]
Yann Offline
Adagio Scholar

Registered: 10/26/06
Posts: 94
Loc: BC, Canada
Thanks Michael!

Top
Page 3 of 3 < 1 2 3


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 23 Guests and 2 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14242 Topics
69746 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
Su M Tu W Th F Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31