Talend community forum / MSSQL connection

Jeff Walls · 2007-08-16 19:29:17

I can't seem to wrap my head around how to make the MSSQL connector work. Maybe I'm just being thick, but I can find no documentation on this.

I am using Fedora 7 and TOS 2.1.2. to connect to a MSSQL 2000 server.

The sting is jdbc:odbc:myservername
and a user name and password in the appropriate fields.

I've tried putting the downloaded MSSQLSERVER odbc in various places.

What is the secret?

mhirt · 2007-08-17 14:05:26

Hello Jeff,

If you really want to connect to your MS SQL Server through ODBC, you should probably use this tutorial of unixodbc -if packaged for Fedora) : http://www.unixodbc.org/doc/FreeTDS.html

Else you can maybe connect using JDBC (he other MS SQL Server in the list).

Regards,
Michaël.

Jeff Walls · 2007-08-17 16:07:11

thats the point.........I CAN"T get the jdbc to work.

I have downloaded and installed the MS jdbc driver and it won't connect.

I can get MySQL to connect but I HAVE to have MSSQL to make this work.

As stated in the above, I have set up the jdbc entry as best I can, but it keep telling me connection error.

Are there instructions somewhere?

I have gotten the ODBC connector to work, but only outside talend, using isql, not inside talend.

And BTW, there is only one MSSQL entry in the DB wizard, that is the MSSQL ODBC one.

mhirt · 2007-08-17 16:09:41

Do you have a Perl project ?

Jeff Walls · 2007-08-20 14:29:40

Yes, that is what I am trying to create.

aba · 2008-04-23 06:39:12

Hi,
I recently (2 days ago) downloaded Talend open source project for poc and have been trying to connect to
MSSQL (local on the same machine as Talend is installed) --- using MSSQL option (not through O/JDBC)

and

Oracle (on another machine) -- using Oracle SID option

In both cases, the connection just fails. I have written a small jdbc program that can connect to both databases but cannot get it through Talend. I was able to connect to a XML file etc. so i think the basic setup is alright but DB connectivity is an issue.

Also, the UI says there is [CHECK] button but I donot see it for MSSQL or Oracle connectivity setups only see it for MySQL.

Thanks for any help! I am pretty much stuck. have tried almost all options in either of the case.

Also, is there a way to do more logging i need to dig this further...

Thanks for any pointers!

AB

shong · 2008-04-23 08:05:03

Hello AB

Also, the UI says there is [CHECK] button but I donot see it for MSSQL or Oracle connectivity setups only see it for MySQL.

Which version of TOS are you using and which OS are you working on?
There is a 'check' button on all the database connection setup panel. After you finish the connection setting, you can click on this button to see whether the connection is successful.

Best regards

shong

Uploaded Images

aba · 2008-04-24 12:59:55

Thanks.

I used 2.4.x instead of the stable 2.3.2 release.

Let me redo the test then with the 2.3.x release.

Appreciate your quick help on this.

Thanks,
AB

Announcement

Unanswered posts

#1 2007-08-16 19:29:17

MSSQL connection

#2 2007-08-17 14:05:26

Re: MSSQL connection

#3 2007-08-17 16:07:11

Re: MSSQL connection

#4 2007-08-17 16:09:41

Re: MSSQL connection

#5 2007-08-20 14:29:40

Re: MSSQL connection

#6 2008-04-23 06:39:12

Re: MSSQL connection

#7 2008-04-23 08:05:03

Re: MSSQL connection

#8 2008-04-24 12:59:55

Re: MSSQL connection

Board footer