ODBC connection failed

[Whitebat]

hi,
i have a weird problem. I have a query that is getting data out of oracle and stores it in an access2000 table. It is running on two machines on one machine its still working ( with the same query, same settings, same odbc drivers). on the other one it doesnt. there i get the odbc error. But the weird thing is i get results when i do a select * or a select null that is working. but as soon as i start selecting a field which i know is there, cause ive seen it in the select *, i get the odbc error again. Any suggestion what that might cause?
Its a german system.
And there is another weird thing. The oracle database is in english and the dateformat is in english so wouldnt you assume that any date you want to transfer with a pass through query should have the english date format ? Well i can tell you its not working for whatever reason it wants the german format on a german machine and the english date format on an english machine. Thats weird.
Thanks for all the replies i might get.
Thanks Whitebat

 

[tledwards]

I had a similar problem. I could see the data in a select query but when I changed it to an append query it would not work. I solved the problem by making two queries. A select query to identify the data. Then an append query based on the select query. Hope this helps.

 

[Whitebat]

Thanks for your reply. i dont know what the error caused but it worked just find on the next day without any changes Thanks Whitebat