Can't find temporary table but ODBC says it exists

[jfcox]

Hi,

I've never used temporary tables before and I'm having a problem. I can create a local or global temporary table with no problem. When I try to do an insert or update to the table I just created, I get an error that the object doesn't exist. I can run a select * on the temporary table and I get nothing back of course but it does run without error. If I try to create the table again, I get an error that says it already exists. I have looked in the tempdb as well as the DB I was working on. Where in the heck is the table? Can you ever see it? How do I do an insert or update? I'm using ODBC for all the connections, is this a problem?

Thanks in advance to whom ever can answer this!

 

[SQLSister]

Please post the code you use to create and then insert into a temp table.