As a side note - I did finally discover what the problem was with the aide of the ODBC Tracker - it showed me exactly what statement was failing - the parameter, etc....

The problem is that many countries around the world store their numbers in a different way. Instead of storing a decimal with a period - for instance .7 - their decimals are stored with a comma - ,7. Thus my problem - sending a decimal to my global server as ,7 instead of .7.

This is all based on their regional settings - so when I would bring their local data file over to my machine where the regional settings are different - it would work because it would send it to the global server with a period instead of a comma.

So now I know what the problem is - I have several different options for attacking it - more on that in a different post. :-)