I'm trying to create a Db connection to a sql server database from my PC, but don't succeed when using Talend.
However, I am able to connect to the database through Toad and SQL Management Studio (from the same PC). I've tried both "Open Source JDTS" and Microsoft's JDBC driver, version 6.0. I'm using Talend 6.5.1.
The error I get is "Unknown server hostname patzorg_prd\patzorg_prd" when using "Open Source JDTS". The first part of "patzorg_prd\patzorg_prd" is indeed a valid hostname, I can ping it. The second patzorg_prd is probably a directory or something like that (I got this string from our DBA..).
This is the string of connection (Open Source JDTS):
Please note that both Toad and SQL Management Studio accept "patzorg_prd\patzorg_prd" as a hostname / servername and that I am able to connect to the database with these tools.
I also have to point out that I succeeded in connecting to another database with this string jdbc:sqlserver://pip:1433;DatabaseName=UltimoTest;
In this case the hostname is simply "pip".
So it problaby has to do with the second part. Any idea what's wrong?
Thanks in advance!
Solved! Go to Solution.
Ah, that's it! I was able to connect by changing the connection string into
Thanks for the quick reply!