vfpoledb.1 and Microsoft.Jet.OLEDB.4.0

Markus McGee · Joined: 04 Oct 2007 Posts: 1

Hello all,

I have a strange issue regarding vfpoledb and Microsoft JET Engine OLEDB. I
posted a couple of questions regarding why I can't use ADO and the ADO Update
command to load more than 30 records into a FoxPro table. When I changed
from VFPOLEDB to Microsoft JET OLEDB it works. I am using VB.NET to code
this information in. I am wondering if there are issues using VFPOLEDB and
plan ADO 2.7 . My guess is that VFPOLEDB is geared more toward ADO.NET.
Wondering if I am correct.

Markus McGee

Archived from group: microsoft>public>vb>ole

Paul Clement · Joined: 04 Oct 2007 Posts: 1560

On Tue, 18 Jan 2005 11:55:07 -0800, Markus McGee
wrote:

¤ Hello all,
¤
¤ I have a strange issue regarding vfpoledb and Microsoft JET Engine OLEDB. I
¤ posted a couple of questions regarding why I can't use ADO and the ADO Update
¤ command to load more than 30 records into a FoxPro table. When I changed
¤ from VFPOLEDB to Microsoft JET OLEDB it works. I am using VB.NET to code
¤ this information in. I am wondering if there are issues using VFPOLEDB and
¤ plan ADO 2.7 . My guess is that VFPOLEDB is geared more toward ADO.NET.
¤ Wondering if I am correct.
¤
¤ Markus McGee

If you don't get an answer here you may want to repost in one of the following
groups:

microsoft.public.vb.database
microsoft.public.vb.database.ado

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Microsoft OLE DB Pro | [Microsoft][ODBC Driver Manager] Driv Hi, I have a project maked in VBasic 6.0 and recently have testet on a XP Professional system but I hahe got a error Message ! Until this it worked very nice on Win2000 systems . I have the same version of MDAC 2.7 on both, on W2k and on XP. On XP syste

Export Data to Microsoft Project Hi, I want to export data (tasks) from my Webpage to Microfsoft project file (.mpp) using VB Script. Please suggest me how to do this.. Any code samples.. Thanks in Advance Regards, -- Srini

How to deploy application which uses Microsoft.Jet.OLEDB.4.0 Hi, I want to minimze my installtion size,and i wonder is it possible to include specific OLD DB,ADO files? I dont need MDAC i just need the files for ACCESS 2000\JET 4.0 Thanks in advance

ado-sql-oledb Hi Im using VB6,ADO, OLEDB and SQL Server 2000/2005 On any SQL error the error number from Error is -2147221504 How to get the "real" error number to specifiy error For example if "Time Out" happens then error is 10021 or something aso. regards; Mex

SQL Server 2000 to Text File Using Jet OLEDB Provider Of VB6 Hello, I am trying to export a SQL Server table data to a text file and have written the following code. It comes up with a message "Syntax Error In the From clause": Dim objConnToText As strSQL as String Set objConnToText = New ADODB.C