How Can I repair dbf file
Closed
PeterHig
Posts
1
Registration date
Thursday May 28, 2015
Status
Member
Last seen
May 28, 2015
-
May 28, 2015 at 02:31 PM
Blocked Profile - May 28, 2015 at 05:02 PM
Blocked Profile - May 28, 2015 at 05:02 PM
Hello I am a visual basic programmer and I know nothing about foxPro. I am given a dbf file I do not the dbase version . I need to develop an vb application what will work on it and insert data into the sql server database. I have download the foxPro driver to use with ADO . While I am trying to access the file I got err msg saying unrecognised datbase format.
How can I work on it ? And develop the application so that user does not face such problems so on as he will use the software to process his data from an foxpro application which is used by other department
Best regards
How can I work on it ? And develop the application so that user does not face such problems so on as he will use the software to process his data from an foxpro application which is used by other department
Best regards
Related:
- Dbf recovery
- Badoo account recovery - Guide
- Acer recovery management download - Guide
- Toshiba satellite c40 c 10q recovery - Laptop Forum
- Ps3 recovery mode without controller - Guide
- Rocketmail account recovery ✓ - Yahoo Mail Forum
1 response
The foxpro driver in ADO should work. 
What does your code look like for the connection? It should look like this (with your variables).
I have said it once, I will say it again. IT!
What does your code look like for the connection? It should look like this (with your variables).
dbsource="c:\wwwroot\DATA\e1.mdb"
strServername = LCase(Request.ServerVariables("SERVER_NAME"))
Set conn = CreateObject("ADODB.CONNECTION")
set rsdev = CreateObject("ADODB.recordset")
'Open the database for queries
strcxn="Provider=Microsoft.Jet.OLEDB.4.0;User ID=admin;Data Source=" & dbsource & ";Persist Security Info=False"
conn.Open strcxn
I have said it once, I will say it again. IT!
