No announcements
Found 2433723 threads
-
2 VotesHelp with record source statement
record sets and doesn't work for others. If I remove it, it still seems to work fine. Will do more testing This project has to do with ...Answered | 5 Replies | 116 Views | Created by tkosel - Wednesday, January 3, 2018 5:37 PM | Last reply by .theDBguy - Wednesday, January 3, 2018 7:09 PM
-
0 Votes
binding source primary key
hi i have two binding sources on a form i have navigated one binding source with other with this statement ...Answered | 1 Replies | 3638 Views | Created by fazee - Wednesday, October 10, 2007 11:03 AM | Last reply by Vilsad - MCTS - Thursday, October 11, 2007 7:34 AM -
0 Votes
Informix to SQL Server - EIX000: (-107) ISAM error: record is locked.
, using OLE DB drivers. Quite often, the load fails with "An OLE DB record is available. Source: "Ifxoledbc" Hresult: 0x80004005 Description: ...Answered | 3 Replies | 6622 Views | Created by madion - Wednesday, December 7, 2011 7:34 PM | Last reply by ArthurZ - Thursday, December 8, 2011 7:21 PM -
0 Votes
Foreign Key issue
; Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E2F Description: "The INSERT statement conflicted with the FOREIGN ...Answered | 2 Replies | 2435 Views | Created by bgeregach - Wednesday, April 10, 2013 7:05 PM | Last reply by bgeregach - Wednesday, April 10, 2013 7:49 PM -
0 Votes
How do I move a selected record to the top of a form in Datasheet view after returning from another form?
selected Job Number to the top of the datasheet, followed by jobs that are listed after. The Datasheet form Record Source property is a sql ...Answered | 1 Replies | 719 Views | Created by smsemail - Wednesday, March 20, 2013 7:18 PM | Last reply by QA Guy CommElec - Wednesday, March 20, 2013 8:40 PM -
1 Votes
Generate XML File and use Bulk Insert to extract data from flat files with help of XML File
; WITH (FORMATFILE = '\\Servername\Folder\Product.xml') Finally, BULK Insert statement will help you to insert ...Discussion | 1 Replies | 7812 Views | Created by Maruthi Siva Prasad VM (MCP,MCSA,MCTS) - Wednesday, January 12, 2011 6:26 AM | Last reply by Alex Feng (SQL) - Wednesday, January 19, 2011 12:05 PM -
0 Votes
Problem with SQL Server 2005 > Visual FoxPro Free Tables
OLE DB Source with an SQL command to select the data I want, and I have it feeding into an OLE DB Command transformation. I've assigned the VFP connection to the OLE DB Command, but ... -
0 Votes
Modify query in Mail Merge in a Word document
, you can include the SELECT statement when you hook up to the data source. For any more detailed support, I recommend the newsgroup, as it's been quite a while ...Answered | 1 Replies | 2746 Views | Created by Brad SDS - Thursday, August 6, 2009 8:41 PM | Last reply by Cindy Meister MVP - Friday, August 7, 2009 4:28 PM -
0 Votes
UPDATE Statement with a JOIN Condition
the first record of the temp table and does not update the quantity of the second record from tne source table. I woould appreciate any help on ...Answered | 3 Replies | 21129 Views | Created by Jothivel - Friday, June 30, 2006 8:29 PM | Last reply by Umachandar Jayachandran - MS - Friday, June 30, 2006 8:57 PM -
0 Votes
[UWP]Comparison of Integers - localsettings and JToken
new Item has come in, regardless of date scheduled. Want to compare that value to incoming records, and when a record comes in with a higher ID value, trigger a ...Proposed | 1 Replies | 443 Views | Created by Devin McMahon - Sunday, November 13, 2016 4:29 PM | Last reply by Magnus (MM8) - Sunday, November 13, 2016 8:02 PM -
0 Votes
Data Collector Error
code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 ...Unanswered | 2 Replies | 1345 Views | Created by kccrga - Thursday, July 16, 2015 5:01 AM | Last reply by kccrga - Tuesday, July 21, 2015 2:23 AM -
0 Votes
Populating OLEDB connectionstring with variable value
: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. Source: "Microsoft OLE DB ...Answered | 1 Replies | 2284 Views | Created by youranonymous2727 - Friday, August 3, 2012 2:24 PM | Last reply by youranonymous2727 - Friday, August 3, 2012 3:30 PM -
0 Votes
SSIS Clustering Doubts
;Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.". An OLE DB record is available. ...Unanswered | 1 Replies | 4814 Views | Created by AGuerreiro - Monday, January 15, 2007 5:57 PM | Last reply by Andy Leonard - Tuesday, January 16, 2007 2:48 AM -
0 Votes
Problem while trying to execute oracle parameterized stored procedure using SSIS
following error: An OLE DB error has occured. Error Code : 0x80040E51. An OLE DB record is available. Source: OraOLEDB Hresult : ...Unanswered | 1 Replies | 3465 Views | Created by Iram - Thursday, May 31, 2007 9:55 AM | Last reply by Sun Moon - Friday, June 15, 2007 6:56 PM -
0 Votes
Custom Conflict Resolver Handling of Upload Insert/Update Failures
caused by a subscriber record being inserted/updated with a foreign key reference to a record that has been deleted at the publisher. For example, my database includes a ...Answered | 1 Replies | 5871 Views | Created by chrishilton - Thursday, October 9, 2008 2:47 PM | Last reply by chrishilton - Wednesday, December 10, 2008 3:33 PM -
0 Votes
Cannot Avoid Duplicate records
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "The statement ...Answered | 2 Replies | 5804 Views | Created by priyapinky - Monday, June 14, 2010 6:26 PM | Last reply by Uri Dimant - Tuesday, June 15, 2010 5:49 AM -
0 Votes
Problem with record source
Instead of setting the record source of the form, you could leave the record source alone, and filter the form. Pseudo code for a command button ...Answered | 1 Replies | 1728 Views | Created by DylanBaxter - Tuesday, November 1, 2011 10:22 PM | Last reply by Hans Vogelaar MVP - Tuesday, November 1, 2011 10:50 PM -
0 Votes
Inconsistent result using Data Reader source to get data from DB2
an infinite loop mode. though my query is not a procedure, it is just a sql statement. But this ssis pkg with the query runs absolutly fine on the other server. I aslo tried ...Answered | 4 Replies | 4269 Views | Created by Jinita Jain - Tuesday, April 22, 2008 3:04 AM | Last reply by Jinita Jain - Thursday, May 1, 2008 1:14 AM -
0 Votes
problem in inserting a record
table with same User ID . i am getting following error The data in row 1 was not committed. Error Source: .Net SqlClient ...Answered | 6 Replies | 3880 Views | Created by onjus - Saturday, July 30, 2011 8:28 AM | Last reply by Erland Sommarskog - Saturday, July 30, 2011 10:07 PM -
1 Votes
Help with Update statement
The final result should be: Need help with the Update statement CREATE ...Answered | 1 Replies | 2029 Views | Created by Meir1 - Thursday, November 3, 2011 9:18 AM | Last reply by Rishabh K - Thursday, November 3, 2011 9:24 AM - Items 1 to 20 of 2433723 Next ›
No announcements
