RE: Stored Procedure to Connect a DBF File

From: Al (Al_at_discussions.microsoft.com)
Date: 10/22/04 

Date: Fri, 22 Oct 2004 03:07:01 -0700

Hi,

i've never tried it, but you might be able to create a Linked Server to the
file, after setting up an ODBC connection to it. The stored procedure will
then be to query the Linked Server.

There are also the OPENROWSET and OPENDATASOURCE Transact-SQL commands,
which give you access to OLE DB datasources.

DTS gives you access to dBase, and might be suitable for what you want to
achieve.

"Prabhat" wrote:

> Hi All,
>
> Can I Connect to a DBF File and read the Records / Loop through the records
> of DBF file using / with in the Stored Procedure?
>
> Like in VB we Open as ADO Connection to Connect and a Recordset To Open etc.
>
> Thanks
> Prabhat
>
>
>

Relevant Pages

  • RE: Stored Procedure to Connect a DBF File
    ... but you might be able to create a Linked Server to the ... after setting up an ODBC connection to it. ... > of DBF file using / with in the Stored Procedure? ...
    (microsoft.public.sqlserver.server)
  • Re: User-Defined Function
    ... It doesn't even have to be this elaborate with a linked server. ... Declare @line varchar ... suitable extended stored procedure. ... > server setup and an example of how to get directory information (but not ...
    (microsoft.public.sqlserver.programming)
  • Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... queue. ... The linked server is a SQL server, but not one where I have any ...
    (microsoft.public.sqlserver.security)
  • ANSI_WARNINGS error in Stored Procedure
    ... I have a linked Server on my regular SQL server, and when I try to create a stored procedure that reads from the linked server, I get the following error: ... THIS ENSURES CONSISTENT QUERIES SEMANTICS. ... The query that is to be performed in the stored procedure is a simple SELECT, ...
    (microsoft.public.sqlserver.security)
  • Mail Merge with ODBC and SQL Stored Procedure
    ... I am doing a mail merge the a VB app using VBA. ... am linking to a stored procedure through an ODBC connection. ...
    (microsoft.public.word.mailmerge.fields)
Quantcast