Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  ODBC Connection error

Author  Topic  burt247 Starting Member 2 Posts Posted - 2010-08-03 : 14:51:57 I'm getting the following ODBC connection error when I try and run a package that was created in Visual Studio. When I run this in visual studio it populates the table without error. I'm having the problem when I try to run it in SQL Server Agent, that's when I get the error below: Code: 0xC0047062 Source: Data Flow Task DataReader Source [1] Description: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) at System.Data.Odbc.OdbcConnectionFactory. Any suggestions on how to fix this?