Q&A BY TAG 'MSSQL'

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

Error: Received exception with message 'Incorrect syntax near the keyword 'into'
answered 24-10-2019 07:34:00 -0400

Select * into #Temp from xyz Select * from #Temp When I run this Script using Create Base view from Query, I am getting the below error message. Error: Received exception with message 'Incorrect syntax near the keyword 'into' MS SQL Server 2014 JDBC...

Answers: 1
Related to: Best Practices for Migrating SQL queries to Denodo VQL

into clause MSSQL

Unable to establish connection to MS SQL express
answered 02-04-2019 01:46:36 -0400

Receiving the following error when trying to establish a Denodo 7 connection to MS SQL express (Windows 10, MS SQL version 14.0.2002.14): Unable to establish connection: Cannot open database "MAXXPHASE" requested by the login. The login failed. ClientC...

Answers: 1
Related to: Accessing MS SQL Server using Windows Authentication

Error MSSQL

How to connected to a SQL server authenticated with SSPI
answered 27-11-2018 06:38:00 -0500

Hi, I need to connect to MS Sql Server 2014. Using username and password is working fine for my local database. But I need to connect it to a database which is SSPI authenticated. Denodo VDP is giving me option to create connection using string and so...

Answers: 1

MSSQL Native SSPI library not loaded

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

Using CTE WITH clause for creating base view from query
answered 12-04-2018 09:19:08 -0400

I'm trying to use a CTE MS SQL query to flatten a dataset of employees and their managers. After looking through mutiple articles in the support section I was hoping I could use "create base view from query". This is giving an error saying - "Incorrect...

Answers: 3

Base view quer cte MSSQL

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

SQL Server MSSQL SSL SQLServer

Left and right function in MSSQL
answered 05-09-2017 13:33:59 -0400

Is there a build function like "Left" or "Right" from MSSQL in Denodo? For example, a example string such as "ABCD". left ('ABCD', 1) will return 'A' right ('ABCD', 2) will return 'CD'

Answers: 4

left right MSSQL

Query seems to be ignoring sql table clustered index
answered 22-02-2017 23:36:20 -0500

I have a base view pointing to a single MSSQL table. The table has a clustered index. The table has approximately 6 million rows in it. When I run the query from DBeaver using a simple where clause I get the same expected result as when I run the quer...

Answers: 1

Ignoring Index MSSQL DBeaver

Cannot see MSSQL schemas other than dbo
answered 16-01-2017 12:31:43 -0500

Using the VDP admin tool I am wanting to create base views for tables that are in a schema other then dbo. The VDP tool however does not list schemas other than dbo. I have changed the denodo service permissions thinking this was the issue but this has...

Answers: 2

MSSQL

Service account with MSSQL sources
answered 07-03-2016 12:32:50 -0500

Hi there, Can someone tell me if I can use a service account with a MSSQL source (Such as "DOMAIN\SVC.USERNAME") OR do I have to use a SQL account (Such as a named user)? I have it working now with a SQL account and things are great. We would like t...

Answers: 1

service account MSSQL