Please specify how are you connecting ? I am not sure what exactly you mean by The database is being detected but not the tables inside the database.
debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
change your code to a simple select statement on the given tables. Also see if your script works in management studio without any issues. It might be the syntax of your code.
moone009
Junior Poster in Training
97 posts since Mar 2010
Reputation Points: 10
Solved Threads: 1