If you using VB and a SA login to connect to SQL server and want to write date to it using VB function like TODAY or NOW you need to execute this statement before doing that:
System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US")
It makes all the regiona stuff US so if you are sending something to a field like MONEY it would come as USD
Another way of doing this is to create a SQL server Login (Server/Security/Logins) and setup a new login set its language to British
use it for any connections and pass in normal date
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment