Developer forum

Forum » Development » External access to database

External access to database


Reply
Hi!

If your developing a custom module and want to host this on the hostnordic server toghether with the dw installation, can you create your own tables in the ecom database and in that case how do you do that?

In the developer module you can let the module generate data access code, but what if you want to create a data connection with your own tables, how do you insert these?

Best regards,
Per

Replies

 
Jeppe Eriksson Agger Dynamicweb Employee
Jeppe Eriksson Agger
 
Reply
Hi!

But what If you're not hosting the DW installation yourself? Do you need to write code blocks, eg. "CREATE TABLE customTable" using C# code to create a table?

What's the difference regarding custom modules when you're hosting the solution and database yourself compared to hosting it on the Dynamicweb / hostnoridic server?

Best regards,
Per
 
Jeppe Eriksson Agger Dynamicweb Employee
Jeppe Eriksson Agger
Reply
Hi Per

When creating a table for a custom module, you can do a couple of things.
If you have access to the Administrator user (not the Admin) then you can use the SQL Firehose. This would require you to run the CREATE TABLE SQL on each and every solution you wish to use the module on.
Another way is to use Data List module to create the tables.
Last but not least is the solution you propose yourself. Create the SQL in you module c# code. This enables you to let the module handle table creation without you having to do it for all relevant solutions.

The main difference between a HostNordic-hosted solution and a locally-hosted solution is that the servers you use for hosting the solution yourself, you have complete access to. Either physical or through Remote Desktop. This is not available with a HostNordic-hosted solution.

- Jeppe
 
Reply

PS: If you have a dedicated partner server, you actually have RDC access to the server, giving full access to the server.

But with a shared server you don't have this opportunity.

Regards /Snedker

 

You must be logged in to post in the forum