Q&A BY TAG 'ODBC'

You must sign in to ask a question. If you do not have an account, you can register here

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

Denodo 8.0 ODBC Denodo Express

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

user queries ODBC logging query logs

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

ODBC

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

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

authorization Kerberos ODBC EXCEL ODBC Driver

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

ODBC JDBC

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

ODBC folders Driver

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 php

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

ODBC php Bindparam Windows