Palo 3.2CE - Problem connecting to SQLServer - Palo ETL

Palo 3.2CE - Problem connecting to SQLServer

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

philippe.kienner

Intermediate

Posts: 9

Date of registration: Apr 8th 2011

Thursday, November 17th 2011, 4:29pm

Palo 3.2CE - Problem connecting to SQLServer

Hi,
I tried out CE 3.1 on a windows machine and setup an ETL job loading some cubes from a SQL Server (DB on a separate machine).
I then setup a new machine with a SQL Server and Palo 3.2 CE, imported the ETL job from 3.1, all seemed to work well.
But I cannot connect to a SQL Server anymore, neither to the remote, nor to the local !
But I can do it with the SQL Server Manager tool.
no firewall, or other obstacle to network communication.
First I had no port in the SQL Server connection specification, when I add 1433 (standard SQL Server / client port) I get following error :
"
Failed to open Relational connection xxx with URL jdbc:sqlserver://mysqlserver\myinstance:1433;database=mydb.
Please check ...
"
Any idea ?
Similar problems ?

Thanks in advance for your replies.
Philippe

Go to the top of the page

andreas

Palo Team

Posts: 14

Date of registration: Oct 27th 2005

Location: Freiburg

Friday, November 18th 2011, 9:58am

Hi Phillipe,

Are you talking about MS SQL?
Which Java Version do you use?
There is a bug in JRE 6 Update 29 and higher related to the jdbc driver for MS SQL Server.
You should use update 28 or an older version.

regards Andreas