book
                        
Article ID: KB0076025
                        
                    
                    
                        calendar_today
                        
Updated On: 
                    
                 
                
                        
                            
Description
                        
                        
                            On an installed TIBCO Spotfire client, the TIBCO Spotfire Connector for Oracle (Add Data Table > Add > Connection to > Oracle) is disabled/greyed out even though all the requirements are met per the system requirements:
- TIBCO Spotfire Data Connector modules are installed.
- Required database driver is installed on the client machine and is a supported version.
- Spotfire licenses are are enabled in the Administration Manager.
 
                     
                    
                    
                    
                    
                        
                            
                                
Resolution
                            
                            
                                - Open Notepad (or other plain text editor) as an administrator (right click and select "Run as Administrator"
- From the text editor, open the machine.config file located C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Config. It should have the following entry (For ODAC121024_x64 driver):
	
<DbProviderFactories>
      <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
      <add name="ODP.NET, Unmanaged Driver" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET, Unmanaged Driver" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.121.2.0, Culture=neutral, PublicKeyToken=89b483f429c47342" />
</DbProviderFactories> 
- Most importantly, it should not have an additional <DbProviderFactories /> tag at the end of the above line. Remove it if it is there and save the file.
- After saving, relaunch the TIBCO Spotfire installed client.
If the additional <DbProviderFactories /> tag is not present and you still have issues, then please contact TIBCO Spotfire Support for further assistance.
                            
 
                         
                        
                    
                        
                            
                                
Issue/Introduction
                            
                            
                                In this article you will find one configuration to check if the Oracle connector is greyed out but all requirements are met.
                            
                         
                        
                    
                        
                            
                                
Additional Information
                            
                            
                                Doc: System Requirements > TIBCO Spotfire® Connector for Oracle Category