Questions

Questions Filter:
All Unanswered Answered My Questions My Answers
Tag Filter:

External Database Connection String

Hello I am trying to use an external SQL Server Database Table to create a Form and a Template using said external DB table. I have tried several different connection string combos without any luck. I have also tried to find how to do this within the dnndev.com site and through google without any luck finding an answer. Can you all help with this issue.
connectionstringSQL
0 votes
2 responses
2228 views
asked Aug 14, 2018 active Aug 14, 2018

Connection string issues

"Data Source=(local);Initial Catalog=[HRS-TYM];User ID=HRNNS;Password=xxxxxxxxx" providerName="System.Data.SqlClient" does not work in template? is this wrong? How do I add in the webconfig and use instead? I tried using addname "HRT" then the string in the connection string as per dnn string but again does not work
connectionstring
0 votes
1 responses
1699 views
Paul Buckley asked Mar 31, 2017 active Mar 31, 2017

2 SQL Servers connection string

Hi, I had the situation where I had to access 2 separate SQL data sources at once: one of the local DNN and another one form a remote location. How I would connect in that situation? This does not work <SelectCommand ConnectionString="Data Source=externalIP;Initial Catalog=splendid;Persist Security Info=True;User ID=is;Password=pass" "Data Source=.\SQLExpress;Initial Catalog=mindmaster;User ID=is2
connectionstringSQL
0 votes
1 responses
2694 views
Cata asked Feb 6, 2017 active Feb 6, 2017

PostgreSQL

I have a page on my project that will show data from a remote PostgreSQL database. I added a connection string like this: add name="MyODBC" connectionString="Driver={PostgreSQL UNICODE}; Server=IPADDr;Port=5432; Database=productionDB; Uid=UUU; Pwd=PPP;" But when I try to use it on XMOD Template setting connectionstring='[[ConnectionString:MyODBC]]' I get the error message: Object reference not set
connectionstringpostgresql
0 votes
1 responses
1770 views
Rosil Belli asked Apr 17, 2015 active Apr 17, 2015

Getting Good Answers

How do you get good answers to your questions?   Ask good questions. That means:

  1. Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
  2. Do Your Research: Check out the XMod Pro help file, the XMod Pro Guide on this site, do a search in this Answers forum. Members are friendly and more than happy to help, but it's good etiquette to show you've done your homework.
  3. Is It Answerable? Your question should be practical and answerable. Provide clear and accurate details about your specific problem. Be sure to include all the pertinent information or links to images and examples. 
  4. Show Your Appreciation: If someone correctly answers your question, come back and ACCEPT the answer. That gives them points and helps others know it was a correct answer. If members know you'll accept an answer, they'll be more likely to spend time on your next question(s).