Progress provider wanted!
Hello all,
I have a problem connecting to a Progress database from my DotNetNuke portal.
This is my code:
MRPConnection = New OleDb.OleDbConnection("Provider=Progress OpenEdge 10.2B driver; Data Source=ODBC;DSN=mkg;HOST=mkgsrv;PORT=6000;DB=mkg;UID=crystal;PWD=crystal")
MRPConnection.Open()
MRPAdapter = New OleDb.OleDbDataAdapter("select * from xxx.yyy", MRPConnection)
And this is the error message:
DotNetNuke.Services.Exceptions.ModuleLoadException: An OLE DB Provider
was not specified in the ConnectionString. An example would be,
'Provider=SQLOLEDB;'. ---> System.ArgumentException: An OLE DB
Provider was not specified in the ConnectionString. An example would
be, 'Provider=SQLOLEDB;'. at System.Data.OleDb.
So, my question:
what should I enter as the data provider?
Thanks alot!
Jos
1 answer
Use ODBC to connect to OpenEdge drivers, then follow the directions on the Progress list from this site