Talend community forum / DB connection - retrieve schema

fabou · 2012-02-03 22:33:45

Tags: [java, mssql, retrieve schema, schema]

Hi,

I need Help !!!

i define a Db connection in a repository ( Db connection features : SQl SERVER (driver ODBC)) this connexion is ok) but when i want to retrieve a schema, the dialog box in the stage "select schema to create" list the differents objects, but i cannot click on the next button and the column "creation status" screen "Waiting"

What can i do please?

I use talend Open Studio data integration v 4.2.4

Thanks,

fabou

pedro · 2012-02-06 03:00:27

Hi Fabou

Try again by using Db connection feature: Microsoft SQL SERVER. Don't use ODBC this time.

Regards,
Pedro

Fabou · 2012-02-07 02:52:50

pedro wrote:
Hi Fabou

Try again by using Db connection feature: Microsoft SQL SERVER. Don't use ODBC this time.

Regards,
Pedro

Hi Pedro,

I respect it, I'm using Db connection Microsoft SQL Server, with an authentication Windows, the connection is right, but when i want to retrieve schema, an error message display:

cjava.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

Yet, I've already placed ntlmauth.dll into the x86 bin directories of all java installed and on windows\system32 but still can´t retrieve schema.

My configuration is:
Client Windows XP pro (32 bit)
TOS ver 5.0.1
jre 1.5
SQL server 2008 R2

Best regards

Fabou

pedro · 2012-02-07 03:10:53

Hi Fabou

To avoid this error, SQL 2008 R2 should support both Windows and SQL login modes.
You'd better check it at database side.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-02-03 22:33:45

DB connection - retrieve schema

#2 2012-02-06 03:00:27

Re: DB connection - retrieve schema

#3 2012-02-07 02:52:50

Re: DB connection - retrieve schema

pedro wrote:

#4 2012-02-07 03:10:53

Re: DB connection - retrieve schema

Board footer