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 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

6 hours 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 ...

6 hours 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

20 hours 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

20 hours 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

21 hours 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?

21 hours 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 ...21 hours 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 ...19 hours 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 week 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 week ago

Kelly Ford

Kelly Fordanswered the question Ajax to a feed, get 500 error and Cannot find table 0.

There could be many reasons why you're getting that error. "Cannot find table 0" seems to indicate that the name of the table isn't being set correctly in your stored procedure. Without your stored procedure code or your feed code it's hard to speculate …

2 weeks ago

Anonymous

Anonymousasked the question: Ajax to a feed, get 500 error and Cannot find table 0.

I was following this tutorial: http://www.dnndev.com/learn/articles/detail/articleid/94/simulating-a-like-button-without-postback on how to post to a feed. I am trying to post javascript variables to a feed that is a stored procedure that should save a …

2 weeks ago