Connection with MS SQL Server component ???

[_AnonymousUser]

Hello
I have installed SQL Server 2005 in localhost on my computer. I've tried to parameter an Db Connections but Talend can not initiate the connection with SQL Server.
Also, when I define an connection with odbc, I made it working with a dynamic port, and I can insert data on the database with the generic components.
I saw that odbc can not be connect with SQL Server if i define the port with the default value 1433.
I need to use the MS SQL Server component for some option like create table, so does someone can help me to set the good parameter for SQL Server 2005.
Thank you
Tibal

[Anonymous]

Hi
The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.
Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.
Regards,
Pedro

[Anonymous]

Hi
The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.
Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.
Regards,
Pedro

Hi,
thank you for your response now i am able to connect to the mssql from talend with General JDBC as a DB Type.
but when i changed the DB Type to Microsoft SQL Server i am getting this error can you help for this also,
Connection failure. You must change the Database Settings.
java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2
Thank you.

[Anonymous]

Hi
The JDBC url of SQL Server is like "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs".
For driver jar and class name, you can find it on Google.
Besides, it seems to be a bug when you are using Microsoft SQL Server DB type.
Regards,
Pedro

Hi,
thank you for your response now i am able to connect to the mssql from talend with General JDBC as a DB Type.
but when i changed the DB Type to Microsoft SQL Server i am getting this error can you help for this also,
Connection failure. You must change the Database Settings.
java.lang.ClassCastException: net.sourceforge.jtds.jdbc.ConnectionJDBC3 cannot be cast to net.sourceforge.jtds.jdbc.ConnectionJDBC2
Thank you.

please give me some suggestion for this above error.

[Anonymous]

Hi
I told you yesterday it seemed to be a bug...
But then you said it was OK and you fixed it...
If you still get this exception, please report it on BugTracker.
PS: Do not add the URL of this forum. Just describe the issue on BugTracker.
Regards,
Pedro

[Anonymous]

hi,
I Ibran now i am trying to run talend job from JAVA, I am successfully running the talend job from JAVA, but
can any one tell me how to pass parameter from java class to the talend this is very important in my project please help me out of it.

[janhess]

Ibram,
Start a new thread for this.

[Anonymous]

I can't create a Database creation using Talend. I want to use MS SQL server 2008r2  as a my database. when try create the connection in the  DatabaseConnection under MetaData tree like this
my SQL server name is ARUNRAJ-PC\SQLEXPRESS I found all detail given are right but when click Check button it shows the connection error.Please help me to resolve this by example.
Thanks
Arunraj

[krengan21]

Hi,

Please check whether the network connection for mssql server database is enabled.

Regards,

Kasthuri Rengan