SQL 2005 Express with Advanced Services: missing providers



[posted in]
- comp.databases.ms-sqlserver
- microsoft.public.sqlserver.odbc
- microsoft.public.sqlserver.server
[/posted in]

I installed "SQL 2005 Express with Advanced Services with SP1" onto two machines with "Windows XP Pro SP2".

On both computers I noticed that in SSMS Express, under "Server Objects" -> "Linked Servers" -> "Providers", the list of providers installed is empty!!!!
I tried to connect to two ODBC sources (with DSN) and an OLE DB one, but always received the "Message 7302" error ("Unable to create instance for OLE DB....").

As suggested by MCP Luca Bovo, I tried to reinstall "workstation components" (which include libraries for connecting external resources), but unfortunately it didn't solve.

Can you suggest me a solution?

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype:pbsoftsolution


.



Relevant Pages

  • Re: Clean install WindowsXP Pro SP2 fails web browsing - Times Out 15-
    ... I also use TimeWarner Cable but EarthLink is my ISP and I have four ... computers running XP SP2 loaded from scratch. ... compare this by pinging your own computers if you have them networked. ... > This is the third time I install a clean system of Windows XP Pro SP2 on ...
    (microsoft.public.windowsxp.network_web)
  • SP2 Totally Screwed up My Computer!
    ... As I wasn't seeing SP2 on the Windows Update site, ... (As I have two computers, ... figured that way I wouldn't have to download it twice through Windows Update ... I don't want an icon for it in the QL bar. ...
    (microsoft.public.windowsxp.help_and_support)
  • SP2 Totally Screwed up My Computer!
    ... As I wasn't seeing SP2 on the Windows Update site, ... (As I have two computers, ... figured that way I wouldn't have to download it twice through Windows Update ... I don't want an icon for it in the QL bar. ...
    (microsoft.public.windowsxp.general)
  • Re: Upgrading from XP home editon SP2 to XP Pro
    ... > cannot upgrade Home Sp2 to XP Pro SP1 without either slipstreaming the XP ... > Windows Slipstreaming and Bootable CD Guide ...
    (microsoft.public.windowsxp.general)
  • Re: Upgrade from Home to Pro
    ... is preserved after a XP Home SP2 to XP Pro SP2 upgrade? ... Purchase a conventional "Retail Version" of Windows XP Professional. ... insert the Windows XP Pro CD in the drive and select ...
    (microsoft.public.windowsxp.general)