One Star

Error in Sybase Connection 'java.lang.NullPointerException

Hello,
I am new to Talend, but have had some small successes connecting to our Oracle DBs.  However, I have struggled to connected to our Sybase DBs.
I am currently getting the following error when trying to establish the connection (java.lang.NullPointerExecption).  I get the same message both using the Sybase ASE connection and direct with JDBC
the string connection is as follows 
jdbc:sybase:Tds:<IPADDRESS>:<PORT>/CSD?ENCRYPT_PASSWORD=true
Any help would be greatly appreciated 
Many Thanks
Arran
2 REPLIES
Moderator

Re: Error in Sybase Connection 'java.lang.NullPointerException

Hi Arran,
Did you set up DB metadata to connect to your Sybase DBs or use tSybaseConnection component direactly? Can you successfully connect to your Sybase DBs through client without using Talend Tool?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Error in Sybase Connection 'java.lang.NullPointerException

Two main things you need to make sure:
1) Use tSybaseConnection component to establish a connection to DB.
2) Make sure sql.ini file is configured appropriately on a machine where Talend Open studio is making a connection.
I hope that helps !!!