Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > dBase VFP OleDb or ODBC Drivers

Reply
Thread Tools

dBase VFP OleDb or ODBC Drivers

 
 
JeffP@Laptop
Guest
Posts: n/a
 
      01-25-2006
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)



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
oledb connect to vfp Agnes ASP .Net 0 09-07-2006 04:23 AM
OLEDB + VFP DATABASE Agnes ASP .Net 1 09-04-2006 04:43 PM
fail to connect vfp odbc Agnes ASP .Net 1 08-27-2006 03:14 PM
odbc with vfp Agnes ASP .Net 1 08-17-2006 03:55 PM
Update a dBase dbf-7 table using OleDB .NET Aurelio ASP .Net 0 01-02-2006 08:13 PM



Advertisments