|Subject:||Re: Performance problem opening database on SQL-server
|Date:||Sat, 21 Mar 2020 20:06:20 +1100
|From:||Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Do both shops connect to the same server? If so, are the 2 databases for
each shop unique? Or is Database 1 for Shop 1 the same database as
datbaase 1 for Shop 2?
Have you tried a different DSN for each alias?
On 21/03/2020 1:27 am, Anders Jonsson wrote:
> My client has two shops and the app I POS system. The app connects to a
> MS SQL server on a remote site. The app uses two different databases but
> on the same server. Each shop has one PC running the app using Paradox
> 10 runtime.