Talend community forum / How to connect to MS SQL Server 2005 using tMSSQLOutput component?

arun0623 · 2010-04-05 13:26:24

Tags: [bug, context, database, error management, mssql, schema, tos3.0.0]

Hi all,

I need to know how to connect to MS SQL Server to truncate a table using tMSSQLOutput component.

Am getting an error that ""Exception in component tMSSqlOutput_1
java.sql.SQLException: Unknown server host name ""

Please help me out of this.
Any kind of help would be much appreciated.

Thanks in advance!!

Warm Regards,
Arun Prabhakar T

shong · 2010-04-05 13:42:07

Hello

java.sql.SQLException: Unknown server host name ""

Did you type in the host name or IP?

Best regards
Shong

arun0623 · 2010-04-05 13:56:54

Hi,

Yes. I have given all the credentials including DB name, usr name and pwd. But still I am getting the same error.

But I am able to connect to the same server through an ODBC connection.

Regards,
Arun

shong · 2010-04-05 13:59:22

Hello
Can you upload a screenshot of tMSSqlOutput_1?

Best regards
Shong

Announcement

Unanswered posts

#1 2010-04-05 13:26:24

How to connect to MS SQL Server 2005 using tMSSQLOutput component?

#2 2010-04-05 13:42:07

Re: How to connect to MS SQL Server 2005 using tMSSQLOutput component?

#3 2010-04-05 13:56:54

Re: How to connect to MS SQL Server 2005 using tMSSQLOutput component?

#4 2010-04-05 13:59:22

Re: How to connect to MS SQL Server 2005 using tMSSQLOutput component?

Board footer