This may or may not need to be moved to the deployment folder...


Okay I have a vb.Net application that connections to a sql server 2005 database "TacticalDB" while debugging the application I was using the connection string,

Code:
Dim con As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS; AttachDbFilename=" + Application.StartupPath + "\Data\TacticalDB.mdf; Database=TacticalDB; Trusted_Connection=True; User Instance=true")
Which works fine, but I have moved into getting the application ready for deployment and so I created a setup application in the same solution as the application. Now I have added the database file with the setup but when my application gets to the con.Open() line it catches an exception,
Code:
System.Data.SqlClient.SqlException: Database 'C:\Users\John\Documents\Visual Studio 2008\Projects\Blackout_Scout\Blackout_Scout\bin\x86\Debug\Data\TacticalDB.mdf' already exists. Choose a different database name.
Cannot attach the file 'C:\Program Files (x86)\Microsoft\Setup1\Data\TacticalDB.mdf' as database 'TacticalDB'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Blackout_Scout.Module1.ScoutTeam(String MatchText, ArrayList tNames, ArrayList Players, ArrayList OppTeam)
Now I only have the one place where the application should look for the Database and thats Application.startupPath/Data/TacticalDB.mdf and if im running the newly installed exe it shouldn't look back in the myprojects folder but it is.

Can anyone provide insight as to what I'm doing wrong? is my connection string wrong in someway? Because I've been trying to sort this for a while now and its not working