The Microsoft Data Link Error can occur when testing Business Adapter Studio's connection to Microsoft SQL Server during the "initializing provider" step. This error often occurs because the beacon doesn't have the correct native client installed. The correct native client must be installed to connect to the external database.
The provider parameter mentioned in the error is a standard part of SQL connection strings, which are not specific to FlexNet Manager Suite. See Microsoft's Connect to an ODBC Data Source (SQL Server Import and Export Wizard for more information on configuring this connection.
To verify your connection settings are correct, test the connection with a Universal Data Link (UDL) test. A UDL file enables you to test the Object Linking and Embedding Database (OLE DB) provider's connectivity to any backend database independent of a full application.
To test the connection using the SQL Server OLE DB provider, follow these steps:
To resolve the issue, install one or both of the following providers, depending on your TLS setting and SQL versions.
For more information on each provider, see Microsoft OLE DB Driver for SQL Server.
on Feb 09, 2023 12:48 PM - edited on Mar 14, 2023 01:21 PM by HollyM