You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-03-22 11:21:05

ali_hijazi
Member
19 posts

ali_hijazi said:

unable to connect to MS-SQL server

Hello
I'm working on Talend Data Quality
I wanted to create a DB connection and I supplied the details (server, database name, user, pwd)
However when I click on the check button to check if the connection is successful i get that the file jtds-1.3.1-patch.jar is missing but the I cannot make any action as the action button is disabled
I went to Help->Install Additional Packages
I get that there is nothing to install

Please advise

Offline

#2 2016-03-23 04:22:28

xdshi
Talend Team


xdshi said:

Re: unable to connect to MS-SQL server

Hi,
Have you already checked documents about:TalendHelpCenter:Identify+required+external+modules and TalendHelpCenter:Install+external+modules?
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-03-23 08:49:44

ali_hijazi
Member
19 posts

ali_hijazi said:

Re: unable to connect to MS-SQL server

Yes I already did and I can't find Network Connections as per the help page

Offline

#4 2016-03-23 08:58:55

ali_hijazi
Member
19 posts

ali_hijazi said:

Re: unable to connect to MS-SQL server

could it be because I'm launching the 32-bit talend Data Quality and connecting to 64-bit data source
please advise as I'm unable to do anything

Offline

#5 2016-03-23 22:18:45

gretnadude
Member
1 post

gretnadude said:

Re: unable to connect to MS-SQL server

I also have the "jtds-1.3.1-patch.jar is missing" problem when trying to connect to SQL Server (2014) on Windows 10 using the data quality tool. I have searched many web sites and can not find this exact file to download, and the search feature in Talend did not find it or give any relevant information. The documentation did not help either. Please help.
NOTE: The following file can be found in the Talend Library but it has a slightly different name: C:\Users\Bill\.m2\repository\org\talend\libraries\jtds-1.3.1-patch\6.1.1-SNAPSHOT
Also, the extracted files and exe's remain in the Downloads folder. Shouldn't they be relocated to somewhere permanent?
This looks like a very nice tool and I would really like to get it working with SQL Server 2014.
Thanks.

Offline

#6 2016-03-24 09:17:27

xdshi
Talend Team


xdshi said:

Re: unable to connect to MS-SQL server


What we can do is to make sure that Talend will be your best choice!

Offline

#7 2016-04-18 23:19:41

BELFQIH
Member
2 posts

BELFQIH said:

Re: unable to connect to MS-SQL server

Hello,
I have encountred the same error.
I am using TOS Data Quality and TOS Data Integration (x86) with sql server 2014. I can only connect to database using TOS Data Integration ! when trying to do so using TOS DQ i get the "jtds-1.3.1-patch.jar" missing message with the action botton disabled (download and install).
I removed sql server 2014 and installed sql server 2012 but it's still not working.
can you help us please ? thank you

Offline

#8 2016-04-19 09:17:44

xdshi
Talend Team


xdshi said:

Re: unable to connect to MS-SQL server

Hi,
For your missing jar "jtds-1.3.1-patch.jar", have you already checked documents about:TalendHelpCenter:Identify+required+external+modules and TalendHelpCenter:Install+external+modules?
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#9 2016-04-20 11:49:02

BELFQIH
Member
2 posts

BELFQIH said:

Re: unable to connect to MS-SQL server

I have to say that i've read it quickly.
Now that i've read it thoroughly, i managed to resolve the problem.
Thank you Sabrina

Offline

#10 2016-04-21 03:06:45

azcactus
Member
1 post

azcactus said:

Re: unable to connect to MS-SQL server

I had encountered two problems. First error is missing the driver file. I solved it. The second one is when I input all the server name and login credentials, the error is :You must change the database setting. I don't know what's the problem is. Can anybody help?
 For those who are still struggling on the first issue, here is the solution: 
Find the driver in google and download it. The tricky thing is rename the driver with the same name the error message mentioned. jtds-1.3.1-patch.jar. 

Offline

#11 2016-04-21 10:58:38

xdshi
Talend Team


xdshi said:

Re: unable to connect to MS-SQL server

Hi,

The second one is when I input all the server name and login credentials, the error is :You must change the database setting

Can you successfully connect to your MS-SQL server through client with your connection parameter without using talend tool?
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#12 2016-08-31 17:51:29

manan
Guest

manan said:

Re: unable to connect to MS-SQL server

The second one is when I input all the server name and login credentials, the error is :You must change the database setting
i am getting the same error, i can connect to MS SQL server with another client with same credentials that i am trying to use with talend.

Please assist with a solution.

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy