Using the trial, I was trying to connect to an external database view using a connection string like:

Data Source=999.999.999.99,10443;Initial Catalog=DBNAME;User Id=XX;Password=XXXXXXX;  

I put this in the field called External Connection (Enter the name of the connection string here)  I have also selected Table/View as data source and entered a valid View name.

This does not seem to work as I click Generate Column Names and nothing happens.  I don't see any error messages.  What am I missing?

I am having problems with the Generate Column Names as well. I have tried External Data sources, Dynamic Forms, and native DNN tables and none of them work.
Here is a bit more detail on error tracking that I am seeing in my scenario:
I am using the trial as well, like Brian is. I got it working fine on my localhost and was just about the pull the plug and buy the whole suite of DataSprings modules. It was great. Before buying I decided to try on a test portal of my website and that is where I am seeing the issue.
Brian, I am curious if you are on localhost or on a server. Also curious if you are seeing the same errors on native DNN tables or if it is just on external data sources?
In I.E. 8 I do see an error on the status bar but couldn't find any other errors listed.
In Firefox, it doesn't initially seem to give any errors, but if I look in the error console I see the following everytime I click the Generate Column Names link:

Error: [Exception... "'Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500' when calling method: [nsIDOMEventListener::handleEvent]" nsresult: "0x8057001c (NS_ERROR_XPC_JS_THREW_JS_OBJECT)" location: "" data: no]

I'm not really sure what this means, but I sure hope someone can help out. I am very eager to buy and work with this module after seeing the promise of it on my localhost.

Both my localhost and my hosted web site are using SQL Server 2005.  Express edition on localhost.

WooHoo!!!!!  I think I figured this thing out!  I think this is going to fix a problem reported with another post as well.

So here is what I did since my last post...

I deleted all instances of Dynamic Views and uninstalled.  I looked through my database and realized there were still a couple of StoreProcedures that were left over even after my uninstall was successfull.  I deleted those, SP's but I don't think you would have to.  I don't even think you would need to uninstall, but try if my instructions don't work for you.

I reinstalled Dynamic Views and this time I noticed that the same SP's were installed again.  However what was odd is that two of the SPs had my user as the owner, but most of the Dynamic View SPs had 'dbo' as the owner.  I figured this didn't look right so I did a google search on how to change dbowner of the SPs and came up with this script to correct the 2 SPs.

EXEC sp_changeobjectowner 'DataSprings_DynamicViews_AddDynamicViewColumn', 'dbo';

EXEC sp_changeobjectowner 'DataSprings_DynamicViews_DeleteDynamicViewColumn', 'dbo';

Run those two commands in your database and hopefully, this fixes your issue as well.  It worked right away in my environment after adding a clean DynView module to my page.

Good luck.

Hi, I'm having the same problem as Brian. Also using trial version.
Put this connectionstring in External connection field:

Data Source=.\SQLExpress;Initial Catalog=DBName;User ID=xxx;Password=xxx;

Nothing happens whenI click Generate Column Names.

The error message in the log:
The stored procedure 'dbo.DataSprings_RetrieveDynamicView' doesn't exist.

On the DNN Database it works just fine.

HI, can you try changing the stored procedure to just an SQL select statement and see if it will work? I don't believe Dynamic Views can support a stored procedure at the moment. -- David

Hi David, thanks for your response,

I'm not sure what you mean.

When I use the DNN db, it works ok. When I use the External Connection, the error appears in the log.

How and where do I make the changes you suggest?

Thanks for your time

Bert

 

Hi Bert,

Please run this on the database SQL server you are trying to use. The module requires (currently) that this stored procedure exist on the server.



Create Procedure dbo.[DataSprings_RetrieveDynamicView]
@PortalID integer,
@intTableorQuery integer,
@strTableOrQuery nvarchar(MAX),
@LimitResults nvarchar(4000),
@strUserFilter nvarchar(4000),
@intUserID integer,
@strDetailView nvarchar(2000)

AS

Declare @MySQL nvarchar(MAX)
Declare @SQLToExecute nvarchar(MAX)

if @intTableOrQuery = 0
BEGIN
Set @MySQL = 'Select * from ' + @strTableOrQuery
END
ELSE IF @intTableOrQuery = 1
BEGIN
exec dbo.[DataSprings_DynamicViews_GetDynamicFormsResults] @strTableOrQuery, @intUserID, @MySQL OUTPUT
--Select @MySQL
END
ELSE
BEGIN
Set @MySQL = @strTableOrQuery
END

Set @SQLToExecute = cast('Select ' as nvarchar(max)) + @LimitResults + cast(' * from
(' as nvarchar(max)) + @MySQL + cast(') AS Main ' as nvarchar(max)) + @strUserFilter + @strDetailView

--Select @SQLToExecute
exec sp_executesql @SQLToExecute

In the next release this will not be required... We will offer a 'free form' option which allows you to use your own search parameters in the query and so forth. Right now this is because the search/row count/and filter are handled dynamically in the query rather then code for performance reasons.

Sorry for the problems, let me know if this fixes you up!

-Chad

 Hi Chad,

Thanks for your reply.

The stored procedure is added to the server with an error:

The module 'DataSprings_RetrieveDynamicView' depends on the missing object 'dbo.DataSprings_DynamicViews_GetDynamicFormsResults'. The module will still be created; however, it cannot run successfully until the object exists.

On the testportal (localhost) it is not working. Still the error in the log:

The stored procedure 'dbo.DataSprings_RetrieveDynamicView' doesn't exist.

Hope this helps

 

Bert

 

 

Bert,

Thanks. Ok great… In this case it sounds like the module will work as long as you don’t utilize 1. An external database connection with 2. Dynamic Forms. Since typically Dynamic Forms wouldn’t be used on an external database connection this shouldn’t be a big issue. If it is used then you would need to install the module on that system as well.

Basically this procedure passes a parameter which either references 1. A table, 2. Dynamic Forms, 3. Custom SQL. In your case I am assuming you are using #3.

So you should be ok, does it work correctly?

-Chad

Hi Chad,

It is all working now. Great! I performed your first post on the server, not on the database that I want to use...Sorry for the misunderstanding.

Bert

I am glad to hear that you have everything working. If you ever have any questions please feel free to ask.

Thank you,

Ryan