Hi thanks for trying to help out. Well the connection works fine, as stated bofore if I use the same connection towards another table in the same db, with the same user it works. I have also checked permission on the table and there are no strange permissions and I use trused user on both ODBC and when connection via enteprise manager. But in enterprise manager I get a result

Comment on Re^2: DBI don't fetch my data...or at least not all records

thanks for the nice effort. However I think it's very strange that you get a result and I don't, hmm very annoying.
Anyway thanks once again, I don't have the time to spend more time on this issue ritht now I will do some stuff manually and if I need to access more of that data I will look at it again.
Cheers
Pär