Database table is seemingly picky...

[datanibbler]

Hi,

what can be the reason that one app I have developed can access a certain table in a database no problem and another app - with a valid connection_string (it can access other tables in this DB) and the exact same (pasted) code cannot?

Thanks a lot!

Best regards,

DataNibbler

[bbi_mba_76]

HI,

which DB? are you using windows autentication?

[MayilVahanan]

Hi

Try like this

Connect to the database via script (Connection), without pasted code from another app

[datanibbler]

Thanks to you two,

I solved it now - it was of course in my code - there was a WHERE EXISTS clause and the filtering_table used in that clause was, in the app I was comparing to, IN FRONT of the tab with the code - of course it worked. In the app where the code didn't work, it was BEHIND - obviously it wouldn't work... just took me awfully long to realize.

Thanks a lot!

Best regards,

DataNibbler