March 1, 2002 at 12:00 pm
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
try running sp_configure to change the default language to US English
March 1, 2002 at 12:30 pm
sorry British English
March 1, 2002 at 12:39 pm
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
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
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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy