Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

When connecting to Microsoft SQL Server using the SQL Server connector in TIBCO Spotfire Analyst, all databases are not listed

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

When connecting to Microsoft SQL Server using the SQL Server connector in TIBCO Spotfire Analyst, all databases are not listed


Solution:

In some scenarios, while connecting to a Microsoft SQL Server database through SQL Server connector connection, all the databases are not listed whereas the missing databases are visible when making a connection using SQL Server Management Studio (SSMS) or any other 3rd party tool by making use of the same user credentials.

Below is the information which is getting logged inside the Spotfire Analyst Debug log file:

------------------------------------
2019-12-22T11:48:48,335-04:00 2019-05-22 15:48:48,335 D981@TIBCO.com [35] DEBUG Spotfire.Dxp.Data.Adapters.SqlServer.SqlServerAdapterConnection [(null)] - ConnectAndGetDatabaseNames: Database "Employees" has compatibility level 80. Skipping.
------------------------------------ The compatibility level for the missing databases is 80 (which corresponds to SQL Server 2000) and levels below 90 are not supported in TIBCO Spotfire Analyst. 

Note: With the SQL Client data provider option, the data can be loaded inside Spotfire Analyst from the databases which are not listed in the SQL Server Connector connection i.e. all SQL Server database versions are supported in it.

Related articles