unable to connect MS SQL server in incorta
Please help we are trying to add new data source in our incorta system. when we try to connect getting "Driver:SQLServerDriver:9 returned null " error and it is working fine in SQL developer with same connection details.
INC_005002001:Failed to Connect to [test] due to [Driver:SQLServerDriver:9 returned null for URL:jdbc:mysql://host:49170/test] with properties [[database, sqlserver], [user, jams], [connectionPool, 30], [connection, jdbc:mysql://host:49170/test], [driver, com.microsoft.sqlserver.jdbc.SQLServerDriver]]
Hi Delli are you sure you have configured your data source correctly? I see you are using the Microsoft SQL Server driver but your JDBC URL contains mysql. Here is an example of a SQL Server JDBC URL I've used recently. Remember that when using port number with SQL Server that you do not specify instance name: jdbc:sqlserver://sample_server.incorta.com:4809;databaseName=sample_database;
Thx Dustin Basil you are Correct :) now i can able to connect. but when define the query with CTE function in incorta end it it throwing error which is running fine in SQL server not in incorta.
incorrect syntax near the keyword 'WITH'.] with properties [[database, sqlserver
WITH path(FolderId, FolderName, parentfolderid, LEVEL, treepath) AS
( SELECT FolderId AS FolderId, FolderName, parentfolderid, 0 AS LEVEL,CAST(FolderName AS VARCHAR(1024)) AS treepath FROM folder WHERE parentfolderid IS NULL
SELECT d.FolderId AS FolderId, d.FolderName, d.parentfolderid,path.LEVEL + 1 AS LEVEL,CAST(path.treepath + ' -> ' +
CAST(d.FolderName AS VARCHAR(1024)) AS VARCHAR(1024)) AS treepath FROM folder d
INNER JOIN path ON path.FolderId = d.parentfolderid)
I will ask QA team to review further. During the preview, we'd like to limit result to 250 rows. So, we have a wrapper select top 250 * () t on top of the input query.
Im not sure, we do support sql CTE, store proc officially yet. Remember, sql store proc can return multiple result sets to the client.