How can i test my TSQL syntax?
Posted
by acidzombie24
on Stack Overflow
See other posts from Stack Overflow
or by acidzombie24
Published on 2010-05-18T04:33:49Z
Indexed on
2010/05/18
4:40 UTC
Read the original article
Hit count: 176
Quick question: How do i get some kind of database to use to test my sql syntax and create basic data.
I have Sqlite Code which i'll soon put on a server. I have sql server 2008 installed with visual studio 2010. I tried connecting to the database and had no luck.
I also tried using a .mdf file instead thinking its a file and i wont have connectivity issues. Wrong, i still couldnt connect and i used this site to help me (i'm aware its 2005)
In that case i used
var conn = new SqlConnection(@"Server=.\SQLExpress;AttachDbFilename=C:\dev\src\test\SQL_DB_VS_Test\test.mdf;Database=dbo;Trusted_Connection=Yes;");
exception
Unable to open the physical file "C:\dev\src\test\SQL_DB_VS_Test\test.mdf". Operating system error 5: "5(Access is denied.)".
Cannot attach the file 'C:\dev\src\test\SQL_DB_VS_Test\test.mdf' as database 'dbo'.
with trusted = no i get Login failed for user ''.
(What user am i suppose to set...). I created the .mdf with visual studio somehow.
© Stack Overflow or respective owner