locked
Using Club Starter Kit with SQL 2000 RRS feed

  • Question

  • User-1505509498 posted
    Can you give me the 'quick and dirty' directions to configure the Club Starter Kit to use SQL 2000 ?  I'm having trouble getting the Web Admin Tool to see my local installation of SQL.
    Tuesday, April 19, 2005 2:13 AM

All replies

  • User-1622535684 posted

    When you go to the providers tab of the web admin is the an add button. I have seen this missing in some version.

    If it is not there you may be able to configure it through the properties of the virtual directory itself. However this is not an option that I have been able to figure out on XP.

    Tuesday, April 19, 2005 3:16 PM
  • User-1653776603 posted

    If you look in the web.config you will see the connection string for the database. You can change it to point to a different server/database. It works fine with sql2000, there should not be any yukon dependencies in the code or sql.

    Sam

    Tuesday, April 19, 2005 8:57 PM
  • User-1505509498 posted

    Apparently, it's not as easy as that...

    I deleted all references to the project; from the backup files folder and the projects folder, and I deleted the cached version in Microsoft.NET\Framework\v2.0.50215\Temporary ASP.NET Files. I created a new web project and edited the web.config replacing ".\SQLEXPRESS" with the name of my locally running instance of SQL Server 2000 (developer edition). I built the site. On loading it I received the following message:

    SSE Instance re-direction is not supported for non-local user instances.

    I'm guessing that the template has SQLExpress hard coded somewhere, but I can't find it.

    Please post a fix for this soon.

    Thursday, April 21, 2005 4:12 PM
  • User-1653776603 posted

    It sounds like you have an incorrect connection string, it should look something like:

    <add name="ClubSiteDB" connectionString="Data Source=SERVERNAME;Initial Catalog=DATABASENAME;Persist Security Info=True;User ID=MYUSER;Password=MYPASSWORD" providerName="System.Data.SqlClient" />

    You'll also need to copy the tables and stored procedures from the SQL express database to your SQL2000 server.

    Thursday, April 21, 2005 4:35 PM
  • User-220121198 posted

    What's the DB schema, I mean, where can I find the tables, SP etc that's included in the Sqlexpress?

    thanks

    assigned

    Friday, April 22, 2005 12:50 PM
  • User-1631720260 posted

    The SQL files will be posted by the middle of next week.

    Friday, April 22, 2005 2:08 PM
  • User-220121198 posted

    Thanks. Any ideas how to uninstall the failed installation of Sql Express?

    I can not get it to install, (tried on two different machines with same results).

    Trouble is, it will not allow me to reinstall Sql 2000. I get the error, "setup has detected a previous installation did not complete. Click ok to retry of cancel to exit setup". If I click ok, installation proceed to 100%, then fails on registering scipts 1 of 17.

    I have used Regserv  to reregister DMO, but no help. I am stumped.

    Thanks,

    assigned

    Friday, April 22, 2005 8:33 PM
  • User-1505509498 posted
    Is there any news about the SQL scripts?
    Friday, April 29, 2005 9:12 AM
  • User-1707944838 posted

    I've opened the database in sql2005 beta2, generated a script for it, then ran the script in sql2000 and all went fine.

    oVan

    Saturday, April 30, 2005 4:30 AM
  • User1069864797 posted

    oVan, did you mean SQL2005 beta2, or SQL2005 Express beta2?  I only have the Express version... it is possible to open the database and generate the script in the Express version?

    Sunday, May 1, 2005 3:15 PM
  • User-1707944838 posted

    I did not test the Express version, but imho that should work also?

    oVan

    Sunday, May 1, 2005 3:54 PM
  • User431416295 posted
    If you only have SQL Express you don't have any tools to use to create the script. There is no Enterprise Manager in that edition.

    Endre
    Monday, May 2, 2005 9:34 AM
  • User273807300 posted

    I've opened the database in sql2005 beta2, generated a script for it, then ran the script in sql2000 and all went fine.

    oVan



    Could you provide us the sql script please ?

    Thank you.
    Friday, November 4, 2005 1:58 PM
  • User1203431057 posted
    Here ya go.
     
    I found this in the club site app_data dir club-add.sql

    I ran this script in sql 2000 and it works great.

    Hope this helps ya,

    Frank C Clark

    Wednesday, November 9, 2005 2:29 AM
  • User273807300 posted

    Thx contexum,

    Actually I found it in another post on this forum.

    Wednesday, November 9, 2005 6:21 AM