Problem: SSIS, ODBC and Progress Database

Problem: SSIS, ODBC and Progress Database

• Ilan Bohbot

  Hi,

  Could you please share your experience with us

  Thanks

  
  
  

• HighDesertTech

  I had a similar issue, the error I was getting:

  "Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

  I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

  Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

  
  

• Joe Laden

  Jag,
  
  Thanks for the feedback. I do have all the parameter except pwd. Interesting thing, and I not the one who controls it, is no pwd. The best reason I have been explained is to do with Progress users verse OS user configuration. We are running MFGpro and there is concern about breaking it.
  
  I did not think about submitting a ticket to QAD. I guess felt it was more of a MS problem.I have OE 10 client and Datadirect 9D client installed. And I have both connecting and working in one package I created. At this point, I cannot even add another conection that is pointing to the ODBC connection that works. So same thing, same error. One that I added a week or so back where, I had the same issue. But I did something but I guess I am not sure what I did to make it work, I thought all it I did was save the file. But fails me now. Very strange.
  
  Joe
  
  

• brain1610

  Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.

  When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,

  "Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."

  Can any body help me

  Regards,

  Chetan

  
  
  

• torras

  I had a similar issue, the error I was getting:

  "Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."

  I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!

  Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.

  
  

• Gordon Kenaston

  I got it to work! Although my connection has no password and I placed 1 space in the password box and it now works.
  
  Finally!!! Thanks for giving me the motivation to try again Jag. If I can help you in any way please let me know. I am connecting to Progress 9D and OE 10 with SSIS.
  Joe
  
  

• oha_li

  um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.

  If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...

  Thanks

  Wenyang

   

  
  
  

• fhhowdy

  Problem solved

  
  

• Elder Morales

  Joe

  As for the "insufficient information to connect", make sure your DSN has all of the required parameters such as user id, password, database etc., as shown below.

  uid=ABC;Dsn=XYZ;pwd=PQR;

  Since we have many Progress databases to connect and fetch data from, we use "dynamic" scripts via Expressions to set the Source Progress DB connection and fetch data from. It seems to be working well. The one issue we still have is with connecting to Double Byte Progress Databases such as Korea, Hungary and Japan. We have this working for 4 years using SQL Server 2000 DTS packages but does not work (for some reason) in SSIS. Logged a ticket with DataDirect, Progress and QAD. Posted in many forums including here and I have not gotten any response yet. Let me know if you have a similar issue and how you went about solving it.

  Thanks

  Jagannathan Santhanam

  
  
  

• santhakumar

  I have a simular issue. I am connecting to Progress 9.1D database. I setup a data source in the solution explorer and then add it to the connection manager to eventually use it in a datareader. Afer completing, I get insufficient information to connect. Odd thing is I have 2 other connections to other Progress db's. When I set them up I had the same issue then. They work now. This problem is repeatable but the solution is not yet found. I beat my head againt the wall for hours then all the sudden it works. I thought I had it figured out that I needed to save the project prior to binding the data reader but I am now adding another connection and it is failing me. I waiting for it to heal itself again. Grrrr. Wierd thing is I can open it with Server explorer and it works there. I can see the tables, data everything. I go back to project and still get the error. So aggravating and depressing I created another connection in the Data Source view with one of the known good connections. I get the error. When I compare them the appear the same except for the name. I am beginning to think this is a bug with SSIS and VS and the uuid is not bound in the project. Some how I have accidently made this occur on my prior attempts. Does anyone have an idea Thanks. Joe
  
  

• pguerette

  Hi, I am facing problem to connect to progress db in .net,

  Would you please let me know of the connection string and other settings ,

  I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.

  but then i get error when i try set anything else.

  Thanking you.

  
  
  

• rileyjim

  DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.

  Thanks

  Wenyang

  
  
  

• Kmoskal

  were you able to slove this problem..

  I am also facing similar problems.

  
  

• gwc

  Wenyang,

  Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.

  But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:

  “Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”

  < xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />Appreciate your attencion.

  [ ]’s

  
  
• Problem: SSIS, ODBC and Progress Database