I'm trying to connect to a Progress database via the ADO.NET OleDB driver. The connection string I'm using is
"Provider=SQLOLEDB;Connect Timeout=3000;DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL v10.0B;HOST=192.168.55.99;PORT=7150;DB=nxt;UID=XXX;PWD=XXX"
But when I attempt to read from the database, I receive the error message "DBNETLIB ....... Invalid Connection String Attribute".
What is a valid ADO.Net Connection string?
Thanks for all replies!
You will need to use an ODBC connection (System.Data.ODBC* class). The progress drivers are not ported to ADO.Net, nor will the OleDB ODBC type bridge work as the level of support is not there.
Ironic that DataDirect (a 'Progress Company') supports other vendors but not its Parent DB (http://www.datadirect.com/products/net/index.ssp). This has been 'under review' for a long time now
A word of advice - within .Net use the generic interfaces so that your app can support both OleDB, ODBC and Sql access formats. Although you will have to build the support for differences - for example named v's indexed parameters (Sql has "@CustNum" v's ODBC '@1' - a pain if CustNum is used more than once in any query/update). You may also come unstuck down the path with tuning queries, for example PSC 'NO-REORDER' override on the query engine.
Is there a connection string that works with DAO? Like the one you printed for ADO...(Provider=SQLOLEDB;Connect Timeout=3000;DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL v10.0B;HOST=192.168.55.99;PORT=7150;DB=nxt;UID=XXX;PWD=XXX)
What is the answer from PSC regarding this lack of features ?
According to this link, DataDirect Sequilink USE TO support progress
Now it says to use DataConnect 4.2 or later.
Has anybody been able to connect to progress from .Net Via DataConnect?
What's the deal here? How can you be a modern database and not have any native .Net support? (and NO, the proxy gen doesn't count)
Message was edited by: