Post reply

SQL server in USA - Datetime format problems...

  • 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.

  • March 1, 2002 at 12:29 pm

    #424739

    try running sp_configure to change the default language to US English

  • March 1, 2002 at 12:30 pm

    #424740

    sorry British English

  • 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

  • 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 ?

  • 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)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply