Happy New User with db location question

Hello,

After trying for over a week, and failing to set up 'Membership' at my previous svc provider, I had had enough. On Saturday, in the space of 2 hours, I had set up a new account with you folks, registered a new domain, received my acct activation email, uploaded the website shell to my FTP location, received domain activation notice, added and attached a SQL database, created and tested users roles and rules, and cracked a beer.

Thanks for making a tough job so easy.

Now, while I have been able to manage membership without a problem after using your KB10413, your Attach MDB tool, and Visual Web Dev's Web Site Admin Tool, I would very much like to 'see' what I have done or may still need to do. But I can't figure out the physical location of the db being used. (Just because I could follow directions doesn't mean I actually understood what I did!)

In addition to viewing the database, I had intended to reference it with a SQLDataAccess control when building a Members Admin page for the person ultimately responsible for maintaining the site.


Can you point me at that database?

Server: sql2k511.discountasp.net
DB Name: SQL2005_430731_geeandgeede1

Anything you can do would be much appreciated.

George M

 

Hi George,
To better answer your question may I ask...Are you new to SQL Server? New to ASP.NET?
In a very generic response I would first recommend that you browse the DB structure on your account.
Typicallythe MS SQLManager is used for that.
From your local machine you can open your remote DB and browse each table and its records, plus any SQL procedures.
Once you have browsed those tables/records you can report on them from ASP.NET with zero code.
The Video Tutorials at http://www.asp.net are very helpful for that as they give step by step lessons.
Salute,
Mark

 

Hello Mark,

Thanks for the quick reply.

Yes, I am new to SQL Server (have been using Access for the past ten years or so at home and in the office. No db experience on the web.)

And I guess the second answer is also 'Yes', since this is my first ASP.NET site. But I have read Scott Mitchell's 'Teach Yourself ASP.NET 2.0...' (Although it took me 24 days - not 'hours'), managed to complete all the exercises, and have spent many hours on the (excellent) ASP.NET site, watching the videos, reading the tutorials, and downloading the samples. While I am sure I haven't begun to tap ASP.NETs capabilities, everything I have attempted on my local machine, I have accomplished.

The problem for me is that the database being used for my Membership functions on discountASP.net is NOT the ASPNETDB.MDB created automatically when I set Membership up, but the one referenced in my first post.

So, I can open my site (local and remote) without a problem, can go to the Database Explorer in VWD2005EE, and browse the tables/show table data within ASPNETDB.MDB. And that's what I was hoping to be able to do with the SQL2005_430731_geeandgeede1 database asigned to me.

I hope that restates my request a little more clearly. While you're thinking this through, I'll find a copy of MS SQL Manager.

Many thanks for your help.

George M

 

I'm guessing by your writing style that we're close in age.
Lord willing I'll be 46 tomorrow.
Please keep in mind I'm not part of the DASP staff, just a Stay-at-home-Dad hobbyist.
I have however done a lot of contract development for large companies over the years.
That's my role here, sharing my own experience.

That being said, I'll help you with each step, my pleasure.

One thing I'd suggest now is that you browse your local ASPNET disconnected database...
And once you are able to browse your remote SQL Server account DB compare them.
You'll learn a lot from it.
I'm going to guess that one thing that may be confusing you is the structure of the ASPNET DB you used.
It isn't the same as your remote DB but they shook hands when you imported the same data.

With SQL commands you can share data both ways, tables can be created, modifiedand dropped. (destroyed)

Once you have a MS SQL Manager you can pump data to and from the remote SQL Server.
Amazon is a good source of the Developer version of stand alone MS SQL Servers.
All you need for your local work is the Developer version, which goes for $50 or less.
You can even evaluate the full versions with no limitations for 180 days.
The only drawback is running SQL Server locally does require some of your systems resources.
Salute,
Mark

 

Mark,

Pretty good guess, although you flatter me. Forty six years ago I was entering high school - a great time.

Thanks for your help. I'll check back in after I've got SQL Mgr up and running.

Happy Birthday !!

George M

 

Thanks Gents.