You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Unable to connect to SQL Server 2008 database.
#1 2012-07-18 23:48:45
- newmer
- Member
- Registered: 2012-07-18
- Posts: 13
Unable to connect to SQL Server 2008 database.
Hi,
I am new to Talend and am having some issues connecting to a SQL Server 2008 db. I am able to connect to a MySQL db just fine, but when trying to create the connection to SQL Server I am getting the error "Connection Failure. You must change the Database Settings. Impossible to initialize the connection !".
Any ideas on why this is happening? I am able to connect fine in sql server management studio. I have also tried this in Talend versions 5.0.3 and 5.1.1
Thanks!
Last edited by newmer (2012-07-18 23:49:39)
Offline
#2 2012-07-19 03:43:01
- pedro
- Member
- Registered: 2011-11-17
- Posts: 3682
Re: Unable to connect to SQL Server 2008 database.
Hi
It is a little bit difficult for new user to configure a sql server connection.
The error log indicates that you need to check the DB parameters( the server, the port and so on).
Besides, go to SQL Server Management Studio to see whether TCP/IP is ON.
Sometimes you even have to close firewall.
It's the same with JAVA JDBC. You can find a lot of info online.
Regards,
Pedro
Only Paranoid Survive.
Offline
#4 2012-07-19 20:50:16
- newmer
- Member
- Registered: 2012-07-18
- Posts: 13
Re: Unable to connect to SQL Server 2008 database.
Hi Guys, Thanks for your replys.
A quick note. I am actually trying to connect to a SQL Azure database. Is their any other way I should be trying to connect to this database?
I can connect using a generic ODBC connection and run the jobs fine in Talend but when I export the job and try running the .bat file I am getting the error:
Exception in component tDBInput_1
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer
length
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.sqltest_0_1.SQLTest.tDBInput_1Process(SQLTest.java:669)
at test.sqltest_0_1.SQLTest.runJobInTOS(SQLTest.java:1163)
at test.sqltest_0_1.SQLTest.main(SQLTest.java:1055)
I would like to be able to connect via JDBC but I am still not able to.
Any suggestions.
Thanks!
Offline
#5 2012-07-20 03:47:07
- pedro
- Member
- Registered: 2011-11-17
- Posts: 3682
Re: Unable to connect to SQL Server 2008 database.
Hi
Where do you deploy this export job?
Does it in the same machine?
SQL Azure database is a Cloud DB which I didn't test before whether it is compatible with SQL Server components.
Regards,
Pedro
Only Paranoid Survive.
Offline
#6 2012-07-20 14:48:44
- newmer
- Member
- Registered: 2012-07-18
- Posts: 13
Re: Unable to connect to SQL Server 2008 database.
Hi Pedro,
Thanks for the reply. I deployed the job on the same machine that I have TOS installed.
Is there any work arounds you may know of as this is a use case that we need to achieve with talend.
Thanks for your help!
Offline
#10 2012-07-24 04:08:44
- pedro
- Member
- Registered: 2011-11-17
- Posts: 3682
Re: Unable to connect to SQL Server 2008 database.
Hi
Sorry.
For SQL Server Authentication, just create metadata->sql server connection.
Usually the reason that users can't conenct to sql server is they type the wrong parameters.
Regards,
Pedro
Only Paranoid Survive.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Unable to connect to SQL Server 2008 database.