Last post Aug 27, 2009 05:35 PM by thedee
Aug 27, 2009 02:58 PM|thedee|LINK
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" />
<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:
Aug 27, 2009 05:35 PM|thedee|LINK
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.