Db exists but sql server says no to copy

This issue is so frustrating. I am hoping someone knows the answer to this specific question.

Why would sql server insist that a database does not exist even though it obviously does exist?

I get the error message: Database 'tf_1' does not exist.

Why would it say it does not exist when it is clearly viewable in SMSS. It attached without problem. I can view the tables in the database. I know it's there; SMSS knows it's there; the VB app I wrote knows it's there. But, when I try to run a query to copy a table from one database to another, sql server says it doesn't exist! What gives?

Yes, I asked this question before but nobody answered. The problem is back!

This is the sql statement in vb:

sql = "SELECT [DateTime], [Open], [High], [Low], [Close], [Volume] INTO "
sql = sql & DestDbName & ".dbo." & TableName
sql = sql & " FROM " & TableName & ";"

The connection string:

strDbConn = "Provider=SQLNCLI;Integrated Security=SSPI;" & _
"Persist Security Info=False;" & _
"AttachDBFileName=" & DbPath

is used to open a connection to the source database.

You can't specify an object name like that as a variable. Use a literal variable there, or put the object names in a temp table and cursor through them that way. There are solutions available in scripts across the web - check here:

http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx?mfr=true

|||

I am not sure if you can do this opertaion (inserting into other database) when you connect to DB FILE instaed of the server.

I don think you are trying to insert the data into the same database, but if you are you do not have to specify the database name.