Unable to retrieve TIBCO Data Virtualization published data in Visual Studio 2015 with the 8.3 ADO.NET client driver

book

Article ID: KB0074587

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.3

Description

TIBCO Data Virtualization ADO.NET 8.3 driver is installed on the client machine by executing the ADONetInstall.msi. When adding a new connection in Visual Studio 2015, the data source selected is: TIBCO Data Virtualization Server (TDV).
User-added image
Test connection succeeds and the data connection shows up, however 'Retrieve data' option is found missing in Visual Studio 2015.
User-added image

Environment

All supported Operating Systems

Resolution

To resolve this issue, apply to the following changes:
(1) Along with the msi installer, install the additional ADO.NET driver that is available in the client drivers bundle (\apps\ADO.NET): TIB_TDV_ADONet_2020_19.0.7461.  
Please note, during the installation of ADO.NET driver, Visual Studio should be shutdown.
(2) Make sure the client machine has no Windows updates remaining. 
To verify, navigate to Settings > Update and Security > Windows Update >should show 'You're up to date'.   
(3) In Visual Studio, when adding a data source select 'TIBCO(R) Data Virtualization Data Source' as the data source and 'ADO.NET Provider for TIBCO(R) Data Virtualization' as the Data Provider.
Screenshot for reference:
User-added image
(4) Provide the connection details and 'Retrieve data' option would be available to view the TIBCO DV published data. 
Screenshot for reference:
User-added image

Issue/Introduction

Unable to retrieve TIBCO Data Virtualization published data in Visual Studio 2015 with the 8.3 ADO.NET client driver