D3 and mvBase

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

I had one other person ask about this. Don't remember who it was. I believe the problem centered around SSRS attempting to communicate with D3 using language that requires ODBC v3.x compliance where the D3 ODBC server only supports v2.5.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software
------------------------------

Original Message:
Sent: 07-07-2021 23:17
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

Is it possible to get the D3odbc upgraded to v3.x compliance ?

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

Original Message:
Sent: 07-08-2021 17:14
From: Brian Cram
Subject: SSRS reporting from D3 database

I had one other person ask about this. Don't remember who it was. I believe the problem centered around SSRS attempting to communicate with D3 using language that requires ODBC v3.x compliance where the D3 ODBC server only supports v2.5.

------------------------------
Brian S. Cram
Principal Technical Support Engineer
Rocket Software

Original Message:
Sent: 07-07-2021 23:17
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

Since I'm not real familiar with SSRS, are you trying to access D3 as a linked database in SQL Server or do you somehow access it directly from SSRS?

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Software
------------------------------

Original Message:
Sent: 07-07-2021 23:17
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

We're trying to access D3 data directly from SSRS.
We've created SQL mappings on D3 files using CREATE-SQL-VIEW, then we're able to access this data from Excel very easily.
However SSRS cannot see the D3odbc data source, therefore cannot access the SQL mapped D3 data.
It seems Brian Cram is onto the problem, the D3odbc only supports v2.x odbc. It needs to support v3.x odbc in order for SSRS to work.
The Excel works because MS-Query supports v3.x odbc.




------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

Original Message:
Sent: 07-09-2021 18:35
From: Chris Macadam
Subject: SSRS reporting from D3 database

Since I'm not real familiar with SSRS, are you trying to access D3 as a linked database in SQL Server or do you somehow access it directly from SSRS?

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Software

Original Message:
Sent: 07-07-2021 23:17
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

Hmmm, after some wrestling with all the different pieces necessary to create a RS report in VS 2019 I was able to connect to the D3 ODBC DSN and generate a very basic report.  Is there a specific message that you are getting back when you try to set up the D3 data source?

Thanks

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Internal - All Brands
Irvine CA United States
------------------------------

Original Message:
Sent: 07-09-2021 19:05
From: Graham Fallwell
Subject: SSRS reporting from D3 database

We're trying to access D3 data directly from SSRS.
We've created SQL mappings on D3 files using CREATE-SQL-VIEW, then we're able to access this data from Excel very easily.
However SSRS cannot see the D3odbc data source, therefore cannot access the SQL mapped D3 data.
It seems Brian Cram is onto the problem, the D3odbc only supports v2.x odbc. It needs to support v3.x odbc in order for SSRS to work.
The Excel works because MS-Query supports v3.x odbc.




------------------------------
Graham Fallwell
Owner
Software Applications Ltd

Original Message:
Sent: 07-09-2021 18:35
From: Chris Macadam
Subject: SSRS reporting from D3 database

Since I'm not real familiar with SSRS, are you trying to access D3 as a linked database in SQL Server or do you somehow access it directly from SSRS?

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Software

Original Message:
Sent: 07-07-2021 23:17
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

Wow excellent, there is no message generated.
When I was creating the RS data source, I could not even see the D3 odbc DSN.
We're doing something different from each other !?
How can we resolve this please ?

------------------------------
Graham Fallwell
MD
Software Applications Ltd
New Zealand
------------------------------

Original Message:
Sent: 07-12-2021 19:37
From: Chris Macadam
Subject: SSRS reporting from D3 database

Hmmm, after some wrestling with all the different pieces necessary to create a RS report in VS 2019 I was able to connect to the D3 ODBC DSN and generate a very basic report.  Is there a specific message that you are getting back when you try to set up the D3 data source?

Thanks

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Internal - All Brands
Irvine CA United States

Original Message:
Sent: 07-09-2021 19:05
From: Graham Fallwell
Subject: SSRS reporting from D3 database

We're trying to access D3 data directly from SSRS.
We've created SQL mappings on D3 files using CREATE-SQL-VIEW, then we're able to access this data from Excel very easily.
However SSRS cannot see the D3odbc data source, therefore cannot access the SQL mapped D3 data.
It seems Brian Cram is onto the problem, the D3odbc only supports v2.x odbc. It needs to support v3.x odbc in order for SSRS to work.
The Excel works because MS-Query supports v3.x odbc.




------------------------------
Graham Fallwell
Owner
Software Applications Ltd

Original Message:
Sent: 07-09-2021 18:35
From: Chris Macadam
Subject: SSRS reporting from D3 database

Since I'm not real familiar with SSRS, are you trying to access D3 as a linked database in SQL Server or do you somehow access it directly from SSRS?

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Software

Original Message:
Sent: 07-07-2021 23:17
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------

I'll send you an email and we can set up a time for tomorrow when we're both in our respective 'offices'.

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Internal - All Brands
------------------------------

Original Message:
Sent: 07-12-2021 20:15
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Wow excellent, there is no message generated.
When I was creating the RS data source, I could not even see the D3 odbc DSN.
We're doing something different from each other !?
How can we resolve this please ?

------------------------------
Graham Fallwell
MD
Software Applications Ltd
New Zealand

Original Message:
Sent: 07-12-2021 19:37
From: Chris Macadam
Subject: SSRS reporting from D3 database

Hmmm, after some wrestling with all the different pieces necessary to create a RS report in VS 2019 I was able to connect to the D3 ODBC DSN and generate a very basic report.  Is there a specific message that you are getting back when you try to set up the D3 data source?

Thanks

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Internal - All Brands
Irvine CA United States

Original Message:
Sent: 07-09-2021 19:05
From: Graham Fallwell
Subject: SSRS reporting from D3 database

We're trying to access D3 data directly from SSRS.
We've created SQL mappings on D3 files using CREATE-SQL-VIEW, then we're able to access this data from Excel very easily.
However SSRS cannot see the D3odbc data source, therefore cannot access the SQL mapped D3 data.
It seems Brian Cram is onto the problem, the D3odbc only supports v2.x odbc. It needs to support v3.x odbc in order for SSRS to work.
The Excel works because MS-Query supports v3.x odbc.




------------------------------
Graham Fallwell
Owner
Software Applications Ltd

Original Message:
Sent: 07-09-2021 18:35
From: Chris Macadam
Subject: SSRS reporting from D3 database

Since I'm not real familiar with SSRS, are you trying to access D3 as a linked database in SQL Server or do you somehow access it directly from SSRS?

------------------------------
Chris Macadam
Technical Support Engineer
Rocket Software

Original Message:
Sent: 07-07-2021 23:17
From: Graham Fallwell
Subject: SSRS reporting from D3 database

Does anyone use SSRS (Sql Server Reporting Services) to report D3 data.
We've tried using the D3odbc and SQL mappings on D3 files, and it works very easily using Excel, but SSRS cannot see the D3 data source.

This needs to be usable at an end-user level, so no program writing involved. MVC Toolkit and OpenDB seem to involve programming and some expense.

We would like to know how anyone else is doing this.

------------------------------
Graham Fallwell
Owner
Software Applications Ltd
------------------------------