SQL-side licences for SQLConnect

SQLConnect deals with the Portfolio side of your Portfolio SQL database. You will still need a properly set up and installed SQL-Server (Win), Oracle (Win), mySQL (Win or Mac) or MSDE (Win) infrastructure in place. The precise per-vendor details of licencing are outside the scope of the FAQ but here's a brief synopsis of the considerations involved for MS SQL-Server

If you licence per processor then stop reading, otherwise it's a bit of a grey area from the MS CAL (Client Access Licence) perspective. The Portfolio client can simultaneously open multiple ODBC client connections to a SQL database. Depending upon the SQL licensing that you have purchased from MS this may or may not require additional CAL's. If your SQL licence is based on number of connections then you need to purchase enough CALs to cover the peak number of simultaneous Portfolio ODBC connections (how does the non-techie work this out?). If your CALs are based on number of workstations/seats then you need one CAL for each Portfolio client regardless of the number of open ODBC connections. Port 7 server will also require a CAL too because they will be running a client connection there for server-side Folder Sync. In general, it is recommended that each Portfolio Client that will be using a SQL Hosted DB should be covered by a SQL CAL license from MS.

Question: SQL-side licences for SQLConnect [FAQ00348.htm]
Last Update:- 31 May 2006

This FAQ is created and maintained using

Friday - The Automatic FAQ Maker