first i search on the wrong end of this problem.
So please read this Post for detailed informations.
My Problem ist simple but heavy.
My Command.Parameter Objects ignor there names und inserting herself only in the order the programm will get her.
Is it normal that parameter would be insert on the position in order who there get ?
Is the SQL String (i.e.):
select col0 from tbl1 where col1=:param1 and col2 =:param2;
So VB do that so:
1st param get: name "param1" value.....
2nd param get: name "param2" value....
It works fine!
1st param get: name "param2" value...
2nd param get: name "param1" value...
So VB will but the param "param2" on the col1 clausel and "param1" to the col2 clausel.