Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Help needed!...... How to connect a Progress database??Help needed!...... How to connect a Progress database??
Previous
 
Next
New Post
4/1/2014 6:01 AM
 

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

 
New Post
4/1/2014 7:19 PM
 

the problem with your connection is that you're specifying an oledb connection object but passing it an odbc style connection - you either need to pass it an oledb connection string, or change the connection object to odbc (not an ideal setup). This somewhat depends on what drivers you have available as windows doesn't ship with progress drivers (I suspect you can use the OLEDB provider for ODBC drivers but don't have a progress install to verify).

It's possible you already have drivers installed from a progress installation (or purchased via a 3rd party such as http://www.datadirect.com/  ), but I find the easiest way to test/generate connection strings is to create a UDL file (http://msdn.microsoft.com/en-us/libra... ). Double clicking the udl file allows you to use a friendly interface to connect to and test your connection - once you have a working connection save it and then right click the udl file and open it in notepad - this will then show you the connection you can use.


Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Using Modules a...Using Modules a...Help needed!...... How to connect a Progress database??Help needed!...... How to connect a Progress database??


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out