Plz. tell me how i can create aspnetdb.mdb database file in hosted sql 2005 server because in the classifieds starter kit , only script file for classifedsdb has been provided not for aspnetdb.mdb ..... also tell me how the connection string should be to
access aspnetdb file
I m using quick2host.com which is a reseller of godaddy.com.... they have not provided me any information regarding to use the aspnetdb... whenever i try to create the ASPNETDB database, i get the error msg "cannot create the database because ASPNETDB database
already exits", but when i check the list of databases, there is not ASPNETDB database.
I dont know what to do? I have been trying to solve the problem since last week, but not successful... If u know how to use the ASPNETDB database on godaddy plz. tell me.
I use MS-SQL database for the classiefieds starter kit. U need to setup a MS-SQL database with the classified tables (use the script that is provided.) i am using VS 2005. go to start->visual studio 2005 -> visual studio tools -> visual studio 2005 command
prompt. run the following command:
aspnet_regsql.exe -A all -sqlexportonly C:\runproviders.sql
this will create a script to setup the necessary tables and procedures in your database. the file is on C:\runproviders.sql.
open the file and replace all accurences of aspnetdb with your database name. now run the script. this will setup all the members tables on your MS-SQL database.
Now all you have to do is to create the correct connection strings in your web.config file.
sky_bobby
Member
5 Points
33 Posts
how to create aspnetdb.mdb database in hosted sql 2005 server for classifieds starter kit
Jun 07, 2008 05:43 PM|LINK
Plz. tell me how i can create aspnetdb.mdb database file in hosted sql 2005 server because in the classifieds starter kit , only script file for classifedsdb has been provided not for aspnetdb.mdb ..... also tell me how the connection string should be to access aspnetdb file
Mikesdotnett...
All-Star
154818 Points
19853 Posts
Moderator
MVP
Re: how to create aspnetdb.mdb database in hosted sql 2005 server for classifieds starter kit
Jun 07, 2008 08:45 PM|LINK
Using Access instead of Sql Server for membership is explained here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=404
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
darkknight18...
Contributor
2674 Points
1040 Posts
Re: how to create aspnetdb.mdb database in hosted sql 2005 server for classifieds starter kit
Jun 07, 2008 09:27 PM|LINK
I use godaddy, and I set it up with two MSSQL databases.
The way godaddy has it setup, is when you create a database, it is automatically configured with the aspnetdb for the member info.
Ask your host provider if there is an option to set to use the database as a aspnet members database.
Good Luck
Daniel
Please remember to mark the post as answer that solves your issue.
This will be greatly benificial for other users.
sky_bobby
Member
5 Points
33 Posts
Re: how to create aspnetdb.mdb database in hosted sql 2005 server for classifieds starter kit
Jun 08, 2008 05:21 AM|LINK
I m using quick2host.com which is a reseller of godaddy.com.... they have not provided me any information regarding to use the aspnetdb... whenever i try to create the ASPNETDB database, i get the error msg "cannot create the database because ASPNETDB database already exits", but when i check the list of databases, there is not ASPNETDB database.
I dont know what to do? I have been trying to solve the problem since last week, but not successful... If u know how to use the ASPNETDB database on godaddy plz. tell me.
jhmulder
Member
21 Points
13 Posts
Re: how to create aspnetdb.mdb database in hosted sql 2005 server for classifieds starter kit
Jul 17, 2008 01:09 PM|LINK
Hey,
Am not sure if this is what you are looking for:
I use MS-SQL database for the classiefieds starter kit. U need to setup a MS-SQL database with the classified tables (use the script that is provided.) i am using VS 2005. go to start->visual studio 2005 -> visual studio tools -> visual studio 2005 command prompt. run the following command:
aspnet_regsql.exe -A all -sqlexportonly C:\runproviders.sql
this will create a script to setup the necessary tables and procedures in your database. the file is on C:\runproviders.sql.
open the file and replace all accurences of aspnetdb with your database name. now run the script. this will setup all the members tables on your MS-SQL database.
Now all you have to do is to create the correct connection strings in your web.config file.
<connectionStrings><
remove name="LocalSqlServer" /> <add name="classifiedsConnection" connectionString="Data Source=.;Initial Catalog=Database_Name;Integrated Security=False; User ID=*****;Password=****" providerName="System.Data.SqlClient" /><
add name="LocalSqlServer" connectionString="Data Source=.;Initial Catalog=Database_Name;Integrated Security=False; User ID=*****;Password=****" providerName="System.Data.SqlClient" /></
connectionStrings>Hope this was what you where looking for. Please mark this post as answered if this solves your problem.
Taju
Member
14 Points
8 Posts
Re: how to create aspnetdb.mdb database in hosted sql 2005 server for classifieds starter kit
Jul 20, 2009 02:33 PM|LINK
Hi If you are looking for the detailed explanation for how to create asp.net
membership provider database default name is aspnetdb. Look at this articles
http://programming.top54u.com/post/How-to-Create-Aspnetdb.aspx
http://aspnetmembershipprovider.blogspot.com/2008/04/aspnetdbmdf.html