none
with jdbc driver how to make an sql server connection with non default db language?

    Question

  • I need to make a connection to sql server 2008 with jdbc driver with a language different than default and it doesn't work. Any help?
    • Moved by Papy NormandModerator Saturday, March 10, 2012 7:30 PM Move requested by the MS JDBC driver Team (From:SQL Server Documentation)
    Tuesday, March 06, 2012 2:05 AM

Answers

  • SQL Server will set the language to the login's default language upon connecting.  You can execute a SET LANGUAGE command immediately after connecting to change the language setting for the session.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    Sunday, March 11, 2012 12:18 AM
    Moderator

All replies

  • Hi,

    Can you provide more details?

    What version of the JDBC Driver are you using?  What Java version (include vendor and update number).  Which language are you trying to use?  Is your OS set to the same language?

    What is the error message?  Are you able to connect in other languages?

    Wednesday, March 07, 2012 1:24 AM
  • Can you post your question and details to the Data Access Forums instead?

    http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/

    Wednesday, March 07, 2012 1:51 AM
    Moderator
  • Hello,

    On the request of the Microsoft JDBC Driver Product Team, i am moving this thread

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Saturday, March 10, 2012 7:29 PM
    Moderator
  • Hello,

    Move done.I hope you will find a quick and full solution to your problem.

    Have a nice day

    PS : This post has only one aim : to warn the followers of this thread that it has been moved on a more suitable forum.


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Saturday, March 10, 2012 7:33 PM
    Moderator
  • SQL Server will set the language to the login's default language upon connecting.  You can execute a SET LANGUAGE command immediately after connecting to change the language setting for the session.


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/

    Sunday, March 11, 2012 12:18 AM
    Moderator