Hi,

i have a an infopath form in which i create an insert query in code and than
execute the query through infopath dataconnection. My code looks like this:

//Execute all queries
            ADOAdapterObject adaptRates =
(ADOAdapterObject)doc.DataObjects["Rates"].QueryAdapter;
            string strSQLOriginalRates = adaptRates.Command.ToString();
            IEnumerator myEnumerator = QueryArray.GetEnumerator();
            while ( myEnumerator.MoveNext() )
            {
                adaptRates.Command = myEnumerator.Current.ToString();
                adaptRates.Query();
            }       
            //Set original query back
            adaptRates.Command = strSQLOriginalRates;
            adaptRates.Query();

I have created an array which contains several insert statements to execute.
I have a development environment where it works. I have created another dev
environment on another machine. But somehow the insert query does not
executes. But the "adaptRates.Query();" command executes just fine.I use the
same user rights for the sql database. What am i overlooking here or is there
something else wrong?

Thnx,

Stanley