I setup the state db using the aspreg_sql tool. I am storing the session state in my main database. After running the tool, I see the two ASPState tables it created. When I try to interact with those tables using the session("item") command I get the
following error
Invalid object name 'mydb.dbo.ASPStateTempApplications'
I have tried removing the tables and recreating them using the tool but this has been unsuccessful. Any help would be apprecitated!
So on this note, the bset I could do was run a second database to hold the session state data. I just ran the aspreg_sql to create the default session database and the system ran fine. I couldn't find a solution to the original issue. This works fine.
I was just hopeing to not have two databases.
Marked as answer by lion8420 on Mar 10, 2012 01:26 AM
lion8420
Member
24 Points
33 Posts
SQL State managment error
Mar 09, 2012 04:24 AM|LINK
I setup the state db using the aspreg_sql tool. I am storing the session state in my main database. After running the tool, I see the two ASPState tables it created. When I try to interact with those tables using the session("item") command I get the following error
Invalid object name 'mydb.dbo.ASPStateTempApplications'
I have tried removing the tables and recreating them using the tool but this has been unsuccessful. Any help would be apprecitated!
lion8420
Member
24 Points
33 Posts
Re: SQL State managment error
Mar 10, 2012 01:26 AM|LINK
So on this note, the bset I could do was run a second database to hold the session state data. I just ran the aspreg_sql to create the default session database and the system ran fine. I couldn't find a solution to the original issue. This works fine. I was just hopeing to not have two databases.