locked
How to get to work with SQL Server 2000 RRS feed

  • Question

  • User-1252885237 posted

    I am am a newbie when it comes to .NET.  I am trying to get this Classifieds website running on my Windows 2000 Server with SQL Server 2000 installed for the database.  I relize this uses sql express so what is it that I need to do to get this to work using Sql Server 2000?

    So far I have created two databases on my Sql Server 2000 called ASPNETDB and CLASSIFIEDSDB.

    I have this for my connectionstring:

    <add name="classifiedsConnection" connectionString="Data Source=servername; Initial Catalog=ASPNETDB; User ID=myid; Password=mypass;" providerName="System.Data.SqlClient" />
        <remove name="LocalSqlServer"/>
        <add name="LocalSqlServer" connectionString="Data Source=servername; Initial Catalog=CLASSIFIEDSDB; User ID=myid; Password=mypass;" providerName="System.Data.SqlClient" />

    So basically right now I have two blank databases setup.  Can I load the table structure into these databases using the classifieds-add.sql and classifieds-categories.sql files?  If so, how?

    I relize this won't work yet til I get this figure out but when I test I get this error:

    Could not find stored procedure 'dbo.GetAdsByRandomOrder'.

    Thursday, August 27, 2009 2:58 PM

All replies

  • User-1252885237 posted

    I got this particular issue resolved.  I just ran those two files with the query analyzer.  Now I am getting another error:

    Error    103    Name 'LocationsDB' is not declared.

    I will do a new post for this problem.

    Thursday, August 27, 2009 5:35 PM