Re: XP_CmdShell and OLE provider

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Sarah Bram (SarahBram_at_hotmail.com)
Date: 11/30/04 

Date: Tue, 30 Nov 2004 16:19:27 -0600

New info:

If I execute the below line in SQL Query Analyzer,
exec master..xp_enum_oledb_providers

it returns a list of OLE DB Providers.
I am not finding the one I installed: "Microsoft OLE DB Provider for Visual
FoxPro"
(Windows sees it alright and I am able to select it while creating a
connection through UDL file etc.,)

This could be the reason that it complains about the provider not being
found.
Does anyone know how we can make SQL Server aware of the newly installed OLE
DB Providers?

BTW, I am using SQL Server 2000 on a Windows XP machine.

Thanks,
Sarah

"Sarah Bram" <SarahBram@hotmail.com> wrote in message
news:eVBz3uv1EHA.2624@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I have to update/modify a VisualFoxPro table from SQL Server stored
> procedure.
>
> I created an executable that takes a SQL statement as param and executes
> that statement against the foxpro table.
> I used the Microsoft OLE DB Provider for Visual FoxPro
> from
> http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en#filelist
> I am using an external UDL file for connection.
>
> For testing purpose, I created a windows shortcut and gave an update
> statement as param.
> This worked perfect. The table value changed.
>
> But, when I call the same utility from Query Analyzer using XP_CmdShell,
> it returns the following error:
> "Provider cannot be found. It may not be properly installed"
>
> For debugging purpose, I am also returning the sql string I passed to that
> program.
> There is no problem with the sql statement.
>
> Any ideas...?
>
> Thanks in advance,
> Sarah
>

Relevant Pages

  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.data.oledb)
  • Problem with Linked Server from SQL to DB2
    ... I'm trying to setup a linked server from SQL to DB2 UDB. ... Microsoft provided OLE DB driver for DB2 and the IBM DB2 OLE DB ... -- Invalid schema or catalog specified for provider 'IBMDADB2'. ...
    (microsoft.public.sqlserver.server)
  • Re: XP_CmdShell and OLE provider
    ... If I execute the below line in SQL Query Analyzer, ... I am not finding the one I installed: "Microsoft OLE DB Provider for Visual ...
    (borland.public.delphi.database.ado)
  • Re: Current System as Global Variable
    ... I have changed the OLE DB Provider and have tested on the SQL Server ... and then I clicked the parameters tab it ...
    (microsoft.public.sqlserver.dts)
  • Re: MultiThreading against a Procedure
    ... In the SQL Server provider? ... I'm really beginning to wonder if there's a bug in the provider. ... You should not have to rebuild or dispose of the Command objects between ... I can't change the procedure to just execute from '1/1/2001' to ...
    (microsoft.public.dotnet.framework.adonet)