Try setting the rest of provider settings through the @.provstr parameter of
the sp_addlinkedserver.
Some examples are available in Books Online.
ML
http://milambda.blogspot.com/Thanks. After doing some more research, I now know that this is a limitation
of SQL Server Express.
I was however able to use the following system stored procedure to change
the provider options:
EXEC master.dbo.sp_MSset_oledb_prop N'ProviderName', N'AllowInProcess', 1
I hope this can help someone else.
Thanks,
Mike
"ML" <ML@.discussions.microsoft.com> wrote in message
news:1CF1915F-6D1B-443F-B674-7C51B3139B79@.microsoft.com...
> Try setting the rest of provider settings through the @.provstr parameter
> of
> the sp_addlinkedserver.
> Some examples are available in Books Online.
>
> ML
> --
> http://milambda.blogspot.com/|||This is very helpful and good to know. Do you have a blog? Where have you
found the solution?
ML
http://milambda.blogspot.com/|||Hi,
Cindy Winegarden answered in microsoft.public.sqlserver.programming, when I
asked for the same problem (25/05/2006)
Michel Lvy
Communaut Francophone des Professionnels FoxPro
Pour un dveloppement durable...
http://www.atoutfox.org
--
"ML" <ML@.discussions.microsoft.com> a crit dans le message de news:
0BAB0C0C-0151-462E-94B0-9686347E430D@.microsoft.com...
> This is very helpful and good to know. Do you have a blog? Where have you
> found the solution?
>
> ML
> --
> http://milambda.blogspot.com/
Showing posts with label books. Show all posts
Showing posts with label books. Show all posts
Friday, March 23, 2012
Friday, February 24, 2012
Free books and exam info
Get free braindumps, real exam questions free books, notes and exam informat
ion for all certification exams.
ion for all certification exams.
quote:
Originally posted by jeff
Get free braindumps, real exam questions free books, notes and exam information for all
certification exams.
Subscribe to:
Posts (Atom)