Reply to thread

Message

<blockquote data-quote="isurutmv" data-source="post: 23373983" data-attributes="member: 470006">C# walin karapu application ekaka database eka thiyenne cpanel eke mata one mage application eka cpanel eke database ekath ekka connect karanna man mage connection eke code eka thama me[CODE]private string databaseName = string.Empty;&nbsp; &nbsp; &nbsp; &nbsp; public string DatabaseName&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return databaseName; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; set { databaseName = value; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string Password { get; set; }&nbsp; &nbsp; &nbsp; &nbsp; private MySqlConnection connection = null;&nbsp; &nbsp; &nbsp; &nbsp; public MySqlConnection Connection&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return connection; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private static DbConnection _instance = null;&nbsp; &nbsp; &nbsp; &nbsp; public static DbConnection Instance()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (_instance == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _instance = new DbConnection();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return _instance;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public bool IsConnect()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Connection == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (String.IsNullOrEmpty(databaseName))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string connstring = string.Format(&quot;Server=xx.xxx.xxx.xxx;database={0}; UID=xxxxx; password=xxxxxx;SslMode = none&quot;, databaseName);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection = new MySqlConnection(connstring);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection.Open();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public void Close()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connection.Close();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }[/CODE]but mata me error eka enawa[CODE]MySql.Data.MySqlClient.MySqlException was unhandled&nbsp; Code=0&nbsp; ErrorCode=-2147467259&nbsp; HResult=-2147467259&nbsp; Message=Unable to connect to any of the specified MySQL hosts.&nbsp; Number=1042&nbsp; Source=MySql.Data&nbsp; StackTrace:&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.NativeDriver.Open()&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.Driver.Open()&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlPool.GetConnection()&nbsp; &nbsp; &nbsp;&nbsp; at MySql.Data.MySqlClient.MySqlConnection.Open()&nbsp; &nbsp; &nbsp;&nbsp; at POS_Jayamal.DbConnection.IsConnect() in C:\Users\123456\Documents\POS_Jayamal\POS_Jayamal\DBConnection.cs:line 49&nbsp; &nbsp; &nbsp;&nbsp; at POS_Jayamal.StockDetailsForm.load_items() in C:\Users\123456\Documents\POS_Jayamal\POS_Jayamal\StockDetailsForm.cs:line 23&nbsp; &nbsp; &nbsp;&nbsp; at POS_Jayamal.StockDetailsForm.StockDetailsForm_Load(Object sender, EventArgs e) in C:\Users\123456\Documents\POS_Jayamal\POS_Jayamal\StockDetailsForm.cs:line 16&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Form.OnLoad(EventArgs e)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Form.OnCreateControl()&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Control.CreateControl()&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Control.WmShowWindow(Message&amp; m)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Control.WndProc(Message&amp; m)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.ScrollableControl.WndProc(Message&amp; m)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Form.WmShowWindow(Message&amp; m)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Form.WndProc(Message&amp; m)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message&amp; m)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message&amp; m)&nbsp; &nbsp; &nbsp;&nbsp; at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)&nbsp; InnerException: &nbsp; &nbsp; &nbsp;&nbsp; Code=0&nbsp; &nbsp; &nbsp;&nbsp; ErrorCode=-2147467259&nbsp; &nbsp; &nbsp;&nbsp; HResult=-2147467259&nbsp; &nbsp; &nbsp;&nbsp; Message=Timeout expired.&nbsp; The timeout period elapsed prior to completion of the operation or the server is not responding.&nbsp; &nbsp; &nbsp;&nbsp; Number=0&nbsp; &nbsp; &nbsp;&nbsp; Source=MySql.Data&nbsp; &nbsp; &nbsp;&nbsp; StackTrace:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; at MySql.Data.MySqlClient.NativeDriver.Open()&nbsp; &nbsp; &nbsp;&nbsp; InnerException: [/CODE]Access Host ekata PC eke IP ekath deela thiyenne bn<img src="/styles/default/xenforo/smilies/default/sorry.gif"&nbsp; class="smilie" loading="lazy" alt=":sorry:" title="Sorry&nbsp; &nbsp; :sorry:" data-shortname=":sorry:" /><img src="/styles/default/xenforo/smilies/default/sorry.gif"&nbsp; class="smilie" loading="lazy" alt=":sorry:" title="Sorry&nbsp; &nbsp; :sorry:" data-shortname=":sorry:" /><img src="/styles/default/xenforo/smilies/default/sorry.gif"&nbsp; class="smilie" loading="lazy" alt=":sorry:" title="Sorry&nbsp; &nbsp; :sorry:" data-shortname=":sorry:" /><img src="/styles/default/xenforo/smilies/default/sorry.gif"&nbsp; class="smilie" loading="lazy" alt=":sorry:" title="Sorry&nbsp; &nbsp; :sorry:" data-shortname=":sorry:" /></blockquote>

[QUOTE="isurutmv, post: 23373983, member: 470006"] [SIZE="5"] C# walin karapu application ekaka database eka thiyenne cpanel eke mata one mage application eka cpanel eke database ekath ekka connect karanna man mage connection eke code eka thama me [CODE] private string databaseName = string.Empty; public string DatabaseName { get { return databaseName; } set { databaseName = value; } } public string Password { get; set; } private MySqlConnection connection = null; public MySqlConnection Connection { get { return connection; } } private static DbConnection _instance = null; public static DbConnection Instance() { if (_instance == null) _instance = new DbConnection(); return _instance; } public bool IsConnect() { if (Connection == null) { if (String.IsNullOrEmpty(databaseName)) return false; string connstring = string.Format("Server=xx.xxx.xxx.xxx;database={0}; UID=xxxxx; password=xxxxxx;SslMode = none", databaseName); connection = new MySqlConnection(connstring); connection.Open(); } return true; } public void Close() { connection.Close(); } } [/CODE] but mata me error eka enawa [CODE] MySql.Data.MySqlClient.MySqlException was unhandled Code=0 ErrorCode=-2147467259 HResult=-2147467259 Message=Unable to connect to any of the specified MySQL hosts. Number=1042 Source=MySql.Data StackTrace: at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open() at POS_Jayamal.DbConnection.IsConnect() in C:\Users\123456\Documents\POS_Jayamal\POS_Jayamal\DBConnection.cs:line 49 at POS_Jayamal.StockDetailsForm.load_items() in C:\Users\123456\Documents\POS_Jayamal\POS_Jayamal\StockDetailsForm.cs:line 23 at POS_Jayamal.StockDetailsForm.StockDetailsForm_Load(Object sender, EventArgs e) in C:\Users\123456\Documents\POS_Jayamal\POS_Jayamal\StockDetailsForm.cs:line 16 at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) InnerException: Code=0 ErrorCode=-2147467259 HResult=-2147467259 Message=Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Number=0 Source=MySql.Data StackTrace: at MySql.Data.Common.StreamCreator.GetTcpStream(MySqlConnectionStringBuilder settings) at MySql.Data.Common.StreamCreator.GetStream(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.NativeDriver.Open() InnerException: [/CODE] Access Host ekata PC eke IP ekath deela thiyenne bn:sorry::sorry::sorry::sorry: [/SIZE] [/QUOTE]

Verification

Haya warak paha keeyada? (haya wadi kireema paha)

Search

Latest ads

Reply to thread