Search:   Namespaces Discussions .NET v1.1 Feedback

connecting to DBF file Messages   Related Types This message was discovered on ASPFriends.com 'ngfx-odbc' list. Krishna Tulasi -- Moved from [aspfreeforall] to [ngfx-odbc] by Let the good times roll <Click here to reveal e-mail address> -- Hi, Can someone tell me how to connect to a .dbf database file to extract info using VB.NET Apparently these connection strings dont work Dim strConnStr As String = "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\comcat.dbf" Dim strConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\comcat.dbf" Dim strConnStr As String = "DSN=temp" 'where temp is a System DSN made from ODBC Datasources ' of the type Microsoft dBASE Driver (*.dbf) conn = New OleDbConnection(strConnStr) cmd = New OleDbCommand("select * from tomcat", conn) Should I use OleDB at all ? Or something else completely .. Thanks Krishna Reply to this message...        Daniel Naumann Krishna, I don't know if you can use OLEDB for dBase, but I'm pretty sure you can use ODBC. It's an extra download that you can get here: http://msdn.microsoft.com/downloads/default.asp?url=/code/sample.asp?url=/msdn-f iles/027/001/668/msdncompositedoc.xml&frame=true Daniel. -----Original Message----- From: Krishna Tulasi [mailto:Click here to reveal e-mail address] Sent: 28-Jul-2002 05:52 To: ngfx-odbc Subject: [ngfx-odbc] connecting to DBF file -- Moved from [aspfreeforall] to [ngfx-odbc] by Let the good times roll <Click here to reveal e-mail address> -- Hi, Can someone tell me how to connect to a .dbf database file to extract info using VB.NET Apparently these connection strings dont work Dim strConnStr As String = "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\comcat.dbf" Dim strConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\comcat.dbf" Dim strConnStr As String = "DSN=temp" 'where temp is a System DSN made from ODBC Datasources ' of the type Microsoft dBASE Driver (*.dbf) conn = New OleDbConnection(strConnStr) cmd = New OleDbCommand("select * from tomcat", conn) Should I use OleDB at all ? Or something else completely .. Thanks Krishna | [ngfx-odbc] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-odbc.asp = JOIN/QUIT Reply to this message...     System.Data.OleDb.OleDbCommand System.Data.OleDb.OleDbConnection Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com