XP_CmdShell and OLE provider

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

Date: Tue, 30 Nov 2004 10:40:24 -0600

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

  • XP_CmdShell and OLE provider
    ... I have to update/modify a VisualFoxPro table from SQL Server stored ... I created an executable that takes a SQL statement as param and executes ... There is no problem with the sql statement. ...
    (microsoft.public.data.ado)
  • Dont want SQL statement to execute if a field is empty
    ... avid user of the site. ... executes and "Insert into" statement that puts the values in the table. ... and also...to not execute the sql statement. ... MsgBox "Need Employee Please" ...
    (microsoft.public.access.formscoding)
  • Re: Processing DynamicSQL with single quotes in the data
    ... However any varchar could have a quote in it - i.e. descriptions, ... Every SQL statement is being executed in C from a common handler OpenROAD procedure so ... It executes all non-SELECT statements with an EXEC SQL EXECUTE ...
    (comp.databases.ingres)
  • Re: Form recordsource
    ... Now...I have checked Access queries using the SQL statement and the sql ... executes this and comes back to "Forms!.RecordSource ... Then the open form is not displayed ... >> the recordsource for the second form is created and passed after opening ...
    (microsoft.public.vb.database.dao)
  • Access SQL not updating any rows
    ... I have a vb.net app that is building a SQL statement. ... executes, it does not error, but updates zero rows. ... update tblPayees set paymentamt7 = paymentamount where paymenttype like ... It updates zero rows, but when I paste that exact statement into an Access ...
    (microsoft.public.dotnet.framework.adonet)