Bug #31851 Ado with sql dont work in VB6 on WinXP with SP2
Submitted: 25 Oct 2007 14:05 Modified: 26 Oct 2007 17:21
Reporter: denzel lisul Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Tests Severity:S7 (Test Cases)
Version: OS:Windows (with sp2)
Assigned to: CPU Architecture:Any

[25 Oct 2007 14:05] denzel lisul
Description:
Hi, 
maybe this is not a right place for this question!! i work in visual basic,
and i use ado conection between visual basic and access base (microsoft jet 4.0)
Problem is next: i use next code for connection and opening recordset

  dbBaza.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & AppPath & "baza.mdb;"

  Set rsSomething = New ADODB.Recordset
  rsSomething.Open "Something", dbBaza, adOpenStatic, adLockOptimistic

where somethning is table in base. in case when i use winXP +sp1 everything is OK; but when i use WinXP+SP2 then the error is 

Runtime error -2147217900
Invalid SQL Statment; expected 'DELETE', 'Insert' 

then i change last code in
  rsSomething.Open "SELECT * from Something", dbBaza, adOpenStatic, adLockOptimistic

but than there is next error Runtime error -214727865 Microsoft Jet engine could not find the object 'somethingelse', where something else is last col in base!!!

help me if you can

How to repeat:
abc
[26 Oct 2007 17:21] MySQL Verification Team
Thank you for the bug report.Your issue isn't related to MySQL products.