NET data provider which supposedly provides ODBC connectivity to the. The problem comes when trying to access this ODBC DSN from an ASP.NET-based application called Dbnetgrid. The ODBC administrator describes this ODBC driver as: "DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E". We can also connect to the Progress DB via ODBC and read data from within Crystal Reports as well as from within MS Access. On our client's server, the DSN has been successfully setup (previously, by our client) and the connection tests successfully from within the ODBC administrator. We are attempting to access a Progress DB via ODBC. Some how I have accidently made this occur on my prior attempts. I am beginning to think this is a bug with SSIS and VS and the uuid is not bound in the project. When I compare them the appear the same except for the name. So aggravating and depressing I created another connection in the Data Source view with one of the known good connections. I go back to project and still get the error. Wierd thing is I can open it with Server explorer and it works there. 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 beat my head againt the wall for hours then all the sudden it works. This problem is repeatable but the solution is not yet found. When I set them up I had the same issue then. Odd thing is I have 2 other connections to other Progress db's. Afer completing, I get insufficient information to connect. I setup a data source in the solution explorer and then add it to the connection manager to eventually use it in a datareader. I am connecting to Progress 9.1D database.
0 kommentar(er)
