Problem with dataset wizard when using Firebird
Posted: Wed 18 Jul 2018 18:34
Visual Studio 2017 Pro version 15.7.5
Firebird 2.5.3
dotConnect Universal 3.70.1669.0
Windows 10 Pro
When I use the Visual Studio 2017 dataset wizard to create a tableadapter for Firebird the table does not show all of the columns.
My connection string is:
provider=FirebirdClient;Charset=NONE;Database=ABC;Data Source=localhost;Dialect=3;User ID=SYSDBA;Password=xxxxxx;Persist Security Info=True;Port=3050
Steps to produce issue.
Right click in a blank dataset and select Add>Table Adapter...
Select the Firebird data connection (which works when testing connection) click Next
Select Use SQL Statements and click Next
Click Query Builder
Select table and click Add
In the Query builder the table appears with only one column *(All columns). None of the fields appear in the list. If I select *(All columns) it will populate the tableadapter with the complete field list. But there is no way to select them in the wizard to build the query.
Firebird 2.5.3
dotConnect Universal 3.70.1669.0
Windows 10 Pro
When I use the Visual Studio 2017 dataset wizard to create a tableadapter for Firebird the table does not show all of the columns.
My connection string is:
provider=FirebirdClient;Charset=NONE;Database=ABC;Data Source=localhost;Dialect=3;User ID=SYSDBA;Password=xxxxxx;Persist Security Info=True;Port=3050
Steps to produce issue.
Right click in a blank dataset and select Add>Table Adapter...
Select the Firebird data connection (which works when testing connection) click Next
Select Use SQL Statements and click Next
Click Query Builder
Select table and click Add
In the Query builder the table appears with only one column *(All columns). None of the fields appear in the list. If I select *(All columns) it will populate the tableadapter with the complete field list. But there is no way to select them in the wizard to build the query.