InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 01:43:19 GMT20http://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspxThe problem [i]could[/i] be that you don't have 64 bit drivers installed. Packages run in BIDS as a 32 bit process (last time I used it), which can only 'see' the 32 bit hive of the registry (containing DSN's)Then if you run the package in 64 bit (which is generally the default under SQL Agent), the process only see the 64 bit hive of thre registry, which does not contain your DSN (or driver).So try running the package in 32 but mode. Here's a link that may help.http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspxNone of the clues you have given actually indicate this issue but it's the first thing I thought of when I saw your error message.If you could post more information about your configuration it would help everyone.Mon, 31 Dec 2012 18:01:47 GMTnick.mcdermaidhttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspx[quote][b]Jon Jaroska (12/28/2012)[/b][hr]The package does not run in the sql agent, it fails. Also the package runs perfect in BIDS. Here is the full text of the error:There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.The AcquireConnection method call to the connection manager glxy_epace.epace_read failed with error code 0xC0014009.[/quote]OK - but I asked whether the package ran in BIDS [b]on the server[/b]. Can you try logging in as the user under which the SQL Agent service is running and then executing the package in BIDS again (on the server)?Fri, 28 Dec 2012 09:12:35 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspxThe package does not run in the sql agent, it fails. Also the package runs perfect in BIDS. Here is the full text of the error:There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.The AcquireConnection method call to the connection manager glxy_epace.epace_read failed with error code 0xC0014009.Fri, 28 Dec 2012 08:33:37 GMTJon Jaroskahttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspx[quote][b]Jon Jaroska (12/26/2012)[/b][hr]I have successfully deployed my first package to sql 2012. The package runs fine in visual studio but when deployed it gets an error message saying there was an error trying to establish an odbc connection to the database. Anybody encounter this and does anybody have a solution?[/quote]Did the package run as a SQL Agent job?Can you post the full text of the error message?As you have VS installed on the server, can you confirm that you can run the package using BIDS on the server? If so, I would be looking at possible permissions issues first.Fri, 28 Dec 2012 02:13:08 GMTPhil Parkinhttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspxThere does appear to be OLEDB providers for PostgreSQL ( [url]http://www.postgresql.org/about/news/1153/[/url] ), but that doesn't answer your immediate question. Sorry I couldn't be more help.RobThu, 27 Dec 2012 11:50:15 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspxIts PostgreSQLThu, 27 Dec 2012 08:32:08 GMTJon Jaroskahttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspx[quote][b]Jon Jaroska (12/27/2012)[/b][hr]Visual studio is installed on the server where sql server resides. The DSN is setup on the machine and running the package in debug mode works. I have to assume that permissions are correct because it runs this way.[/quote]Well no luck there. Hmm -- any reason you're using ODBC rather than an OLE DB provider? What is the data source you're connecting to?RobThu, 27 Dec 2012 07:55:33 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspxVisual studio is installed on the server where sql server resides. The DSN is setup on the machine and running the package in debug mode works. I have to assume that permissions are correct because it runs this way.Thu, 27 Dec 2012 07:48:38 GMTJon Jaroskahttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspx[quote][b]Jon Jaroska (12/26/2012)[/b][hr]I have successfully deployed my first package to sql 2012. The package runs fine in visual studio but when deployed it gets an error message saying there was an error trying to establish an odbc connection to the database. Anybody encounter this and does anybody have a solution?[/quote]I've not done much yet with SSIS 2012, but here are questions that immediately come to mind: Are you running Visual Studio on your development machine? Do you have a DSN setup to the DB on your development machine? Is this same DSN setup on the server where you deployed the SSIS package? Does the account that the SSIS package run on the server have permissions to the database?I hope this helps,RobWed, 26 Dec 2012 22:45:06 GMTrobert.gerald.taylorhttp://www.sqlservercentral.com/Forums/Topic1400298-364-1.aspxI have successfully deployed my first package to sql 2012. The package runs fine in visual studio but when deployed it gets an error message saying there was an error trying to establish an odbc connection to the database. Anybody encounter this and does anybody have a solution?Wed, 26 Dec 2012 10:25:26 GMTJon Jaroska