Gridview

nkvd3941 · January 24th, 2010, 04:35 PM

Sorry - a bit confused here

I have attached the ASPNETDB to my sql2005, and created a connection string for the db, by creating a gridview of one of the tables in a dummy webpage.

Where do i use the new connectionstring, ie how do i point to the login.mdf from my application?

Bearing in mind, the existing connectionstring is
Data Source=.\SQLEXPRESS;AttachDbFilename=D:\E_Folders\ OddsAndSods\csharp.web\Recipes\App_Data\ASPNETDB.M DF;Integrated Security=True;User Instance=True, i.e. a sql2005 connection.

Imar · January 24th, 2010, 04:40 PM

Did you read the article I linked to in the article I linked to? ;-)

In case you haven't: http://weblogs.asp.net/scottgu/archi...25/423703.aspx

Also, check out Chapter 18 and Appendix B. The scenario you're describing is fuilly documented there...

Cheers,

Imar

nkvd3941 · January 31st, 2010, 05:25 AM

WOHOO!

Got it all to work. The key was the permissions in your article and creating my own securitydb using the scott guthrie article that you pointed me too.
Took me a while to get there but i now know a lot more about sql security than i did about 3 weeks ago.

Many thanks for all your help Imar.

Imar · January 31st, 2010, 05:33 AM

Excellent. Glad it's all working now....

Imar

nkvd3941 · March 13th, 2010, 10:17 AM

Hi - me again

Paid for some hosted webspace, got my 2 databases uploaded, put my Published webdie in the wappropriate place, type in the appropriate domain address (dctsystems.org), and keep getting teh following message:

"Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS."

Can anybody help?

Imar · March 13th, 2010, 10:26 AM

Hi there,

Take a look at the actual address and the error message:

http://dctsystems.org/ReleaseHosted/RecipesMain.aspx

Basically, your application runs in the folder ReleaseHosted; not in the root of the server. Therefore, the config file at /ReleaseHosted/web.config tries to override settings defined for the root (/) which is not allowed. Two options to fix it:

1. Move your files to the root so you can access them like this:
http://dctsystems.org/RecipesMain.aspx

2. Make ReleaseHosted a virtual directory. Your host knows how to do this, and they should do it for you.

Cheers,

Imar

nkvd3941 · March 14th, 2010, 04:16 AM

Once again Imar, thanks for your help. I went for the first option.

The web-site now works on a hosted site, so from knowing absolutely nothing about web-programming, thanks to your book and help i have written a small hosted site using databases / security / css etc.
I feel i can now go from here and offer real business aplplications.

I cant thank you enough.

Imar · March 14th, 2010, 05:17 AM

You're welcome. Glad it's all working now, and good to hear the book has been so useful to you.

Good luck with your future projects.

Imar

nkvd3941 · March 28th, 2010, 12:34 PM

Still getting nowhere with the Virtual directory.

I asked support to create one, but that didnt seem to work.

So i created my own off the Plesk website they give users to manage their websites.

I created a virtual / physical folder called RecipesHostedI, put all my stuff in their (thats already on the root), so the entire path is:

http://dctsystems.org/RecipesHostedI/

The link on the first page takes me to my RecipesMain.aspx, but thats when i just get a server error.

Am i missing the point here?

Imar · March 28th, 2010, 01:46 PM

Hi there,

That's impossible to say without seeing the real error. Internal Server Error could be anything.... ;-(

Imar