I am using the native SqlClient from the 1.1 .net-framework to connect to Sqlserver 2000. The database-connection is programmed in Visual Studio 2003 in C#. The database-connection is stable for a while, but after 10-20 days my connection isn't using the cultural info anymore. I am using German in my regional settings. And i am using the Sql- Command "SET DATE FORMAT dmy" as my first Sql-Statement when connecting to my database-server. As i said before, after a while my native SqlClient isn't using the german cultural info anymore (datetimes are written in an english format: "mm/dd/yyyy"). does anybody know something about that problem? Does it have anything todo with the native Sql-Client or with the framework? I know that the set date format-function just controls how the string is interpreted, it is just funny that my DateTimeObject.ToString()- Method returns an english format after a while. First of all we thought of an OS-problem concerning automatic updates or something like that, but that wasn't the reason. Then we thought of different users connecting via remote desktop. But after all we couldn't find a reason for this phenomen. thanks for your help in advance wolfgang köck
