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 |
|
gbnaveen
Starting Member
10 Posts |
 Posted - 2008-09-11 : 05:53:21
|
| my application was working fine with sql 2000.recently i upgraded my sql server to 2005 and i am getting the following error "Requested operation requiresan OLE DB Session object, which is not supported by the current provider."any help....thanks, |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2008-09-11 : 10:06:52
|
| By default SQL 2005 does have TCP/IP disabled along with Named pipesIt is likly your application is trying to use one of these to connect..START>Programs>Microsoft SQL Server 2005 > COnfiguration TOols>Sql Server Configuration Manager.Expand the "SQL Native Client Configuration" and Enable the protocals you will be using to connect. |
 |
|
|
gbnaveen
Starting Member
10 Posts |
Posted - 2008-09-12 : 01:17:51
|
| hi Vinnie881, thanks for u r reply,i was not aware of that sql 2005 passwords are case sensitive.was getting login failed.thanks,naveen |
|
|
|
|
|
|
Requested operation requires an OLE DB Session obj