BUSY connection
SQL Server and Microsoft Access companies
BUSY keeps a company’s data either on SQL Server or in Microsoft Access files. The Windows app reads both; each needs something different on the PC.
Facts reviewed on
Companies in Microsoft Access
- Install the 64-bit Microsoft Access ODBC driver on the PC. AI Zeny uses the driver named “Microsoft Access Driver (*.mdb, *.accdb)”.
- The BUSY data folder must be readable by the AI Zeny service account, because the app reads BUSY through its Windows service.
- In the company editor choose “Microsoft Access” and enter the “BUSY data folder”, for example C:\BusyWin\DATA. There is nothing to sign in with.
Which driver
AI Zeny reads Access companies through the 64-bit ODBC driver named “Microsoft Access Driver (*.mdb, *.accdb)”. If “Test connection” reports “Could not connect to BUSY”, check that this 64-bit driver is installed on the PC.
Companies on SQL Server
- No separate driver is needed; AI Zeny includes what it uses to connect to SQL Server.
- Enter the “Server name or address” (for example SERVER-PC\SQLEXPRESS) and, if needed, the “Port”.
- Under “Sign in with”, choose “AI Zeny service account” — SQL Server then sees the AI Zeny service account, which needs access to the BUSY database — or “SQL Server login” with a user name and password, stored encrypted on the PC only.
Then test
Choose “Test connection”; see connect a BUSY company on the PC for the results.