VB & Database, Resync method using Oracle OLEDB provider

Resync method using Oracle OLEDB provider

Author	Message
Rob Mitchel #1 / 3	Resync method using Oracle OLEDB provider (already posted once in microsoft.public.data.ado) Hi all, Any clues on how to make the Resync method work against Oracle? When using the Resync command, I am getting the error "Multiple-step operation generated errors. Check each status value." with the msdaora provider, and the error "Data provider or other service returned and E_FAIL status" with the oraOLEDB.Oracle provider. The initial query is something like SELECT a.Asset_Key, a.Customer_Key, a.Seq_No, c.Customer_Name FROM asset_access a, customers c WHERE a.Customer_Key = c.Customer_Key AND a.Asset_Key = 3033 The "Resync Command" property of the recordset I am using is like SELECT a.Asset_Key, a.Customer_Key, a.Seq_No, c.Customer_Name FROM asset_access a, customers c WHERE a.Customer_Key = c.Customer_Key AND a.Asset_Key = ? AND a.Customer_Key = ? AND a.Seq_No = ? where Asset_Key, Customer_Key, and Seq_No are the primary keys of the asset_access table. The "Unique Table" property of the recordset is set to "asset_access" Any help is appreciated. Rob M
Tue, 01 Feb 2005 11:43:15 GMT

Val Mazu #2 / 3	Resync method using Oracle OLEDB provider Hi, Is your recordset bound to any controls? If yes, then check if your query gets proper values for parameters. It is possible that it gets empty strings instead of numeric values. -- Val Mazur Microsoft MVP Quote: > (already posted once in microsoft.public.data.ado) > Hi all, > Any clues on how to make the Resync method work against Oracle? > When using the Resync command, I am getting the error "Multiple-step > operation generated errors. Check each status value." with the msdaora > provider, and the error "Data provider or other service returned and E_FAIL > status" with the oraOLEDB.Oracle provider. > The initial query is something like > SELECT a.Asset_Key, a.Customer_Key, a.Seq_No, c.Customer_Name > FROM asset_access a, customers c > WHERE a.Customer_Key = c.Customer_Key > AND a.Asset_Key = 3033 > The "Resync Command" property of the recordset I am using is like > SELECT a.Asset_Key, a.Customer_Key, a.Seq_No, c.Customer_Name > FROM asset_access a, customers c > WHERE a.Customer_Key = c.Customer_Key > AND a.Asset_Key = ? AND a.Customer_Key = ? AND a.Seq_No = ? > where Asset_Key, Customer_Key, and Seq_No are the primary keys of the > asset_access table. > The "Unique Table" property of the recordset is set to "asset_access" > Any help is appreciated. > Rob M
Tue, 01 Feb 2005 20:06:46 GMT

Patrick van Oostru #3 / 3	Resync method using Oracle OLEDB provider Quote: >-----Original Message----- >(already posted once in microsoft.public.data.ado) >Hi all, >Any clues on how to make the Resync method work against Oracle? >When using the Resync command, I am getting the error "Multiple-step Quote: >operation generated errors. Check each status value." with the msdaora >provider, and the error "Data provider or other service returned and E_FAIL >status" with the oraOLEDB.Oracle provider. >The initial query is something like > SELECT a.Asset_Key, a.Customer_Key, a.Seq_No, c.Customer_Name > FROM asset_access a, customers c > WHERE a.Customer_Key = c.Customer_Key > AND a.Asset_Key = 3033 >The "Resync Command" property of the recordset I am using is like > SELECT a.Asset_Key, a.Customer_Key, a.Seq_No, c.Customer_Name > FROM asset_access a, customers c > WHERE a.Customer_Key = c.Customer_Key > AND a.Asset_Key = ? AND a.Customer_Key = ? AND a.Seq_No = ? >where Asset_Key, Customer_Key, and Seq_No are the primary keys of the >asset_access table. >The "Unique Table" property of the recordset is set to "asset_access" >Any help is appreciated. >Rob M >. Hi, I am not sure this will help but E_FAIL occurs when the datatype send to the database does not match the datatype of the column. Perhaps your sending chars to a numeric field? Patrick
Fri, 04 Feb 2005 21:46:39 GMT

Page 1 of 1

[ 3 post ]