Hi, I am trying to create an ODBC coonection to postgre in SSRS. I succeeded to create the connection (when I test it I get a message that this is succeeded), but when I try to run a simple query (select * from table) it failed and I got the next error: "db_e_errorsincommand" Can you please advise me, Thanks

What if you do 3-part naming? SELECT * FROM dbname.owner.table -- T-SQL syntax Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM

Hi, I try it but it didn't work. can you please advise me, Thanks

Can you setup a linked server connection and test it? Linked server setup example: http://www.sqlusa.com/bestpractices2005/linkedservertooracle/ You can also set it up from Object Explorer. Use OPENQUERY to run SELECTs. Kalman Toth, SQL Server & BI Training; SQL 2008 GRAND SLAM

Hi Talunr, Basically, the cause of the issue could be related to the postgreSQL ODBC driver installed on the server. I would suggest you double-check if the driver is compatiable with the server OS Windows Server (2003, 2008 or 2008 R2) and the CPU architecture (e.g. x86 or x64). I did a quick search on Internet, and found postgreSQL ODBC driver website: http://psqlodbc.projects.postgresql.org/ Next, the error "db_e_errorsincommand" might not be related to SSRS itself, and I'd suggest you run a query over the ODBC connection directly to see if data result can be retrieved from postgreSQL database. If the problem still occurs, please kindly find support from PostgreSQL Help Forum: http://forums.devshed.com/postgresql-help-21/ Thanks, Eileen