Last post Sep 14, 2009 07:38 PM by Decoder
Sep 12, 2009 04:46 PM|Decoder|LINK
am trying to find the best way to implement the ASPNETDB.MDF DB into my online application. In my IDE this BD was put into my APP_DATA folder and all the functionality works fine from there I never needed to attach it to my Microsoft SQL server management.
How do I set this up on my godaddy shaired hosting space.
Is it possable to keep it there in my APP_DATA folder on Godaddy shaired host and just upload it to that folder or must I somehow recreate the DB using there dash board type interface and link to it with a connection string in the webconfig. If I need to
take the webconfig route how can I make sure all the functionality still works.
Also, what is the easest way to recreate this using the in the GODADDY dash board or is there a way to upload it up to GODADDY in whole and keep all the functionality?
Any help or experienced insight on this is appreciated.
Sep 12, 2009 07:43 PM|nijhawan.saurabh|LINK
The best way would be to get the sql generated for your Database and run the sql commands for the same database on GoDaddy.
Now they 'd provide you with a connectionstring that you may use to connect to your database.
Sep 12, 2009 09:51 PM|Decoder|LINK
Thanks for the input I am in the process of doing that.
One other question.
The ASPNETDB will be the second DB in my my ASP.NET site is using. Will I need an additional connection string in my webcongig file for this DB? Meaning one for my current DB and one for the new ASPNETDB DB. I was reading if is possable to but all the
tables in one DB. Does that make any sense to you?
Again your help in appreciated.
Sep 13, 2009 06:35 AM|nijhawan.saurabh|LINK
Well the wayout for this would be to register your database that holds your bussiness logic table to work with aspnet membership provider.
Hence what we do is copy the tables in the aspnetdb in your own database, and then you can use only a single database and hence a single connectionstring.
But beware, you cannot do this by just copying the aspnetdb tables to your database.
Here's the procedure on how to do this:
Run a utility names aspnet_regsql.exe , you can find it in windows directory -> .net framework -> 2.0 framework files,
Now run it can configure your database to use asp.net membership.
You got to select your database from the dropdown.
Now you would see is the aspnetdb table would have been copied to your own database.
Now you can work with this database.
If you face any problem, post back in.
Sep 13, 2009 09:57 AM|Decoder|LINK
Does the web.config connection string for ASPNETDB.MDF need a specific "NAME" and do you kbnow what neme that is. I know my current user DB does need a specific name. How would I accomblish that or is that not a problem.
Thanks in advance for all your help.
Sep 13, 2009 10:12 AM|nijhawan.saurabh|LINK
No it isn't specific, you may use what ever name you like.
Sep 14, 2009 04:00 AM|rumsfo|LINK
Absolutelly. That name will help you to undwerstand what that database is used for
Sep 14, 2009 01:22 PM|nijhawan.saurabh|LINK
You done with your problems, or anything still left?
Sep 14, 2009 07:38 PM|Decoder|LINK
Just now have a chance to get back to it. Will let you know outcome.