I am very new to foxpro file extraction programming using vb.net
plz help for following scenario.
I have a foxpro files of file extension
1) FOXUSER.DBF: which contains fields such as Type,Id,Name,Readonly,CkVal,
Data,Updated.
2) FOXUSER.FPT:fields same as above
3) Data_Needed.DBF :Contains fields such as
EmployeeID,EmployeeName,EmpolyeeAddress
I have created a function for selecting data from the foxpro file Data_Needed.DBF
But it gives error
"The Microsoft Jet database engine could not find the object 'Data_Needed'. Make sure the object exists and that you spell its name and the path name correctly."
I have troubleshooted a lot but no use although the files are present there in the location
my function is as below
==========================================
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:DATA NeededData_Needed;Extended Properties=dBase III"
Dim dBaseConnection As New System.Data.OleDb.OleDbConnection(connectionString)
dBaseConnection.Open()
Dim dBaseCommand As New System.Data.OleDb.OleDbCommand("SELECT * FROM Data_Needed", dBaseConnection)
Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader = dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)
While dBaseDataReader.Read
ComboBox1.Items.Add("" & dBaseDataReader("EmployeeName") & "")
End While
dBaseConnection.Close()
==========================================================
Please Help me finding a solution
Thanks in Advance for all
Jiendra
Comments
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:DATA NeededData_Needed.DBF;Extended Properties=dBase III"
:
: I am very new to foxpro file extraction programming using vb.net
: plz help for following scenario.
:
: I have a foxpro files of file extension
:
: 1) FOXUSER.DBF: which contains fields such as
: Type,Id,Name,Readonly,CkVal,
: Data,Updated.
:
: 2) FOXUSER.FPT:fields same as above
:
: 3) Data_Needed.DBF :Contains fields such as
: EmployeeID,EmployeeName,EmpolyeeAddress
:
: I have created a function for selecting data from the foxpro file
: Data_Needed.DBF
:
: But it gives error
:
: "The Microsoft Jet database engine could not find the object
: 'Data_Needed'. Make sure the object exists and that you spell its
: name and the path name correctly."
:
: I have troubleshooted a lot but no use although the files are
: present there in the location
:
: my function is as below
:
: ==========================================
: connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
: "Data Source=D:DATA NeededData_Needed;Extended
: Properties=dBase III"
:
: Dim dBaseConnection As New
: System.Data.OleDb.OleDbConnection(connectionString)
:
: dBaseConnection.Open()
:
: Dim dBaseCommand As New
: System.Data.OleDb.OleDbCommand("SELECT * FROM Data_Needed",
: dBaseConnection)
:
: Dim dBaseDataReader As System.Data.OleDb.OleDbDataReader =
: dBaseCommand.ExecuteReader(CommandBehavior.SequentialAccess)
:
: While dBaseDataReader.Read
:
: ComboBox1.Items.Add("" & dBaseDataReader("EmployeeName")
: & "")
:
: End While
:
: dBaseConnection.Close()
:
:
: ==========================================================
:
:
: Please Help me finding a solution
:
: Thanks in Advance for all
: Jiendra
:
:
:
:
:
:
: