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
Developer forum
E-mail notifications
External access to database
Posted on 08/04/2011 11:23:42
Replies
Jeppe Eriksson Agger
Posted on 08/04/2011 11:46:38
Hi Per
Have a look at this document, especially section 5.1.
http://engage.dynamicweb-cms.com/Admin/Public/DWSDownload.aspx?File=%2fFiles%2fFiler%2fDeveloper%2fDownloadfiles%2fSoftware%2fDynamicweb+Developer.pdf
- Jeppe
Have a look at this document, especially section 5.1.
http://engage.dynamicweb-cms.com/Admin/Public/DWSDownload.aspx?File=%2fFiles%2fFiler%2fDeveloper%2fDownloadfiles%2fSoftware%2fDynamicweb+Developer.pdf
- Jeppe
Posted on 08/04/2011 14:55:03
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
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
Posted on 12/04/2011 10:48:38
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
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
Posted on 12/04/2011 16:21:36
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