Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saglamtimur
Yak Posting Veteran
91 Posts |
 Posted - 2004-03-27 : 22:23:14
|
| For some reasons I have to use Auto Translate=False in my connection string. My connection string is like; "data source=2003-SERVER;Initial Catalog=db_name;uid=db_user;pwd=user_password;max pool size=50;Auto Translate=False" This works fine when I use system.data.oledb. But not working with system.data.sqlclient. It gives me System.ArgumentException: Keyword not supported: 'auto translate' This shows me that I cannot use Auto Translate with system.data.sqlclient, but when I try to add sqlconnection from Visual Studio 2003, ToolBox->Data->SqlConnection and then build connection string from properties window <new connection...>, I can see Auto Translate option in Data Link Properties' All tab. Ok I set it to false and turn back to code behind to see how it uses auto translate=false, I saw nothing about it. ConnectionString is in there but contains nothing about Auto Translate=False. Any ideas about how to add Auto Translate=False to my connection string, and use it with system.data.sqlclient? Thanks in advance. |
|
|
|
|
|
Auto Translate=False problem