topic Connection problem with MS-SQL in Installing and Upgrading

Connection problem with MS-SQL

EffIxx — Fri, 15 Nov 2024 22:24:11 GMT

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.

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

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

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

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

What's my problem?

regards Franz

Re: Connection problem with MS-SQL

Anonymous — Wed, 02 Nov 2022 13:00:54 GMT

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)"

Re: Connection problem with MS-SQL

EffIxx — Thu, 03 Nov 2022 11:53:50 GMT

Hello Rhall,

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

Re: Connection problem with MS-SQL

EffIxx — Thu, 03 Nov 2022 12:24:57 GMT

To test I've create manual this schema

pressing button [Guess query]

This statement ist generated and after complie I get this result.

thats ok. Beside the timestamp.