Problem with dataset wizard when using Firebird

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
dvonderburg
Posts: 2
Joined: Tue 17 Jul 2018 23:37

Problem with dataset wizard when using Firebird

Post by dvonderburg » 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.

dvonderburg
Posts: 2
Joined: Tue 17 Jul 2018 23:37

Re: Problem with dataset wizard when using Firebird

Post by dvonderburg » Thu 19 Jul 2018 17:14

I just updated to build 1687 and still have the issue.

Pinturiccio
Devart Team
Posts: 2254
Joined: Wed 02 Nov 2011 09:44

Re: Problem with dataset wizard when using Firebird

Post by Pinturiccio » Fri 20 Jul 2018 13:14

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Pinturiccio
Devart Team
Posts: 2254
Joined: Wed 02 Nov 2011 09:44

Re: Problem with dataset wizard when using Firebird

Post by Pinturiccio » Wed 08 Aug 2018 13:19

We have fixed the bug with not showing the column list in Query Builder when creating a new Table Adapter in a DataSet for Firebird. We will post here when the corresponding build of dotConnect Universal is available for download.

Pinturiccio
Devart Team
Posts: 2254
Joined: Wed 02 Nov 2011 09:44

Re: Problem with dataset wizard when using Firebird

Post by Pinturiccio » Fri 10 Aug 2018 10:24

New build of dotConnect Universal 3.70.1699 is available for download now!
It can be downloaded from https://www.devart.com/dotconnect/unive ... nload.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=37552

Post Reply