Access dbf file across different network using ODBC connection

Asked By sthummala 10 points N/A Posted on - 03/30/2013

 

Hi, 

I succeed when I try to access .dbf file in the same application, but I'm getting error when I try to access .dbf file across the different network using ODBC connection. Can you please help me how to access dbf file among different network using ODBC connection??

• Status: Open
• Question Views: 681
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Jose D Dunn 10 points N/A #177725

Access dbf file across different network using ODBC connection

Greetings Sthummala,

How are you today? I hope you are fine. Regarding to your question I think you have a little problem in your connection. Here is the solution to your problem:

1. Add a new OLE DB connection manager.

2. Select Native OLE DB Microsoft Jet 4.0 OLE DB Provider as the Provider in the Connection page of the Connection Manager.

3. Browse the DBF file and then remove the file name in the end of the folder path you have selected.

4. Enter dBASE III, dBASE IV or dBASE 5.0 as appropriate and as the value of Extended Properties in all of Connection Manager dialog box.

5. Click Test Connection. A "Test connection succeeded" should appear and then click OK.

I hope this will solve your problem. Thanks.

About Jose D Dunn

Questions
11

Answers
102

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 04/30/2013
• Question Category: Database