.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
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




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification