How Can I repair dbf file

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
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

1 response

Blocked Profile
May 28, 2015 at 05:02 PM
The foxpro driver in ADO should work.

What does your code look like for the connection? It should look like this (with your variables).

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!