Databas path in Visuel Web Developer 2008

Discussion in 'Databases' started by Nyqvist, Jun 11, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I have ried to change the Database path i Visuel Web Devloper, but I cant find any info about how to do that.


    Today am I abel to set up working authorization databases locally on my computerm, se search path for the data base is c:\...\App_Data


    When I


    *FTP
    *Use se internal Copy to Host service
    *Work "remote" whit in VWD 2008
    *Add a connection string in the webconfig (can have done some strange at this point, but I tought it looked ok)


    But the search path doesn't change to ~/App_Data , i will remain c:\...\App_Data from the host... ponting to my computer hardrive.


    I have looked around whitin the program, but can't find anything to make it work... pictures will show (don't know if the path there was c:\ or ~/ form the begining)


    /xMatt
     
  2. Hi,
    Are you trying to use an Express Database in the App_Data folder?
     
  3. When I start the built in manage Authorization does that automatically genreate a database in that folder.

    I have also placed some access db in that folder and trough the wizards with in VWD do I not have any problem and genreate gridviews and so on.

    I have tried to create gridview with the Authorizations DB, but when I trying to connect to them does the VWD browse my HD (working remote to my account at discountasp.net).

    //Matte
     
  4. Hi,
    Yes the Express products will create an Express DB, not an Access DB, not a full SQL Server DB.
    You can use the same ASP.NET code on DASP except for for the Express connection string and Express DB.
    If you're using Windows Server 2003 an Access DB can be used if you don't have a SQL Server addon yet.
    Getting all your code to work with an Access DB is rather tricky.
    Hope that helps some at least. [​IMG]
    Salute,
    Mark
     
  5. I have addes the 2005 sql server to my discount asp.net account.

    I have also picked upp a conncetion string:

    "Data Source=tcp:sql2k511.discountasp.net;Initial Catalog=SQL2005_491270_basement;User ID=*****;Password=******;"

    Kan I use this 2005 SQL DB in order to create a Authorization "function" with the built in LogIn class.

    I would be really greatfull for any ex for links to some C# sharop tutorial in this matter.

    Br
    Matt
     
  6. Ok, along the above lines...


    I have Visual Web Developer 2008 Express configured touse theSQL server on DASP. Now it is time for me to implement a login, and of course when I do that it creates a local DB. I uploaded all tables and data to the DASP SQL server successfully, but I'm drawing a blank trying to get the membership provider to take to the remote server, not the local one.


    In my web.config file, it shows the connectionstring and all pointing to the remote server, but does anyone know what I have to enter to make that database the membership provider?


    Thanks in advance


    -Matt
     
  7. Hi,
    I'm sure serveal of us can help you with this.
    To be clear...Are you asking if everything can be sync'd between local and remote?
    (So you can test locally but the same actions take place live.)
    If so, I'd recommend installing SQL Server Express locally and using it to pump the database.
    I've been getting a lot of Emails to create a Webcast for this.

    The rest of my time is spent with my kids. [​IMG]
    http://www.youtube.com/watch?v=oxOTR1wIcds
    Salute,
    Mark Wisecarver
     
  8. Thanks for responding. Below is my working connection string. Using it, my site (working in VWD2008Ex or live) pings the SQL server on DASP and works ok to retrieve data.


    connectionStrings


    add name="SQL2005_549655_projectrepuConnectionString" connectionString="Data Source=sql2k513.discountasp.net;Initial Catalog=SQL2005_549655_projectrepu;Persist Security Info=True;User ID=SQL2005_549655_projectrepu_user;Password=******"


    providerName="System.Data.SqlClient"


    connectionStrings


    However, now I'm trying to create a simple membership login, so I went thru the stepsI normally do (I click ASP.NET configuration, select forms, create a test user, yada yada.) So that process creates the default ASPNETDB or whatever it is.


    So I published that DB, ran the scripts on DASP SQL server, so all the tables are live, including my test user.


    So... what Im asking is how do I get the membership provider to work from the SQL server, not the local DB?


    Whats interesting is there is no membership provider listed in my web.config file, so it seems VWD2008Ex is hiding something from me.


    So, long story short, when I uploaded everything to the live site, (http://www.projectrepublic.org) and try to log in, it throws an error to the effect that its looking for a DB in the App_Data folder. Again, I cant find any such references in my web.config file, but thats where its looking.


    You can verify the error by visiting the site and attempting to login.
     
  9. Hi,
    Did you create the membership roles using the remote SQL Server info?
    Like video #3 on this page: http://iis7test.com/webcasts/

    If you created them locally only take a look at video #8 on that page.
    Video #10 also goes into how to use VWD for the remote DB.
    Salute,
    Mark
     
  10. You.... are the man

    Video 10, the bit about removing and overriding the LocalSqlServer did the trick. I probably watched about 3 hours worth of videos, read about 20 articles and tutorials... notta dang one mentions over riding the LocalSqlServer.

    Thanks again,

    Matt
     
  11. Awesome [​IMG]
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page