Q&A BY TAG 'ODBC'
Unable to Connect to VDP via ODBC drivers
answered
27-08-2020 02:16:14 -0400
Hello - I am able to connect no problem via JDBC to VDP (tutorial example). ODBC is not working and getting the below error in configuring the DNS. I am running everything locally on Windows. My ports are all defaults and VDP admin console shows por...
Answers:
1
Logging of User Queries via ODBC
answered
11-08-2020 15:01:04 -0400
Hello, We have lots of users querying Denodo views via ODBC connection in Power BI. Is there an option to get the information of the different queries run by them via Denodo to report them.
Answers:
1
Unable to connect denodo using ODBC from power BI
answered
22-07-2020 02:23:59 -0400
Hi I use denodo platform 7.0 in windows. When i connect denodo data view from Power BI i get below error. --datasource.error: odbc: error [hy000] error while executing the query Even when i tried to connect from microsoft excel using the option "fro...
Answers:
2
How to connect Denodo with SSL certificate in Tableau?
answered
13-07-2020 04:26:23 -0400
Hi, Can any one provide me the steps to coonnect tableau with Denodo if SSL is enabled in Denodo server. I am also trying to connect by tableau but unable to get the option to attache public SSL certificate.
Answers:
1
Connecting Tabealu on Denodo ODBC Tableau ODBC DENODO Driver Tableau SSL
Errors with ODBC client connection from SQL Server Polybase
answered
02-06-2020 03:49:04 -0400
Hi-- My use-case requires me to establish a Polybase connection from SQL Server using ODBC driver. I have successfuly followed instructions on: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-odbc-generic?view=sq...
Answers:
4
ODBC connection | trusted non kerberos domain
answered
19-05-2020 07:28:29 -0400
Hello, We have configured Kerberos in 2 domains, domain1 and domain2. We have a scenario where we have 2-3 users from a different domain, domain3. We dont want to enable Kerberos to the whole domain we need need these 2-3 user of Domain3 to be able to...
Answers:
1
Active connections staying opened
answered
15-05-2020 01:05:04 -0400
I have been observing in my monitoring logs that VDPActiveConn are high and constantly growing. You would expect a connection to be opened, used and closed. Yet in my logs they are staying oepned. I checked via JConsole the connections and 140 were ope...
Answers:
1
Folder structure using ODBC driver
answered
11-03-2020 08:00:55 -0400
Many of our users connect to Denodo using the ODBC driver, version 7. Our databases have interfaces structured in folders, which are visible through VDP, and certain other tools (such as DB Visualizer). However, most reporting tools (ex. Excel, Power B...
Answers:
1
PHP ODBC Binding issue with numbers/integers
answered
22-01-2020 06:23:18 -0500
Closely related to this question: https://community.denodo.com/answers/question/details?questionId=9060g000000TQpWAAW&title=ODBC+binding+parameters Binding any type of date, datetime, varchar or char seems to work. however when doing integer or d...
Answers:
1
ODBC binding parameters
answered
23-12-2019 17:54:49 -0500
I'm connecting true the ODBC driver form PHP to the denodo database. I'm using pdo and want to make use of binding parameters in de code. e.q.: This works: $denodo = new DenodoDatabase(); $sql = "SELECT * from orders where ordernumber = 20753852 limi...
Answers:
3