StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POError tells me I haven't close the connection, but haven't I?
text
Body
copied!<p>I must have missed something here. I am trying to create a table but I am getting an error telling me that connection is still open. But where??? I have re-read the code but I can't find where the connection is still open...</p> <p>Problem lays here: <code>objOleDbConnection.Open()</code></p> <p>Error say: </p> <pre><code>You attempted to open a database that is already opened by user 'Admin' on machine 'machine'. Try again when the database is available. private void sfdNewFile_FileOk(object sender, System.ComponentModel.CancelEventArgs e) { // Creating a ADOX object needed to create // new MS Access file. ADOX.Catalog createMSFile = new ADOX.Catalog(); // Creating an object for a table. Table nTable = new Table(); // Creating an object allowing me connecting to the database. OleDbConnection objOleDbConnection = new OleDbConnection(); objOleDbConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + sfdNewFile.FileName + ";Persist Security Info=False;Mode=12"; // Creating command object. OleDbCommand objOleDbCommand = new OleDbCommand(); objOleDbCommand.Connection = objOleDbConnection; try { // Created a new MS Access 2007 file with specified path. createMSFile.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sfdNewFile.FileName); objOleDbConnection.Open(); objOleDbCommand.CommandText = "CREATE TABLE PersonalData (" + "[DataID] AUTOINCREMENT NOT NULL PRIMARY KEY ," + "[Type] VARCHAR(40) NOT NULL ," + "[URL] VARCHAR(40) NOT NULL ," + "[SoftwareName] VARCHAR(40) NOT NULL ," + "[SerialCode] VARCHAR(40) NOT NULL ," + "[UserName] VARCHAR(40) NOT NULL ," + "[Password] VARCHAR(40) NOT NULL"; objOleDbCommand.ExecuteNonQuery(); } catch (Exception ex) { // Displaying any errors that // might have occured. MessageBox.Show("Error: " + ex.Message); } finally { // It is importnat to release COM object, in this very order // otherwise we eill end up with an error. System.Runtime.InteropServices.Marshal.FinalReleaseComObject(createMSFile); // Closing the connection to the database. objOleDbConnection.Close(); } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload