J
JeffP@Laptop
Error at Open() - Driver does not support this function
I've tried the OLEdb driver with similar failure, different error but
basically I cannot Open using the Foxpro driver(s)
Any clues?
..... snipit
Dim sDB As String = "c:\Apps\R2M\Data"
Dim sConn As String = "Driver={Microsoft Visual Foxpro
Driver};SourceType=DBC;SourceDB=" & sDB & ";"
Dim Cnn As New OdbcConnection(sConn)
'Driver does not support this function...
Cnn.Open()
Dim sCmd As String = "set Exclusive on;select * from items;pack"
Dim dbCmd As New OdbcCommand(sCmd, Cnn)
dbCmd.ExecuteNonQuery()
TIA
JeffP.....
FYI this works and inserts the data into the items.dbf datafile.
..... snipit
Dim sDB As String = "c:\Apps\R2M\Data"
Dim sConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & sDB & ";Extended Properties=dBASE 5;"
Dim cnn As New OleDbConnection(sConn)
Dim sCmd As String = "insert into items values(1001 ,'Tower Spat'
,'061001' ,13.64 ,26.99)"
Dim da As New OleDbDataAdapter(sCmd, cnn)
Dim ds As New DataSet
da.Fill(ds)
I've tried the OLEdb driver with similar failure, different error but
basically I cannot Open using the Foxpro driver(s)
Any clues?
..... snipit
Dim sDB As String = "c:\Apps\R2M\Data"
Dim sConn As String = "Driver={Microsoft Visual Foxpro
Driver};SourceType=DBC;SourceDB=" & sDB & ";"
Dim Cnn As New OdbcConnection(sConn)
'Driver does not support this function...
Cnn.Open()
Dim sCmd As String = "set Exclusive on;select * from items;pack"
Dim dbCmd As New OdbcCommand(sCmd, Cnn)
dbCmd.ExecuteNonQuery()
TIA
JeffP.....
FYI this works and inserts the data into the items.dbf datafile.
..... snipit
Dim sDB As String = "c:\Apps\R2M\Data"
Dim sConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & sDB & ";Extended Properties=dBASE 5;"
Dim cnn As New OleDbConnection(sConn)
Dim sCmd As String = "insert into items values(1001 ,'Tower Spat'
,'061001' ,13.64 ,26.99)"
Dim da As New OleDbDataAdapter(sCmd, cnn)
Dim ds As New DataSet
da.Fill(ds)