Click here to Skip to main content
       

Database

 
AnswerRe: Problem with MySQL stored procedure PinmemberShameel8-Oct-12 1:56 
GeneralRe: Problem with MySQL stored procedure Pinmemberjrahma8-Oct-12 6:54 
GeneralRe: Problem with MySQL stored procedure Pinmemberjrahma8-Oct-12 7:11 
Questionterminating SqlConnection.Open() call while connecting PinmemberDan_K4-Oct-12 7:43 
AnswerRe: terminating SqlConnection.Open() call while connecting [modified] PinmemberShameel4-Oct-12 8:46 
AnswerRe: terminating SqlConnection.Open() call while connecting PinmemberEddy Vluggen4-Oct-12 9:10 
GeneralRe: terminating SqlConnection.Open() call while connecting PinmemberDan_K5-Oct-12 4:37 
GeneralRe: terminating SqlConnection.Open() call while connecting PinmemberEddy Vluggen5-Oct-12 4:57 
Dan_K wrote:
I tried in my own way which works fine now. My BackgroundWorker thread creates a new thread and the created thread rather calls SqlConnection.Open(). When the cancel button is clicked, the BackgroundWorker thread aborts the thread opening the connection.

That's what the OpenAsync in 4.5 will do; open the query on a backgroundthread, polling it's status.
 
Dan_K wrote:
It works fine although I don't know if there could be any related problems.

Opening a connection can fail for multiple reasons, and exceptions aren't casted across the thread. You might want to make sure you have a good exception-handler in there; if you have the time, then it'd be mighty cool to have a "try connecting again" function - that way people won't have to relaunch the app after they found out that the database-server wasn't powered on.
Bastard Programmer from Hell Suspicious | :suss:
if you can't read my code, try converting it here[^]

QuestionSQL 2000 to 2008R2 Query Performance Pinmembercjb1104-Oct-12 5:13 
AnswerRe: SQL 2000 to 2008R2 Query Performance PinmemberShameel4-Oct-12 9:01 
GeneralRe: SQL 2000 to 2008R2 Query Performance Pinmembercjb1104-Oct-12 22:30 
AnswerExecution plan PinmemberDavid Mujica4-Oct-12 10:25 
GeneralRe: Execution plan Pinmembercjb1104-Oct-12 20:58 
GeneralRe: Execution plan PinmemberDavid Mujica8-Oct-12 8:54 
GeneralRe: Execution plan Pinmembercjb1108-Oct-12 23:41 
GeneralRe: Execution plan PinmemberDavid Mujica9-Oct-12 3:12 
GeneralRe: Execution plan Pinmembercjb1109-Oct-12 4:34 
GeneralHigh CPU PinmemberDavid Mujica9-Oct-12 9:13 
GeneralRe: High CPU Pinmembercjb11010-Oct-12 21:30 
GeneralRe: High CPU Pinmembercjb11010-Oct-12 23:15 
QuestionMySQL Server timestamp changed! Pinmemberjrahma2-Oct-12 21:53 
AnswerRe: MySQL Server timestamp changed! PinmemberShameel3-Oct-12 4:05 
QuestionConnection String for Ms access 2010 to Windows 7 64 Bit PinmemberSatyam Tripathi2-Oct-12 21:33 
AnswerRe: Connection String for Ms access 2010 to Windows 7 64 Bit PinmvpRichard MacCutchan2-Oct-12 22:00 
QuestionBackup/Recover of row data in a multi-Company database PinmemberDeDawg2-Oct-12 10:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.140926.1 | Last Updated 30 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid