|
 |
aspdotnet_website_programming thread: Error Message: Could not find stored procedure 'sp_Polls_GetCurrentQuestionID'
Message #1 by "Wayne Russell" <wrussell@k...> on Mon, 4 Nov 2002 13:05:04
|
|
I have just down loaded the the website and instlled it on my local
machine.
Unfortunately when I try to run the application the following error
occurs:
Error Message: Could not find stored
procedure 'sp_Polls_GetCurrentQuestionID'
When I trace the startup default.aspx file and look at the the dDbObject
connection string it is looking for server=(local).
My local server is called "KSL100010\NETSDK (Windows NT)" is there some
where I can set the value of the application to match my server or can I
change the name of my server to local.
Message #2 by "Pampin Picasso, Juan Pablo (PAZ)" <pampinjp@i...> on Mon, 4 Nov 2002 09:51:10 -0300
|
|
Folder "/config"
Files:
Polls.Config
NewsManager.Config
MailingLists.Config
AdsManager.Config
Accounts.Config
Forums.Config
Change the parameter:
<ConnectionString>(local);database=ThePhile;uid=sa;pwd=eldago;</ConnectionSt
ring> to your connection.
-----Mensaje original-----
De: Wayne Russell [mailto:wrussell@k...]
Enviado el: Monday,November 04,2002 10:05 AM
Para: Website Programming with ASP.NET
Asunto: [aspdotnet_website_programming] Error Message: Could not find stored
procedure 'sp_Polls_GetCurrentQuestionID'
I have just down loaded the the website and instlled it on my local
machine.
Unfortunately when I try to run the application the following error
occurs:
Error Message: Could not find stored
procedure 'sp_Polls_GetCurrentQuestionID'
When I trace the startup default.aspx file and look at the the dDbObject
connection string it is looking for server=(local).
My local server is called "KSL100010\NETSDK (Windows NT)" is there some
where I can set the value of the application to match my server or can I
change the name of my server to local.
Message #3 by Wayne Russell <wrussell@k...> on Mon, 4 Nov 2002 13:23:28 -0000
|
|
Many thanks for the info it now works.
Apart going to the admin page the following Error Message: Specified cast is
not valid is displayed
Regards
Wayne
-----Original Message-----
From: Pampin Picasso, Juan Pablo (PAZ) [mailto:pampinjp@i...]
Sent: Monday, November 04, 2002 12:51 PM
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] RE: Error Message: Could not find
stored procedure 'sp_Polls_GetCurrentQuestionID'
Folder "/config"
Files:
Polls.Config
NewsManager.Config
MailingLists.Config
AdsManager.Config
Accounts.Config
Forums.Config
Change the parameter:
<ConnectionString>(local);database=ThePhile;uid=sa;pwd=eldago;</ConnectionSt
ring> to your connection.
-----Mensaje original-----
De: Wayne Russell [mailto:wrussell@k...]
Enviado el: Monday,November 04,2002 10:05 AM
Para: Website Programming with ASP.NET
Asunto: [aspdotnet_website_programming] Error Message: Could not find stored
procedure 'sp_Polls_GetCurrentQuestionID'
I have just down loaded the the website and instlled it on my local
machine.
Unfortunately when I try to run the application the following error
occurs:
Error Message: Could not find stored
procedure 'sp_Polls_GetCurrentQuestionID'
When I trace the startup default.aspx file and look at the the dDbObject
connection string it is looking for server=(local).
My local server is called "KSL100010\NETSDK (Windows NT)" is there some
where I can set the value of the application to match my server or can I
change the name of my server to local.
Message #4 by Wayne Russell <wrussell@k...> on Mon, 4 Nov 2002 13:47:08 -0000
|
|
To summarise these are the errors I need to resolve on my application:
1) The error occurred in:
http://localhost/thePhile/Modules/Users/Admin/Default.aspx
Error Message: Specified cast is not valid.
2) The error occurred in: http://localhost/ThePhile/DVD/default.aspx
Error Message: Exception of type System.Web.HttpException was thrown.
3) The error occurred in: http://localhost/ThePhile/Books/default.aspx
Error Message: Exception of type System.Web.HttpException was thrown.
Regards
Wayne
-----Original Message-----
From: Wayne Russell [mailto:wrussell@k...]
Sent: Monday, November 04, 2002 1:23 PM
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] RE: Error Message: Could not find
stored procedure 'sp_Polls_GetCurrentQuestionID'
Many thanks for the info it now works.
Apart going to the admin page the following Error Message: Specified cast is
not valid is displayed
Regards
Wayne
-----Original Message-----
From: Pampin Picasso, Juan Pablo (PAZ) [mailto:pampinjp@i...]
Sent: Monday, November 04, 2002 12:51 PM
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] RE: Error Message: Could not find
stored procedure 'sp_Polls_GetCurrentQuestionID'
Folder "/config"
Files:
Polls.Config
NewsManager.Config
MailingLists.Config
AdsManager.Config
Accounts.Config
Forums.Config
Change the parameter:
<ConnectionString>(local);database=ThePhile;uid=sa;pwd=eldago;</ConnectionSt
ring> to your connection.
-----Mensaje original-----
De: Wayne Russell [mailto:wrussell@k...]
Enviado el: Monday,November 04,2002 10:05 AM
Para: Website Programming with ASP.NET
Asunto: [aspdotnet_website_programming] Error Message: Could not find stored
procedure 'sp_Polls_GetCurrentQuestionID'
I have just down loaded the the website and instlled it on my local
machine.
Unfortunately when I try to run the application the following error
occurs:
Error Message: Could not find stored
procedure 'sp_Polls_GetCurrentQuestionID'
When I trace the startup default.aspx file and look at the the dDbObject
connection string it is looking for server=(local).
My local server is called "KSL100010\NETSDK (Windows NT)" is there some
where I can set the value of the application to match my server or can I
change the name of my server to local.
Message #5 by David Barnes <DavidB@w...> on Mon, 4 Nov 2002 13:54:57 -0000
|
|
Hi Wayne
This is a bug in the code (even Kevin and Marco aren't perfect... ;) ) ....
IIRC, you need to check that the Principle has been set to an instance of
Kevin's new sub class before attempting the cast. If the user has not logged
in, the Principle is still a plain old GenericPrinciple and the cast fails.
I'm sure I fixed this once... but must have forgotten to upload the change.
:( I'll have another look. For now, if you log in as administrator before
clicking the Admin link then it should work.
Cheers
David Barnes
Editor, Wrox Press
> -----Original Message-----
> From: Wayne Russell [mailto:wrussell@k...]
> Sent: Monday, November 04, 2002 1:23 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message: Could not
> find stored procedure 'sp_Polls_GetCurrentQuestionID'
>
>
> Many thanks for the info it now works.
>
> Apart going to the admin page the following Error Message:
> Specified cast is
> not valid is displayed
>
> Regards
>
> Wayne
>
>
> -----Original Message-----
> From: Pampin Picasso, Juan Pablo (PAZ)
> [mailto:pampinjp@i...]
> Sent: Monday, November 04, 2002 12:51 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message:
> Could not find
> stored procedure 'sp_Polls_GetCurrentQuestionID'
>
> Folder "/config"
>
> Files:
> Polls.Config
> NewsManager.Config
> MailingLists.Config
> AdsManager.Config
> Accounts.Config
> Forums.Config
>
> Change the parameter:
> <ConnectionString>(local);database=ThePhile;uid=sa;pwd=eldago;
> </ConnectionSt
> ring> to your connection.
>
>
>
> -----Mensaje original-----
> De: Wayne Russell [mailto:wrussell@k...]
> Enviado el: Monday,November 04,2002 10:05 AM
> Para: Website Programming with ASP.NET
> Asunto: [aspdotnet_website_programming] Error Message: Could
> not find stored
> procedure 'sp_Polls_GetCurrentQuestionID'
>
> I have just down loaded the the website and instlled it on my local
> machine.
>
> Unfortunately when I try to run the application the following error
> occurs:
>
> Error Message: Could not find stored
> procedure 'sp_Polls_GetCurrentQuestionID'
>
> When I trace the startup default.aspx file and look at the
> the dDbObject
> connection string it is looking for server=(local).
>
> My local server is called "KSL100010\NETSDK (Windows NT)" is
> there some
> where I can set the value of the application to match my
> server or can I
> change the name of my server to local.
>
>
>
Message #6 by David Barnes <DavidB@w...> on Mon, 4 Nov 2002 14:12:15 -0000
|
|
Hi Wayne
I've just sent an email about the first issue.... should come through soon.
The second two are just due to the fact that these are dummy links to
demonstrate the navigation control -- the pages themselves don't exist.
I will try to incorporate fixes to both issues in the code download some
time in the next few days.
Incidentally, these sorts of problems should really go to support@w...
The focus of this list is on extending / developing the framework shown in
the book -- not getting up and running.
Many thanks
David
Editor, Wrox Press
> -----Original Message-----
> From: Wayne Russell [mailto:wrussell@k...]
> Sent: Monday, November 04, 2002 1:47 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message: Could not
> find stored procedure 'sp_Polls_GetCurrentQuestionID'
>
>
> To summarise these are the errors I need to resolve on my application:
>
> 1) The error occurred in:
> http://localhost/thePhile/Modules/Users/Admin/Default.aspx
> Error Message: Specified cast is not valid.
> 2) The error occurred in: http://localhost/ThePhile/DVD/default.aspx
> Error Message: Exception of type System.Web.HttpException was thrown.
> 3) The error occurred in: http://localhost/ThePhile/Books/default.aspx
> Error Message: Exception of type System.Web.HttpException was thrown.
>
> Regards
>
> Wayne
>
>
>
>
> -----Original Message-----
> From: Wayne Russell [mailto:wrussell@k...]
> Sent: Monday, November 04, 2002 1:23 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message:
> Could not find
> stored procedure 'sp_Polls_GetCurrentQuestionID'
>
> Many thanks for the info it now works.
>
> Apart going to the admin page the following Error Message:
> Specified cast is
> not valid is displayed
>
> Regards
>
> Wayne
>
>
> -----Original Message-----
> From: Pampin Picasso, Juan Pablo (PAZ)
> [mailto:pampinjp@i...]
> Sent: Monday, November 04, 2002 12:51 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message:
> Could not find
> stored procedure 'sp_Polls_GetCurrentQuestionID'
>
> Folder "/config"
>
> Files:
> Polls.Config
> NewsManager.Config
> MailingLists.Config
> AdsManager.Config
> Accounts.Config
> Forums.Config
>
> Change the parameter:
> <ConnectionString>(local);database=ThePhile;uid=sa;pwd=eldago;
> </ConnectionSt
> ring> to your connection.
>
>
>
> -----Mensaje original-----
> De: Wayne Russell [mailto:wrussell@k...]
> Enviado el: Monday,November 04,2002 10:05 AM
> Para: Website Programming with ASP.NET
> Asunto: [aspdotnet_website_programming] Error Message: Could
> not find stored
> procedure 'sp_Polls_GetCurrentQuestionID'
>
> I have just down loaded the the website and instlled it on my local
> machine.
>
> Unfortunately when I try to run the application the following error
> occurs:
>
> Error Message: Could not find stored
> procedure 'sp_Polls_GetCurrentQuestionID'
>
> When I trace the startup default.aspx file and look at the
> the dDbObject
> connection string it is looking for server=(local).
>
> My local server is called "KSL100010\NETSDK (Windows NT)" is
> there some
> where I can set the value of the application to match my
> server or can I
> change the name of my server to local.
>
>
>
>
Message #7 by Wayne Russell <wrussell@k...> on Mon, 4 Nov 2002 15:53:58 -0000
|
|
David,
Thanks for the information. Please let me know when you have uploaded the
changes to the source code.
It was not clear that I should have directed these points to
support@w... I looked at some of the other postings before sending my
own. There did seem to be a number relating to getting the site up and
running.
My aim with this book is to extend the functionality of my company web site
and to migrate to ASP.NET and c# but I think this going to take some time,
due to fact that the ThePhile website does encompass a lot concepts and
ideas. I think that I might only need to use parts of the concepts and ideas
that you have discussed.
Regards
Wayne
-----Original Message-----
From: David Barnes [mailto:DavidB@w...]
Sent: Monday, November 04, 2002 2:12 PM
To: Website Programming with ASP.NET
Subject: [aspdotnet_website_programming] RE: Error Message: Could not find
stored procedure 'sp_Polls_GetCurrentQuestionID'
Hi Wayne
I've just sent an email about the first issue.... should come through soon.
The second two are just due to the fact that these are dummy links to
demonstrate the navigation control -- the pages themselves don't exist.
I will try to incorporate fixes to both issues in the code download some
time in the next few days.
Incidentally, these sorts of problems should really go to support@w...
The focus of this list is on extending / developing the framework shown in
the book -- not getting up and running.
Many thanks
David
Editor, Wrox Press
> -----Original Message-----
> From: Wayne Russell [mailto:wrussell@k...]
> Sent: Monday, November 04, 2002 1:47 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message: Could not
> find stored procedure 'sp_Polls_GetCurrentQuestionID'
>
>
> To summarise these are the errors I need to resolve on my application:
>
> 1) The error occurred in:
> http://localhost/thePhile/Modules/Users/Admin/Default.aspx
> Error Message: Specified cast is not valid.
> 2) The error occurred in: http://localhost/ThePhile/DVD/default.aspx
> Error Message: Exception of type System.Web.HttpException was thrown.
> 3) The error occurred in: http://localhost/ThePhile/Books/default.aspx
> Error Message: Exception of type System.Web.HttpException was thrown.
>
> Regards
>
> Wayne
>
>
>
>
> -----Original Message-----
> From: Wayne Russell [mailto:wrussell@k...]
> Sent: Monday, November 04, 2002 1:23 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message:
> Could not find
> stored procedure 'sp_Polls_GetCurrentQuestionID'
>
> Many thanks for the info it now works.
>
> Apart going to the admin page the following Error Message:
> Specified cast is
> not valid is displayed
>
> Regards
>
> Wayne
>
>
> -----Original Message-----
> From: Pampin Picasso, Juan Pablo (PAZ)
> [mailto:pampinjp@i...]
> Sent: Monday, November 04, 2002 12:51 PM
> To: Website Programming with ASP.NET
> Subject: [aspdotnet_website_programming] RE: Error Message:
> Could not find
> stored procedure 'sp_Polls_GetCurrentQuestionID'
>
> Folder "/config"
>
> Files:
> Polls.Config
> NewsManager.Config
> MailingLists.Config
> AdsManager.Config
> Accounts.Config
> Forums.Config
>
> Change the parameter:
> <ConnectionString>(local);database=ThePhile;uid=sa;pwd=eldago;
> </ConnectionSt
> ring> to your connection.
>
>
>
> -----Mensaje original-----
> De: Wayne Russell [mailto:wrussell@k...]
> Enviado el: Monday,November 04,2002 10:05 AM
> Para: Website Programming with ASP.NET
> Asunto: [aspdotnet_website_programming] Error Message: Could
> not find stored
> procedure 'sp_Polls_GetCurrentQuestionID'
>
> I have just down loaded the the website and instlled it on my local
> machine.
>
> Unfortunately when I try to run the application the following error
> occurs:
>
> Error Message: Could not find stored
> procedure 'sp_Polls_GetCurrentQuestionID'
>
> When I trace the startup default.aspx file and look at the
> the dDbObject
> connection string it is looking for server=(local).
>
> My local server is called "KSL100010\NETSDK (Windows NT)" is
> there some
> where I can set the value of the application to match my
> server or can I
> change the name of my server to local.
>
>
>
>
|
|
|
View Cart
