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 - 2003-06-03 : 08:24:23
|
| Dexter writes "I am having trouble connecting to SQL Server 2000 from a ASP.Net app. My connection string: Provider=SQLOLEDB;Initial Catalog=dev_vzwshop;Data Source=MI-NTDB1;User Id=vzwshop;PASSWORD=vzwshop;The error message - Keyword not supported: 'provider'.Version is 8.00.534This connection string is in use currently, in our production apps. So, I don't think the problem is in my connection string. I just upgraded to Visual Studio.Net 2003. So, I'm guessing that maybe there's a problem with using native SQL providers. However, I don't know where to properly investigate until I can find out more about the error message.So, my question for you - why would a program, upon connection, abend and return this message?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-03 : 08:25:32
|
| If you're using the System.Data.SqlClient library, the provider setting is unnecessary as it always uses the SQL Server provider. Just remove the Provider section and it should work. |
 |
|
|
|
|
|
Connection issues from .Net