Ole provider connection String

[neogeo]

I am trying to read a DBF from ASP.NET page, this is the code that I a
using.....

Dim myConn As Ne
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Dat
Source=C:\capitaltest\data;Expanded Properties=dBase IV")

myConn.Open()

Dim myCommand As New OleDbCommand("Select * from stock", myConn)

Dim reader As OleDbDataReader
reader = myCommand.ExecuteReader()
myConn.Close()

I get the following error ->>> Could not find installable ISAM

If the code is changed to the following...
Dim myConn As Ne
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Dat
Source=C:\capitaltest\data\stock.dbf;")
myConn.Open()

Dim myCommand As New OleDbCommand("Select * from stock", myConn)

reader = myCommand.ExecuteReader()
myConn.Close()

I get this type of error ->>>>
Unrecognized database format 'C:\capitaltest\data\STOCK.DBF'

Can anyone please help!!


-
neoge

 

[Simon Gorski]

Hello Neogeo,

I am trying to read a DBF from ASP.NET page, this is the code that I am
using.....

Dim myConn As New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\capitaltest\data;Expanded Properties=dBase IV")

myConn.Open()

Dim myCommand As New OleDbCommand("Select * from stock", myConn)

Dim reader As OleDbDataReader
reader = myCommand.ExecuteReader()
myConn.Close()

I get the following error ->>> Could not find installable ISAM

If the code is changed to the following...
Dim myConn As New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\capitaltest\data\stock.dbf;")
myConn.Open()

Dim myCommand As New OleDbCommand("Select * from stock", myConn)

reader = myCommand.ExecuteReader()
myConn.Close()

I get this type of error ->>>>
Unrecognized database format 'C:\capitaltest\data\STOCK.DBF'

Can anyone please help!!!

Read
http://dbforums.com/arch/212/2002/11/556668



mfg simon g.