Q&A BY TAG 'SQLserver'

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

Datatype Issue while creating a base view from SQL Server
answered 10-05-2018 03:00:38 -0400

I have a table in Sql server with a column of date datatype. For this instance : Create table table_name ( dob date ) ; I have created base view on top of this table. But in base view, datatype of dob as text datatype in denodo which is not expected...

Answers: 1

DENODO MSSQL SQLServer sql server datatypes Date

How to connect the Denodo Server to the Microsoft SQL Server who supports SSL?
answered 11-04-2018 04:11:40 -0400

The Denodo Server is trying to connect to the Microsoft SQL Server using JDBC. But, the MS SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the the server so turning off SSL is not an option. In that case, how to connect th...

Answers: 1


How to connect to SQLServer localdb
answered 12-09-2017 04:21:38 -0400

Hello, How do I conect to the SQLServer localdb? These parameters do not work: 'D:\Denodo\extensions\thirdparty\lib\sqljdbc41.jar' jdbc:sqlserver://(LocalDb)\MSSQLLocalDB:1433;databaseName=denodoCache Error message is rather standard: Unable to ...

Answers: 3

localdb SQLServer

How can I access SQL Server with Denodo Express?
answered 03-10-2014 08:09:52 -0400

Hi, I was trying to create an ODBC Data Source to access a SQL server, however I got an error: Creation of new ODBC data source with the 'Microsoft SQL Server adapter is not allowed by the license Is that the expected behavior? How could I connect ...

Answers: 1

Connectivity SQLServer