Product Support Forums

Unanswered Active Topics Forums Search Members
Forums > IowaComputerGurus Inc. Software > External Database Provider
Error in scripts!
Last Post 18 Dec 2009 06:51 PM by Mitchel Sellers. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
Dennis
New Member
New Member
Posts:1


--
09 Dec 2009 02:44 AM  
I am running DNN version 05.01.04 (3) and just installed the External Database Provider. After getting several errors, i found an error in the dbo_ICG_Auth_IsHostOrAdmin procedure. It is referencing the [Users] table instead of the [dbo_Users] table. I am assuming that the table names have recently been changed?

In any case, if you are upgrading to the latest version and encounter critical errors review the table names in the IsHostOrAdmin stored procedure. There are 3 tables names that need to be changed.

I hope this helps someone else going thru the same problems!



Mitchel Sellers
Site Moderator
Basic Member
Basic Member
Posts:245


--
18 Dec 2009 06:51 PM  
Dennis,

It appears that SnowCovered is deploying an older version of our installation package where the script did not have the {objectQualifier} token prefixed to the table.

The next release of the provider will include this fix by default, I apologize for the trouble.
-Mitchel Sellers, Microsoft C# MVP, MCITP
CEO
IowaComputerGurus Inc!

Visit my blog for helpful technical articles

For recommended products and services view the links to the right.
You are not authorized to post a reply.
Forums > IowaComputerGurus Inc. Software > External Database Provider
Active Forums 4.0

Recommended Products

Our Other Sites