I have just install Visual Basic Express 2005. Only database from MS Access and MS SQL can be link to this VB. Can any one tell me how to link to Visual Foxpro 6 database Thank you.
How to add Visual Foxpro Database into Visual Basic Express 2005
Hot Topic
- Publish Can't Find Redist Files
- Heeeelp
- registratiojn benefits are....where?
- Command Button Problem
- Call <STRING AS COMMAND>
- Visual Basic 2005 Express, MS Office 2007 Beta, and Excel .Net Reference
- Post Registering: Unable to reach Benefits Portal
- Registration
- SQL Query In VB Express 2005
- Is The OOP Microsoft.VisualBasic.IIf Equivalent To the Procedural If Then?
VS Express Editions
- hello???
- VB 5 to VB express ???
- How to create a code when I open OpenFileDialog
- CD Deployment using ClickOnce
- Help Please on Visual Express Database Saving
- ListBox
- how can I check if I have registered the product ?
- A reference to the "....dll" could not be added.Please make sure that the file is accessible and that it is a valid assembly or
- get pst path and overwriting the path from profile
- Arraylist and recursion problems
How to add Visual Foxpro Database into Visual Basic Express 2005
PaulvZyl
There are several methods you can try. If you use the OLEDB provider you may have to download it:
Microsoft OLE DB Provider for Visual FoxPro 9.0
Public Sub ConnectToFoxProODBC()
Dim ODBCConnection As Microsoft.Data.Odbc.OdbcConnection
Dim FoxProReader As Microsoft.Data.Odbc.OdbcDataReader
Dim sConnString As String = _
"Driver={Microsoft Visual FoxPro Driver};" & _
"SourceType=DBF;" & _
"SourceDB=C:\Documents and Settings\...\My Documents\My Database\FoxPro;" & _
"Exclusive=No;"
ODBCConnection = New Microsoft.Data.Odbc.OdbcConnection(sConnString)
ODBCConnection.Open()
Dim FoxProCommand As New Microsoft.Data.Odbc.OdbcCommand("Select * from FPDB", ODBCConnection)
FoxProReader = FoxProCommand.ExecuteReader
'...
'...
ODBCConnection.Close()
ODBCConnection = Nothing
End Sub
Public Sub ConnectToFoxProOLEDB()
Dim OleDbConnection As System.Data.OleDb.OleDbConnection
Dim FoxProReader As System.Data.OleDb.OleDbDataReader
'Database container
Dim sConnString As String = _
"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine"
'Free table
'Dim sConnString As String = _
' "Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general"
'ODBC DSN
'Dim sConnString As String = _
' "Provider=vfpoledb.1;DSN=MyDSN"
OleDbConnection = New System.Data.OleDb.OleDbConnection(sConnString)
OleDbConnection.Open()
Dim FoxProCommand As New System.Data.OleDb.OleDbCommand("Select * from Table", OleDbConnection)
FoxProReader = FoxProCommand.ExecuteReader
'...
'...
OleDbConnection.Close()
OleDbConnection = Nothing
End Sub
The OLEDB connection strings are from www.connectionstrings.com
Patrick_msdn
The data tools for the Express editions do not support Visual FoxPro. Only Access and SQL Server are supported. However, it is still possible to connect to a Visual FoxPro database using ADO.NET code.
tkt0099