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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-13 : 13:08:48
|
| Vikas writes "I am facing problem while updating sql server database through vb code( error description:-Insufficient Key Column). I am using DSN for connecting SQL Server Database. While creating DSN i selected Windows NT Authentication.Now having DSN with Wndows NT Authentication gives error but with Sql Server Authentication its working extremely fine.Now please help me on this to solve this problem ASAP." |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-13 : 15:01:43
|
| Do you have Windows Authentication mode set on your SQL Server?Jay White{0} |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-13 : 17:07:52
|
| Well, you don't need to set it, you can use NT Authentication in either security mode.Can you post the ODBC connection string your DSN is using? It's possible that the settings are not using the Trusted_Connection parameter, or have another setting that conflicts with it.Also, what is the EXACT error message you're getting? |
|
|
|
|
|
|
Problems with authentication connecting sql server