Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Could not find stored procedure 'dbo.gs_AppSettingSelect'
Options
Previous Topic Next Topic
gaycalgary
#1 Posted : Sunday, 5 February 2012 2:01:08 PM(UTC)
Rank: Member

Joined: 5/02/2012(UTC)
Posts: 4
Hi there,

I've just set up Gallery Server Pro 2.6 for the first time. I'm using the SQL Server data provider with connectionStringName pointing to an existing SQL Server connection string in my Webconfig file. I've verified that the stored procedure (gs_AppSettingSelect) exists on the SQL Server and that the user account from this connection string has permissions to execute it.

I've created a simple page with the Gallery control on it, and it is giving me this error:
Could not find stored procedure 'dbo.gs_AppSettingSelect'

Any idea what I might be doing wrong?
Back to top
daveburke
#2 Posted : Sunday, 5 February 2012 4:02:08 PM(UTC)
daveburke

Rank: Advanced Member

Joined: 12/01/2009(UTC)
Posts: 62
Location: Vermont
This sounds silly, but is a possibility. Are we sure that the DB Connection Strings in your web.config are pointing to the correct database? Doesn't hurt to check. Hopefully its something simple like that.

Good luck,
Dave
Back to top
WWW
gaycalgary
#3 Posted : Saturday, 11 February 2012 1:44:30 PM(UTC)
Rank: Member

Joined: 5/02/2012(UTC)
Posts: 4
Wow, miraculously this just started working without me changing anything. Maybe the procedures added to my SQL server were still too "fresh" when I first tried. Damn...I feel silly now. :)
Back to top
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET