Recently Viewed...
DNN Modules
SnowCovered Top Sellers

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Edit documents directly on your server. The premier document management solution for DotNetNuke (DNN). Index contents of documents. Share documents across your portal and avoid duplicates. Revised and flexible UI. Extensible architecture.

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

    |   Register   |   Thursday, November 20, 2008   
Data Springs Product Forums...
Subject: Question with SQL source external database
Prev Next
You are not authorized to post a reply.

Author Messages
Arjan
Posts:3


09/04/2008 4:12 AM  

Hello,

 

I'm evaluating the module Dynamic Registration and it looks exactly what we need! We are considering to purchase this module.

I have however some questions which look obvious but so far I havo not seen an answer in this forum or in the manual.

I'm trying to create a question using the SQL Drive options. If I enter the SQL statement and run Test SQL I receive an error 'Error in SQL!'

  1. Where can I see the error in detail?
  2. I'm trying to use another SQL database as source, like select Klant_Naam as QuestionOption, Klant_ID as QuestionOptionValue from MDB_DEMO.dbo.GWE_Klanten where MDB_DEMO is not my DNN database.
    - It works when I execute this in the SQL server environment
    - It works when I transfer the table into the DNN database

I'm thinking of authorization issues so I added the DNN account to my external database as dbo.

What am I doing wrong!

Greetings,

Arjan

Chad
Posts:2207
river guide
river guide

09/08/2008 11:50 AM  
Hi. What happens if you take this same query and go to Host, SQL. Does it work then?

-Chad
Arjan
Posts:3


10/12/2008 1:13 PM  

Hello Chad,

 

Fixed it! Thought I added the right user rights in the database but i didn't. After addid this, it worked fine!

Thanks,

Arjan

You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration > Question with SQL source external database



ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement