Topic Options
#64105 - 06/08/20 12:06 PM SQL Sync workstation error ADS32
TomDillon Offline
New Guy

Registered: 08/23/19
Posts: 6
Loc: California, USA
We have recently turned on SQL Sync on the server, but are getting the following error on all workstations now when they launch any Adagio module: ADS32 Data source name not found and no default driver specified What install-able executable needs to also be installed on all of the workstations (Windows 10) in order for the Adagio modules to behave correctly using the SQL Sync add on? The only place where we are not getting this error is on the Adagio server itself, which also has the SQL 2017 server software installed on it. I am assuming that the SQL Client software needs to be pushed out to all of the workstations in order for this to work, but I don't know what software to install.

Top
#64112 - 06/09/20 10:00 AM Re: SQL Sync workstation error ADS32 [Re: TomDillon]
Chris McDonell Offline
Adagio

Registered: 11/16/01
Posts: 623
Loc: Vancouver, BC, Canada
Hi Tom,

Let me start by saying, I am not knowledgeable in SQL Server setup.

As far as I know that error message is not coming from Adagio, but might be coming from the SQL Server.

In the data directory there is a file ADSPROF.dat (were dat would be your data selector). Can you upload that file softrak.com\dbr make attention to tech support.
_________________________
Chris McDonell
Softrak Systems Inc.

Top
#64114 - 06/09/20 11:11 AM Re: SQL Sync workstation error ADS32 [Re: Chris McDonell]
TomDillon Offline
New Guy

Registered: 08/23/19
Posts: 6
Loc: California, USA
I sent the file, attention of tech support

Top
#64115 - 06/09/20 12:05 PM Re: SQL Sync workstation error ADS32 [Re: TomDillon]
Chris McDonell Offline
Adagio

Registered: 11/16/01
Posts: 623
Loc: Vancouver, BC, Canada
Hi Tom,
Can you also upload the DSN file please. AdagioSQL.dsn

Thanks
_________________________
Chris McDonell
Softrak Systems Inc.

Top


Moderator:  Christa_Meissner 
Who's Online
2 registered (Carol Wojick, Bruce Gardner), 88 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
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