Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3
This is the forum to discuss the Wrox book Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars; ISBN: 9780470187593
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #11 (permalink)  
Old April 12th, 2010, 02:45 PM
Friend of Wrox
Points: 752, Level: 10
Points: 752, Level: 10 Points: 752, Level: 10 Points: 752, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
Default

Greetings!!
Sir after some searches I found the stored procedures.
But still I wanna know that will it be possible to regenerate the database with different script entirely if yes then how it can be? Well for changing only the particular column or row I know how to do that but for changing the complete schema for existing database what could be done.

Thank you.
  #12 (permalink)  
Old April 12th, 2010, 02:55 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

You can use SQL Server Management Studio to script your database to SQL Server 2000 format.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #13 (permalink)  
Old April 13th, 2010, 08:20 AM
Friend of Wrox
Points: 752, Level: 10
Points: 752, Level: 10 Points: 752, Level: 10 Points: 752, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
Default

Hello Sir,
Thank you for reply.
Sir as I told in my previous posts that I have now the database of 2005 type on web host's environment and I have successfully executed the schema and I can see all the objects that I had at my local development database.

But now I am stuck in other problem when I am trying to connect to the database for membership purpose (viz. counting no. of online users) then I have the following error.
Code:
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database <database name>, schema 'dbo'.
Sir is this any security problem or anything else. Sir please guide me in resolving this.
Thank you.
  #14 (permalink)  
Old April 13th, 2010, 08:25 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
is this any security problem or anything else
Yes, it is. The account used by the web site (either a SQL account defined in the connection string) or the web server account (for example Network Service) needs execute permissions.

You need to talk to your host, or look in their documents to see how to resolve this. Appendix B of my book shows how this works when you have full access to SQL Server but I don't know how your host's control panel works.

Cheers,

Imar

BTW: No need to keep calling me Sir..... ;-)
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #15 (permalink)  
Old April 13th, 2010, 08:33 AM
Friend of Wrox
Points: 752, Level: 10
Points: 752, Level: 10 Points: 752, Level: 10 Points: 752, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
Default

OK , I am trying it myself at first and will try to make it working. If I fail only then I will say you to kindly take look on the problem.
So for the time being I am giving a try(as I remember the security in Appendix B, thanks for that valuable Appendix)
Thank you.

Last edited by jack_hilary; April 13th, 2010 at 08:36 AM..
  #16 (permalink)  
Old April 13th, 2010, 08:37 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Quote:
If I fail only then I will say you to kindly take look on the problem.
You're better off asking your host in that case. They should know how their system works...

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #17 (permalink)  
Old April 13th, 2010, 09:00 AM
Friend of Wrox
Points: 752, Level: 10
Points: 752, Level: 10 Points: 752, Level: 10 Points: 752, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
Default

Hello,
First of all I am walking through the Appendix.
But there on page no. 695 (steps 4 & 5) you suggest to create a new login. But as I am provided information such as server name, database name along with user name and password. Then is it necessary to create the new login in that case (when we are provided user name & password). Can't we set up the security for the given account?
Thank you.
  #18 (permalink)  
Old April 13th, 2010, 09:36 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Sure. Once you have an account, you have an account. It doesn't matter if you just created it, or if it was already there.

Just to make sure: you probably can't script the security account when you rescript your database. In other words: you can't create the account locally, script it and then make it work at your host. You probably (but again, I don't know your host well enough) need to use an account supplied by your host, or one created in their control panel.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
  #19 (permalink)  
Old April 13th, 2010, 09:40 AM
Friend of Wrox
Points: 752, Level: 10
Points: 752, Level: 10 Points: 752, Level: 10 Points: 752, Level: 10
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2009
Posts: 165
Thanks: 5
Thanked 6 Times in 6 Posts
Default

Hi,
While walking through the Appendix I encountered the problem. I tried to create new User Account as mentioned on page no. 695 (Steps 4 & 5) but it reports the error as
Code:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for Login <login name>  (Microsoft.SqlServer.Express.Smo)

ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
User does not have permission to perform this action. (Microsoft SQL Server, Error: 15247)
On the other hand when I tried to give permissions as mentioned on page no. 696 (step 1 to 3) under provided user name by host provider then it reports error as
Code:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for User <user name>.
(Microsoft.SqlServer.Express.Smo)
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

User, group, or role <user name> already exists in the current database. (Microsoft SQL Server, Error: 15023)
why I am getting this error, and how it can be resolved?
  #20 (permalink)  
Old April 13th, 2010, 09:46 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Looks like the account you're using doesn't have the permissions to create other accounts. You need permissions to create accounts, or else someone could just create an account and grant permissions to their own account ;-)

How are you logged in? Where are you executing these actions?

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!




Similar Threads
Thread Thread Starter Forum Replies Last Post
Executing files with parameters online Lioness ASP.NET 1.0 and 1.1 Professional 0 March 8th, 2006 05:29 AM
SP - executing error filipczako SQL Language 3 December 12th, 2005 10:50 AM
Executing script automatically every half an hour saads90 Pro JSP 0 November 9th, 2005 10:20 AM
Client Side script for executing an aspx page Sujith Manuel VBScript 1 November 9th, 2004 06:48 AM
calling and executing files lucid Oracle 2 April 5th, 2004 02:09 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.