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 |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2006-09-27 : 08:58:43
|
| OLE Automation objects are not supported in fiber mode. [SQLSTATE 42000] (Error 8149). The step failed.Please help!!!Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-09-29 : 20:33:07
|
| You have set your SQL Server to run using lightweight NT fibres rather than threads. Somewhere on the MS site there is a discussion about the pros and cons - you should run in fibre mode only in very few cases - the default for SQL Server and the mode that is best suited to most things on SQL is to run it in threaded mode. When you run in fibre mode, things like OLE automation (which gets involved in threads, apartments, etc - fibres don't tend to mix with this) just don't work if you have fibre mode on.Run Enterprise manager, bring up the properties of your server and turn off fibre mode in one of the property pages. |
 |
|
|
|
|
|
what this error meant???