SQL problems

[PT Exorcist]

grr..seems i am having a LOT of problems with sql now

everytime i try to run a project that did run before i get SqlException saying only "System Error"...arent there places where i can see the logs of detailed things about the error? has anyone happened this before? what should i do? i just re-installed and still the same error

[hellswraith]

Are you using stored proceedures, or just plain old SQL Statments? If you are using SQL statements, post them here and we can find the error. That is most likely the place the error is happening.

When you rebuilt your database after formatting, did you name all the columns, tables, etc... all EXACTLY the same way? Or did you even change them at all?

Anyway, post the code that is giving you the errors, and we can check it out.

What is the SqlException saying?

[PT Exorcist]

SqlException saying only "System Error"...

[PT Exorcist]

i currently only have:

			SqlConnection connection = new SqlConnection(
				@"Data Source=(local); Integrated Security=SSPI; Initial Catalog=northwind");

			connection.Open();
			connection.Close();

[PT Exorcist]

seems i have the problem fixed, the examples i had were using northwind database that now isnt installed, i have it in a folder, tried moving it to the folder where i have my databases but i still cant use it..how can i achieve this? i would like to use it and other small databases that i have done in the past that i have in a separate folder..tks in advance

[Slow_Learner]

In the folder there should be a .sql script that will install the database. Although as I remember there is in option somewhere in the help that will install Northwind for you, let me see if I can find that.

[Slow_Learner]

Look at:

ms-help://MS.VSCC/MS.MSDNVS/dnmsde/html/msdeforvs.htm#msdeforvs_topic4

down around the middle there is instruction on how to import the MS Access Northwind into MSDE.