JDBC Connector - Connection to derby db

[#1]

Hi guys,

i'm trying to connect to a derby database.

I read something on the Forum and I followed the instructions to connect qlikview to a derby db using jdb connector.

First of all I put the JDBCConnector_x64.dll on my client QLIKVIEW.

now I have a bew database connector (as you can see below)

After that I wrote this code on my script

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='€ #.##0,00;-€ #.##0,00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET MonthNames='gen;feb;mar;apr;mag;giu;lug;ago;set;ott;nov;dic';

SET DayNames='lun;mar;mer;gio;ven;sab;dom';

SET CLASSPATH=\\192.168.1.158\Program Files\SysAidServer\root\WEB-INF\lib\derbytools.jar;

//SET DERBY_HOME=C:\JavaDB;

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:derby://192.168.1.158:1527/default;create=true;XUserId=xxx;XPassword=xxx;

Maybe 1527 is not correct ? What do I have to put there ?

When I try to connect to my db QLIKVIEW gives me this error:

I have an error "Custom read failed"

Any idea about what I'm doing wrong???

Thanks a lot

Giampiero

[rbecher]

Just copy the two jar files to your QlikView local machine and set DERBY_HOME and CLASSPATH.

The CUSTOM CONNECT should be fine as it is.

[s_uhlig]

Hi Giampiero,

as far as I can see, SYSAID uses an embedded derby-db located under ???\SysAidServer\root\WEB-INF\db, which will not be exposed to the networklayer.

Please read the Network Server Manual  carefully and test your connection with ij as described in the document.

When I am right and you can't connect to your Server, you have the opportunity to copy the database to your client, expose it through samba (you may encounter other problems) or reconfiguring the SYSAID-Server.

Regards

Sven

[#4]

Hi Sven,

you're right about sysaid and the db.

I'm going to read the document you gave me.

Thank you so much for your help.

Best regards,

Giampiero