Post reply

Creating A Linked Server To Dbase 5.0 Database

  • June 25, 2008 at 1:44 am

    #122932

    I have an application that uses SQL Server 2005 stored procedures as part of the business logic. I'd like to know if it is possible (and what I would require in terms of drivers, etc) to create a linked server to a Dbase 5.0 database and query it from the stored procedure. I cannot import the data to SQL Server because another application uses the Dbase database and we have to have the data in real-time for both applications.

    Thanks in advance

  • June 26, 2008 at 8:06 am

    #834684

    hi,

    Try to use openrowset instead

    http://technet.microsoft.com/en-us/library/ms190312.aspx

    http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23146199.html

  • June 27, 2008 at 7:01 am

    #835298

    While openrowset may give you some data access, there may be other limitations that will cause problems. Most ODBC drivers for older database formats such as dBase or FoxPro don't provide much in the way of relational capacity, and something as simple as COUNT(*) might not be supported. I ran into that using WinSQL on a Visual FoxPro Database. Thus I'm not sure if openrowset is going to bridge the gap. Be sure to test thoroughly before committing to the method.

    I'm also wondering why there would be all that much of an effort to replace the old application - it's not as if dBase was really all that powerful when compared to SQL Server, so it seems unlikely that application would be all that difficult to replace. At worst, an MS Access front-end to an SQL database might be the fastest way to go,

    and then perhaps convert the Access piece to a web-based app later on.

    Steve

    (aka smunson)

    :):):)

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • August 19, 2008 at 11:52 pm

    #860403

    Hi,

    I have created a linked-server point to dBASE and access dbf table successfully. What I did are steps below.

    1. Download and install VFPOLEDB @ http://www.microsoft.com/downloads/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4

    2. Create a linked-server

    Assuming the source of the DBFs is on remote server @ \\server\DBF_Folder

    EXEC sp_addlinkedserver

    @srvproduct='',

    @server='DBF',

    @provider='VFPOLEDB',

    @datasrc='\\server\DBF_Folder'

    go

    select * from DBF...tablename

    go

    Regards,

    Thien

    --Sorry for my bad English--

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply