Thank you for the reply, It seems like if I mention Informix everyone thinks its the devil. Here is the deal though, I have everything set up on one computer. I have SQL2005, Reporting Services 2005, Visual Studio 2005 all running on XP sp2. I have IIS 6.0 and the reporting site on the same computer. This is of course a dev system. When I am in VS2005 developing I can set a dsn using the informix odbc and I get connection to the informix database through the odbc. Then, I deploy the report to the report server (the same computer) and create a dsn using the same odbc connection. I get the reporting services error that it cannot connect to the database. So I am using the same odbc when developing and deploying but I only get connection when developing. I hope someone can explain this, I have been to many groups and no one has been able to provide a solution for a month.