By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,994 Members | 2,036 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,994 IT Pros & Developers. It's quick & easy.

Multiple-step OLEDB operation generated errors

100+
P: 103
Multiple-step OLEDB operation generated errors.Check each OLE DB status value,if available.No work was done



what i ahve to check?

And the code is
(VB)
rs.Open "select distinct empdetail.name,saldetail.id from empdetail,saldetail where saldetail.id = empdetail.id", conn, adOpenStatic, adLockOptimistic

PLS Help,thanks in advance
Jan 23 '08 #1
Share this Question
Share on Google+
1 Reply


QVeen72
Expert 100+
P: 1,445
Hi,

Datatype for ID field in Both tables should be same..
example: In one table, the fieldtype is Numeric and in another it must be text..

Regards
Veena
Jan 23 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.