SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 cannot read some DBF file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Huangdashi
Starting Member

USA
2 Posts

Posted - 06/06/2007 :  18:07:47  Show Profile  Reply with Quote
Hi All

I am trying to load DBF files into SQL server within CLR (actually if just running the select statement outside, say within the SQLQuery window, i got the same result), but with the following error:

Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "MYDBF" does not contain the table "T8866064". The table either does not exist or the current user does not have permissions on that table.


I created the linked server in this way

EXEC sp_addlinkedserver
@server = 'MYDBF',
@provider = 'VFPOLEDB',
@srvproduct = 'My Data',
@datasrc = 'c:\data'

i did not create the login since my SQL instance is running under a superaccount with all privilege.

What frustrates me is that i can read most of the dbf files, but just a few of them is not readable.

Can anyone give me some hints on it?

by the way, i am using vfp9.0

thanks

michael




Huangdashi
Starting Member

USA
2 Posts

Posted - 06/07/2007 :  12:38:17  Show Profile  Reply with Quote
further test gives me additional error messages

if i use openquery, i get the different message

OLE DB provider "VFPOLEDB" for linked server "MYDBF" returned message "Unspecified error".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "VFPOLEDB" for linked server "MYDBF".

In fact, if i test on other machines with the same setup (vfp 9.0 driver), i also get the info that the DBF file is corrupted.

Any suggestions on this issue?

Thanks

Michael
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/08/2007 :  00:50:33  Show Profile  Reply with Quote
Did you map sql login to dbf user? Or say does sql service account have permission in dbf?
Go to Top of Page

fyz
Starting Member

China
4 Posts

Posted - 06/03/2008 :  00:57:57  Show Profile  Reply with Quote
Hi,

You may need to replace your dbf file with a backup. If you don't have any backup, I think you can try some repair tools. I have used a tool called Advanced DBF Repair to repair my DBF database. I think you can just try the free demo at http://www.datanumen.com/adr/.

Just post to hope this still can be useful.


fyz
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/03/2008 :  15:53:06  Show Profile  Reply with Quote
You need promote your tool?
Go to Top of Page

daspeac
Starting Member

4 Posts

Posted - 11/10/2009 :  09:39:00  Show Profile  Reply with Quote
Hi rmiao. No, you are wrong, such tools often help. For example, I recommend trying the repair dbf file application that can be found at: http://www.recoverytoolbox.com/visual_foxpro_dbf_repair_tools.html and comparing it with this tool. make your opinion, which one works faster and recovers more data

Edited by - daspeac on 11/10/2009 09:40:13
Go to Top of Page

Houssine
Starting Member

USA
4 Posts

Posted - 05/22/2012 :  08:09:52  Show Profile  Reply with Quote
I just read this. As you mentioned that most of your DBF files are readable but few are unreadable. I think those files of your which seem unreadable are corrupt. Just one thing always keep in your mind that corruption can make a file unreadable or useless. And due to this file becomes inaccessible. Any corrupt or damaged file can't be accessed until it gets fully repaired. All you need just remove the error from your DBF files and after doing this you can access those corrupt files. The data inside those files will be readable right after you repair them. You just need to consider about a software program or shall I suggest you about a tool which I have used?

Check this one: "SysInfoTools DBF Recovery" tool.

It will help you as it helped me. Just try its demo version to see the preview of the content of the files which are unreadable.

Thanks.

Edited by - Houssine on 02/12/2014 04:42:33
Go to Top of Page

TekTel_99
Starting Member

India
1 Posts

Posted - 07/04/2012 :  02:48:41  Show Profile  Reply with Quote
"Kernel recovery for DBF" is very proficient tool that effectively repairs DBF files for both severe and minor corruption. The utility is provided with the advanced algorithms that ensures efficient data recovery from the corrupt database files. The Kernel recovery for DBF should be used to retrieve data from the inaccessible or damaged DBF files. The utility performs deep scan of the system to find the all DBF files. To know more about the tool visit unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000