mingch06

Now I develope some application with VB.NET 2005úČand I need some database fome .DBF file to be my databaseúČI wish to join these database to my SQL server.How to do

mingch06



Re: .NET Framework Data Access and Storage How can I adapt any DBF file to SQL Server 2005úČthere are any Provider ?

Cindy Winegarden

Hi !

You can download the FoxPro and Visual FoxPro OLE DB data provider from msdn.microsoft.com/vfoxpro/downloads/updates. You can use it to connect to your DBFs in VB or set up a linked server to the data in SQL Server.






Re: .NET Framework Data Access and Storage How can I adapt any DBF file to SQL Server 2005úČthere are any Provider ?

VMazur

Just an addition to Cindy's post. You could query data from DBF to the DataTable, then query data from SQL Server to another DataTable and you could join information on a client side using DataRelation.






Re: .NET Framework Data Access and Storage How can I adapt any DBF file to SQL Server 2005úČthere are any Provider ?

shippers06

db2 = New ADODB.Connection

dbConn = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=C:\PATH;Exclusive=NO;Collate=Machine;NULL=YES;DELETED=NO;BACKGROUNDFETCH=YES;"

db2.Open(dbConn)

i hope this can help... Provider for Free Tables





Re: .NET Framework Data Access and Storage How can I adapt any DBF file to SQL Server 2005úČthere are any Provider ?

mingch06

thanks a lot for all of your response



Re: .NET Framework Data Access and Storage How can I adapt any DBF file to SQL Server 2005úČthere are any Provider ?

mingch06

thanks a lot for your response