Post reply

Linked Server .dbf Connection Issue

  • September 2, 2005 at 4:54 pm

    #88805

    All,

    I have an issue where I can not connect to .dbf files through the SQL Linked Server when the .dbf files are located on a remote system. If the files are on the same system as the SQL box, the connection is fine and I can query the table. If they are on a different server,

    I receive a 7303 error and/or invalid file(s) error.

    I've tried both the ODBC and OLEDB connections for foxpro with no luck. Changed the SQLSERVER system account to use the domain admin account, created a share on my own system giving everyone full access to both the share and file permissions. Nothing seems to work.

    Anyone come across this issue and know how to fix it?

    Thanks!

  • September 5, 2005 at 6:28 am

    #587566

    I have had it work for me via a UNC path, but it is very slow!

    Are you using UNC paths? (drive letters won't work)  What options did you set in your ODBC datasource?  What options did you set in your linked server setup?

  • September 6, 2005 at 1:01 am

    #587677

    Hiya,

    Using mapped drive letter here.  I thought that I had tried a UNC path but I will check it again.  And YES, it is very slow, even locally.  Usuall > 1 min for a simple query.  Nothing special about the configurations, using all the defaults with the ODBC connection and simply pointing it to a mapped drive path.  The only thing I am filling in on the Linked Server is the DSN name.  I'll double check the UNC path and see if it works.

  • September 6, 2005 at 5:20 am

    #587724

    Mapped drives won't work, as a rule, because they are made specific to a user account.  Just because your account in Windows - which may even be the one you are using to connect to SQL Server - has a mapped drive, SQL Server, executing in its own service context, won't know about it, or may have it mapped elsewhere!

    SQL will need to run as a user account to access another computer.  The user account *could* have persistent mapped drives which I think SQL would then inherit by running under that account, but the safest thing is to use UNC paths.

    Hope that clears it up a bit.  Cheers!

  • September 6, 2005 at 12:05 pm

    #587879

    Makes perfect sense.  I will give it a shot this week and post my results.  Thanks for the info, I'll let you know how it turns out.

  • September 6, 2005 at 7:35 pm

    #587969

    No probs!  Good luck

Viewing 6 posts - 1 through 5 (of 5 total)

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