ADO + SQL + FOXPRO Question/problem
-
Hello, I have a problem that i cannot solve. The problem shows up in XP, the code works fine in 98SE Please if you know the answer help me The code: conITEMS.Open "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDb=" & "D:\work\old" rsITEMS.CursorLocation = adUseClient rsITEMS.Open "SELECT * FROM STOCK", conITEMS, adOpenStatic, adLockPessimistic rsITEMS.MoveFirst rsITEMS.Find ("number = '2004'") This is where it fails with error = Run-time error '2147467259 (80004005)' "data provider or other service returned an E_FAIL status" Thank you in advance Ilya :(
-
Hello, I have a problem that i cannot solve. The problem shows up in XP, the code works fine in 98SE Please if you know the answer help me The code: conITEMS.Open "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDb=" & "D:\work\old" rsITEMS.CursorLocation = adUseClient rsITEMS.Open "SELECT * FROM STOCK", conITEMS, adOpenStatic, adLockPessimistic rsITEMS.MoveFirst rsITEMS.Find ("number = '2004'") This is where it fails with error = Run-time error '2147467259 (80004005)' "data provider or other service returned an E_FAIL status" Thank you in advance Ilya :(
Hi It is probably because VFP Drivers are not included in MDAC 2.6 and above. You can download this drivers from Microsoft Visual FoxPro page. Here is the link http://msdn.microsoft.com/vfoxpro/downloads/addons/odbc.asp Greeting Marek