Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
EffIxx
Contributor
Contributor

Connection problem with MS-SQL

Hi to all,

i have trouble to connect to MS-SQL instance. To the starting point. I have ( so I hope at least ) downloaded all corresponding JAR files and installed and placed accordingly.

0695b00000YF5SLAA1.png

Talend reports that the connection is ok, but the next step to determine the schema does not happen anymore.

0695b00000YF5T9AAL.png

After pressing next,I can see for a second of the retrieve schema bar then comes then already the next dialog image and end

0695b00000YF5TOAA1.png

To make sure that the connection works, I built and executed an SQL string by hand.

0695b00000YF5peAAD.png

Even if there is no field assignment, 72 tag entries are made (albeit submitted empty).

What's my problem?

regards Franz

Labels (2)
3 Replies
Anonymous
Not applicable

Hi Franz,

 

What version of Talend are you using? Is this the Enterprise version or the Talend Open Studio version? Also, which release is it? You have v7 in your labels, can you give us the full number?

 

What version of Java are you using?

 

Also, I am afraid I am not sure I understand what you mean by ....

 

"Even if there is no field assignment, 72 tag entries are made (albeit submitted empty)"

EffIxx
Contributor
Contributor
Author

Hello Rhall,

i use TOS versions since 2009 in this case it is ....

0695b00000YzVrxAAF.png0695b00000YzVucAAF.png

EffIxx
Contributor
Contributor
Author

To test I've create manual this schema

0695b00000YzWIyAAN.pngpressing button [Guess query]

0695b00000YzWKpAAN.pngThis statement ist generated and after complie I get this result.

0695b00000YzWmLAAV.pngthats ok. Beside the timestamp.