This is from the end of the deployment log:



• 7/10/2008 2:00:39 PM   -> Finished verifying databases on server.

• 7/10/2008 2:00:39 PM   -> Executing Post-Deployment Scripts

• 7/10/2008 2:00:39 PM   -> Executing Post-Deployment Scripts - Complete

• 7/10/2008 2:00:39 PM   -> The meta data conversion to the SQL Server has been completed.

X 7/10/2008 2:00:39 PM   -> An error occurred while deploying the data to the server.

X 7/10/2008 2:00:39 PM   -> InvalidOperationException

X 7/10/2008 2:00:39 PM   -> The connection was not closed. The connection's current state is open.

X 7/10/2008 2:00:39 PM   ->

X 7/10/2008 2:00:39 PM   -> Source : System.Data

X 7/10/2008 2:00:39 PM   ->

X 7/10/2008 2:00:39 PM   -> Stack Trace:

X 7/10/2008 2:00:39 PM   -> at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

X 7/10/2008 2:00:39 PM   -> at System.Data.SqlClient.SqlConnection.Open()

X 7/10/2008 2:00:39 PM   -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeployDataThread()

X 7/10/2008 2:00:39 PM   ->





Notice it was successful. I'm using the dataprogress.vb form class from the demo source for database installer sample. I'm guessing something is not getting cleaned up properly but I'm not sure what.



My code that calls the form is thus:



' Update database

Dim loData As New DataProgress()



''-- Show and install database changes

dr = loData.ShowDialog()

loData.Close()

loData.Dispose()



I added the code to close and dispose the progress form so that I could delete the package file. Unfortunately, I'm not sure if this is where the problem started...

Ah, good thought. I am deploying data and I didn't even check to see if the data from my 2 tables was successfully deployed. My guess is I won't see any data in those tables since this just shows metadata was successful, I bet you're right, it's trying to deploy the data next and that's where it blows up. I'll take a look in the morning and let you know.



Thanks!