INSERT problem - julb

Hi everyone,

I just wrote a simple app to insert some data into a database. Here's
the code:

private void FillDB()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=.
\SQLEXPRESS;AttachDbFilename=|DataDirectory|\test.mdf;Integrated
Security=True;User Instance=True";
conn.Open();
SqlCommand command;
int res;
command = new SqlCommand("INSERT \"test\" (col1, col2)
VALUES ('hallo', 'world')", conn);
res = command.ExecuteNonQuery();
conn.Close();
}

the problem is, that although the result value of ExecuteNonQuery() is
one (i.e. one row is affected) nothing was added into the DB!!!
Does anyone know what's going on here???

Thanks a lot in advance,
Julie

INSERT problem - brian.twardzi

Named pipe, check...
Integrated security, check...
Insert syntax is correct...

@_@ I have no idea...I blame SQL Express.

INSERT problem - Tibor Karaszi

I'd use a Profiler trace to see what is actually submitted to SQL Server. I haven't worked with
attached databases this way, though...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

INSERT problem - M

How have you verified that no data exists? Are you connecting to the same
database?


ML

---
http://milambda.blogspot.com/

INSERT problem - Juliane Bach

yes I am... I created the database within VS2005 and use the connection
string that was generated by Visual Studio. Anyhow, there is no other DB
with that name on my hard drive.

INSERT problem - Tibor Karaszi

How about schema? I suggest you schema qualify the object name...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

INSERT problem - julb

Hi Tibor,

sorry... I'm quite experienced to programming but a newbie to
databases... what do you mean by schema qualifying what object name?
I think that there may be I rights problem... but i dont know what it
could be... I am able to make queries, however... just insert, update,
create table etc. don't work...

INSERT problem - M

In your query:

INSERT test (col1, col2)
VALUES ('hallo', 'world')

...the name of the destination object (table? view?) "test" is not
schema-qualified (e.g. dbo.test). Perhaps the object exists in more schemas
than one?

Also check your permissions.


ML

---
http://milambda.blogspot.com/

INSERT problem - julb

I don't think that this is the problem, as a select query works this
way, but I'm gonna check it...


I guess, that the problem has something to do with permissions, but as
I posted, I've no idea on where to look and check them...

Julie