Hi all,

I'm currently trying to figure out how I access an external database (on a different server) from a module so that it can display products in a list.

Not really sure where to start on this, I tried googling my way to some sort of guide but everything says to edit web.config and add connection strings. thing is every time i do that i get an error: Parser Error Message: Unrecognized attribute 'type'. Note that attribute names are case-sensitive. Basically it comes up with this error in every guide and tutorial I've followed.

Do i need to create a custom data provider?  Ideally i'd like to know the best/easiest/secure way to solve this. Thanks

Si

Can you provide some more information (example) of where and what you're trying to put in your web.cofig? You can of course cross out/change the username/password...
Sanjay

Si - well for starters you have to make sure you have the oracle client installed on the web server. Yes, oracle uses the native system.data classes that come with .NET, but they still require the neccesary Oracle client installed.
With regards to accidentally dropping tables, etc, I'd not be that worried. If your DBA has given you a user id/password to the system, it probably is read only in any case so that things like this wouldn't happen :)...
Once you have oracle client installed, setup the entry to point to your remote oracle server (TNS NAMES) and then use this as your value in the connection string. You can place your connection string in web.config and then use your modules to connect to Oracle. DNN already exposes ways of getting a section of web.config so you shouldn't have to do anything out of the box in order to pull your new connection string.

Sanjay