Leaderboard

Rank Member Pts

Welcome to DNNDev University

DNNDev University LogoJust like a university without the grades and student loan. Think of it more as a merging of the student union and open classrooms. Ask questions, get answers, learn, teach, make friends and contacts.

Find Out More

 

Here's What's Happening on Campus

Alejandro Quiroga Alsina

Alejandro Quiroga Alsinaearned the privilege Start unmoderated topics

Earned the Start unmoderated topics privilege!
jeffwest1Steve Krantzmanmarkand 96 others also earned the privilege jeffwest1and 98 others also earned the privilege

1 week ago

Alejandro Quiroga Alsina

Alejandro Quiroga Alsinacreated the topic: DNN Error - Connection To The Database Failed (while working with SSMS)

I am working on a localhost environment and going through Chapter 8 of DiscoverXModPro. The tools are VMware, Windows 10 Pro, DNN v950, SQL Express 2019, SSMS 2018 and XModPro v4.9 - All the environment is running inside a VM with Windows 10 Pro. - My …

1 week ago

Alejandro Quiroga Alsina

Alejandro Quiroga Alsinaearned the privilege Edit own questions, answers, & comments

Earned the Edit own questions, answers, & comments privilege!
Charlie IoannouBrandon HartsellMyron Weberand 120 others also earned the privilege Charlie Ioannouand 122 others also earned the privilege

3 weeks ago

Anonymous

Anonymousvoted on Control Panel Connection String for additional Local Server database

<p>The connection string in web.config is exactly the same as the default connection string for Database.mdf belonging to the standard DNN instalation, and is located right below it:
</p>
<p><add name="XModSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Articulos.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
</p>
<p>Note that the n ...

3 weeks ago

Alejandro Quiroga Alsina

Alejandro Quiroga Alsinaearned the privilege Up-vote Posts

Earned the Up-vote Posts privilege!
AnonymousCharlie IoannouSpecial Projectand 68 others also earned the privilege Anonymousand 70 others also earned the privilege

3 weeks ago

Alejandro Quiroga Alsina

Alejandro Quiroga Alsinaanswered the question Control Panel Connection String for additional Local Server database

The connection string in web.config is exactly the same as the default connection string for Database.mdf belonging to the standard DNN instalation, and is located right below it: <add name="XModSqlServer" connectionString="Data Source=.\SQLExpress …
Kelly Ford also answered the question Kelly Ford also answered the question

3 weeks ago

Alejandro Quiroga Alsina

Alejandro Quiroga Alsinaearned the privilege Create unmoderated replies

Earned the Create unmoderated replies privilege!
Loren Cronaujeffwest1Charles Carrolland 29 others also earned the privilege Loren Cronauand 31 others also earned the privilege

3 weeks ago

Alejandro Quiroga Alsina

Alejandro Quiroga Alsinacreated the topic: Best practices - Should I use DNN DB or a separate DB?

What is the best practice while building an XMP application, a more or less complex one? 1. To use DNN's database. 2. To create a separate database and refer all XMP data to it?

3 weeks ago

  • NewestOldest
  • Patrick RyanGood question, but the answer(s) are not so much based off of XMod Pro. I have done all of the above in my travels. For example, prefix my tables that are related to my application... use an entirely separate database, or use schemas to separate business logic (i.e. crm.TableName, app.TableName instead of dbo.TableName). Module developers in the marketplace for DNN will use the DNN database, because they don't have control over how the end user really utilizes the module. You should ask yoursel ...3 weeks ago
  • Alejandro Quiroga Alsina@Patrick Ryan
    Yes, your reply does answer the question, and I quote two concepts that made me decide correctly:

    1. "You should ask yourself, do you want the "data" portion of this portable? Does it need to be packed up as a database and shipped wherever? Is it linked to the site indefinitely? "
    2. " If I'm interacting with user accounts or other related data from DNN core, the ...3 weeks ago
Mark Simmons

Mark Simmonsearned the privilege Edit any question or answer or comment

Earned the Edit any question or answer or comment privilege!
AnonymousCharlie IoannouSantiago Perezand 94 others also earned the privilege Anonymousand 96 others also earned the privilege

1 month ago

Mark Simmons

Mark Simmonsasked the question: Control Panel Connection String for additional Local Server database

I have a second local SQL database (in addition to the DNN database). I am trying to connect to that database using XMod Pro > Control Panel > Manage Forms > New Form > Data Source: External SQL Server Database Table > Connection String: …

1 month ago