vb to oracle connectivity

I would start by having a read of these.

Oracle and ADO.NET[^]

Google: VB.NET DBF format[^]

If you need more help after then please post some code and we'll try to help you more.

If you are using VB.Net, there are a lot of DataProviders can be used.

There is also for Oracle,

For Standard Security

oConn.Open ";Provider=OraOLEDB.Oracle;"; & _
";Data Source=MyOracleDB;"; & _
";User Id=myUsername;"; & _
";Password=myPassword";


For a Trusted Connection

oConn.Open ";Provider=OraOLEDB.Oracle;"; & _
";Data Source=MyOracleDB;"; & _
";User Id=/;"; & _
";Password=";

' Or

oConn.Open ";Provider=OraOLEDB.Oracle;"; & _
";Data Source=MyOracleDB;"; & _
";OSAuthent=1";

Note: ";Data Source="; must be set to the appropriate Net8 name which is known to the naming method in use. For example, for Local Naming, it is the alias in the tnsnames.ora file; for Oracle Names, it is the Net8 Service Name.

For more information, see: Oracle Provider for OLE DB Developer's Guide

OLE DB Provider for Visual FoxPro

oConn.Open "Provider=vfpoledb;" & _
"Data Source=C:\vfp7\Samples\Data\myVFPDB.dbc;" & _
"Mode=ReadWrite|Share Deny None;" & _
"Collating Sequence=MACHINE;" & _
"Password=''"

For more information, see: Microsoft OLE DB Provider for Visual FoxPro

Note: The Visual FoxPro OLE DB Provider is NOT installed by MDAC 2.x. You must install Visual FoxPro 7.0 in order to get it's OLE DB Provider.

Source: .NET Data Provider Connections