ASPNETDB Creation in

When using Visual Studio 2008  to create a  ASP Web  Site, can the ASPNETDB be created automatically in your App_Data folder?
Lawrence AverySystem DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick BogersDatacenter platform engineer LindowsCommented:
Hi,

It seems to me if you have configured MySql to have its databases store in your app_data folder that any newer made DB's also live there.
Or am i not completely understanding your question?
0
Lawrence AverySystem DeveloperAuthor Commented:
I am reading on the internet there is a way to automatically create the ASPNETDB.mdf database file under the App_Data folder in a ASP WEB SITE. I am using Visual Studio 2008 and I want the aspnetdb.mdf created to be connected to a Sql Server instance. I am not using SQLExpress but SQL Server 2008 R2 Developer in this case.
0
Patrick BogersDatacenter platform engineer LindowsCommented:
You mean with "user instance" ?? This way your app will only work on webservers where mySql is running, do you understand the risks?.
0
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

Lawrence AverySystem DeveloperAuthor Commented:
what is user instance? I have seen this as a parameter
user instance=true

I am not putting this into any kind of production. I am only at this point teaching myself ASP.NET.
0
Lawrence AverySystem DeveloperAuthor Commented:
http://social.technet.microsoft.com/Forums/sqlserver/en-US/0738cb01-106f-4376-b92d-a977a022ece8/the-user-instance-login-flag-is-not-supported-on-this-version-of-sql-server-the-connection-will-be

What I initially was trying to do is automatically create a aspnetdb using a non SQLEXPRESS server instance. I found you can't do that. See above link.
0
Patrick BogersDatacenter platform engineer LindowsCommented:
I know you can only use 'user instance' on mysql. Thats why i needed to ask if you were sure this is what you wanted.
0
Lawrence AverySystem DeveloperAuthor Commented:
What I am seeing as far as user instance use,  is SQL Server is using it in a development environment. MySQL is different than SQL Server correct?
0
Patrick BogersDatacenter platform engineer LindowsCommented:
Yes it is, MySQL is mainly for developers and small companies which have no need for full blown-featured SQL server.
0
Lawrence AverySystem DeveloperAuthor Commented:
It seems like you must define a ASPNETDB define somewhere for your website to run. or database with a default ASPNET membership schema.
0
David Johnson, CD, MVPOwnerCommented:
@Patricksr1972: the question has absolutely nothing to do with MySql but with Microsoft SQL Server and using the aspnetdb.mdf database file and creation of same.

FYI, MySQL is a full featured Sql Server. Saying otherwise and you will have the FOSS community up in arms.. MySql is open source, MS SQL is NOT.

Non express versions of MSSQL server have problems with creating and attaching databases on the fly using the methods that the aspnet web database templates. Once created then the website can be packaged and deployed to a websserver using non express versions with no problems.  Visual Studio only supports the Express versions or I should say Microsoft only officially supports the Express Versions in the support forums.  I've hit that roadblock with SQL2K12
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.