SQL server in USA - Datetime format problems...

• IanCurrie

  Valued Member

  Points: 64

  More actions

  March 1, 2002 at 12:00 pm

  #64068

  Please can anyone help ?

  I'm over in USA. I've got USA VB apps talking to USA SQL SERVER 2000 database.

  I need to bring this back to England and demo over there - however, when setting the computer's regional settings to British UK from English(American), I get:

  out-of-range datetime value Microsoft OLE DB Provider errors. These are occuring when the VB app is passing date/time values as parameters to stored procedures in SQL SERVER.

  Is there something that I am able to do to fix this easily, or do I have to go back to all the VB code (there's tons of it and 5 VB apps actually !!!).

  I've tried using the SET LANGUAGE and SET DATEFORMAT sql functions, but no good.

  SET LANGUAGE works if I append it to the beggining of any Select statement that I issue from VB to OLE DB, but if the problem occurs within a stored procedure, SET LANGUAGE and SET DATEFORMAT don't seem to do anything and of course stored procedures are very difficult to debug.

  Any ideas anyone.

  Any solutions - please e-mail me on iancurrie57@hotmail.com.

  Thank you.

• GRN

  Hall of Fame

  Points: 3260

  More actions

  March 1, 2002 at 12:29 pm

  #424739

  try running sp_configure to change the default language to US English

• GRN

  Hall of Fame

  Points: 3260

  More actions

  March 1, 2002 at 12:30 pm

  #424740

  sorry British English

• IanCurrie

  Valued Member

  Points: 64

  More actions

  March 1, 2002 at 12:39 pm

  #424741

  Thanks for some hope - will try now.

  quote:

  ---

  try running sp_configure to change the default language to US English

  ---

• IanCurrie

  Valued Member

  Points: 64

  More actions

  March 1, 2002 at 3:39 pm

  #424756

  Ok - I went beyond sp_configure.

  I found the 'SQLDriverConnect' connection keyword can be used to change the language as an app. connects to the database.

  Problem is - how do I use the SQLDriverConnnect keyword ?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 1, 2002 at 4:57 pm

  #424764

  Duplicate post to other thread.

  I have never used but this may help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/vfpodbcsqldriverconnect.asp , the article is with Microsoft and from I can understand you have to look at SQLBrowseConnect for some detail. If come across anything else I will pass along.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)