Re: XP_CmdShell and OLE provider

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

  • Next message: sam: "speed isssues with ADO and access 2000 database" 
    Date: Tue, 30 Nov 2004 16:21:50 -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.
    1) 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.
    2) Is there a dbExpress driver available for Visual FoxPro so that I can
    totally eliminate this ADO hell?

    Thanks,
    Sarah

    "Sarah Bram" <SarahBram@hotmail.com> wrote in message
    news:41aca2f5$1@newsgroups.borland.com...
    > 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
    >

  • Next message: sam: "speed isssues with ADO and access 2000 database"

    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 ... Does anyone know how we can make SQL Server aware of the newly installed OLE ...
      (microsoft.public.data.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)