error hy000 datadirect odbc sybase wire protocol driver timeout exceeded

And it turned out that because I was using the administator account to connect (which has a blank password) all I needed to do was add pwd= to the connection string - see example below. I had the Error Insufficient information to connect to the data source. Hopefully Twitter and Stackoverflow will come through with a solution on this! Like I said.very Ugly but will at least let you build your project and not hold up development until a solution is found. Use the Access database as a data source and data source view using the Microsoft Jet 4.0 OLE DB Provider. Link the Progress tables that you are going to need in the Access database. Here is a quick but UGLY workaround that works for the moment until a better solution is found.Ĭreate an Access database using the Progress OpenEdge 10.2A Driver. I then attempt to create a Data Source View. The Connection method is ODBC, using 'Progress Openedge 10.2A Driver'. Firstly, I create a new data source, and test the connection, and it works fine. However, when I try to create a report model project, I get errors. I can successfully connect to the progress database, and pull some data from SQL Reporting Services. Ok, big question this one: I want to create a report model project in MS Visual Studio 2005, connecting to a Progress Openedge Database. On the SQLSetStmtAttr() function when query whose execution exceeds an. Once ODBC driver establishes connection to database SQL query does not. Failure' error when 'Auto-generated SQL' is used in ODBC Connector and ODBC.

DataStage job fails with '[ODBC SQL Server.

Error hy000 datadirect odbc sybase wire protocol driver timeout exceeded