private void btnSetConnect_Click(object sender, EventArgs e) { MSDASC.DataLinks datalinks = new MSDASC.DataLinksClass(); ADODB._Connection tmpconc = new ADODB.ConnectionClass(); if (TxtDbstr.Text == String.Empty) { tmpconc = (ADODB._Connection)datalinks.PromptNew(); if (tmpconc != null) { TxtDbstr.Text = tmpconc.ConnectionString; } } else { Object oconc = tmpconc; tmpconc.ConnectionString = TxtDbstr.Text; try { if (datalinks.PromptEdit(ref oconc)) { TxtDbstr.Text = tmpconc.ConnectionString; } } catch { tmpconc = (ADODB._Connection)datalinks.PromptNew(); if (tmpconc != null) { TxtDbstr.Text = tmpconc.ConnectionString; } } } }
public static string GetBuiltConnectionString(string inputConnectionString) { MSDASC.DataLinks oDL = null; string res = string.Empty; try { oDL = new MSDASC.DataLinksClass(); ADODB.Connection conn = new ADODB.ConnectionClass(); conn.ConnectionString = inputConnectionString; object oConn = (object)conn; if (oDL.PromptEdit(ref oConn)) { res = conn.ConnectionString; } } catch { try { ADODB._Connection oConn = (ADODB._Connection)oDL.PromptNew(); if (oConn != null) { res = oConn.ConnectionString.ToString(); } } catch (Exception ex) { MyExceptionHandler.NewEx(ex); } } return(string.IsNullOrEmpty(res) ? null : res); }
/// <summary> /// Displays a Connection String Builder (DataLinks) dialog. /// /// Credits: /// http://www.codeproject.com/cs/database/DataLinks.asp /// http://www.codeproject.com/cs/database/DataLinks.asp?df=100&forumid=33457&select=1560237#xx1560237xx /// /// Required COM references: /// %PROGRAMFILES%\Microsoft.NET\Primary Interop Assemblies\adodb.dll /// %PROGRAMFILES%\Common Files\System\Ole DB\OLEDB32.DLL /// </summary> /// <param name="currentConnectionString">Previous database connection string</param> /// <returns>Selected connection string</returns> private string PromptForConnectionString(string currentConnectionString) { MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass(); ADODB.Connection dialogConnection; string generatedConnectionString = string.Empty; if (currentConnectionString == String.Empty) { dialogConnection = (ADODB.Connection)dataLinks.PromptNew(); generatedConnectionString = dialogConnection.ConnectionString.ToString(); } else { dialogConnection = new ADODB.Connection(); dialogConnection.Provider = "SQLOLEDB.1"; ADODB.Property persistProperty = dialogConnection.Properties["Persist Security Info"]; persistProperty.Value = true; dialogConnection.ConnectionString = currentConnectionString; dataLinks = new MSDASC.DataLinks(); object objConn = dialogConnection; if (dataLinks.PromptEdit(ref objConn)) { generatedConnectionString = dialogConnection.ConnectionString.ToString(); } } generatedConnectionString = generatedConnectionString.Replace("Provider=SQLOLEDB.1;", string.Empty); if ( !generatedConnectionString.Contains("Integrated Security=SSPI") && !generatedConnectionString.Contains("Trusted_Connection=True") && !generatedConnectionString.Contains("Password="******"Pwd=") ) { // BSG: Updated for null check on Value not only Password Property. if (dialogConnection.Properties["Password"].Value != null) { generatedConnectionString += ";Password="******"Password"].Value.ToString(); } } return(generatedConnectionString); }
public override object EditValue(ITypeDescriptorContext context, IServiceProvider provider, object value) { Cursor.Current = Cursors.WaitCursor; string tmpReturn = string.Empty; MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass(); ADODB._Connection connection = null; if (value.ToString() == String.Empty) { try { connection = (ADODB._Connection)dataLinks.PromptNew(); if (connection != null) //if cancel is pressed connection is null { tmpReturn = connection.ConnectionString; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { connection = new ADODB.ConnectionClass(); connection.ConnectionString = value.ToString(); object oConnection = connection; try { if ((bool)dataLinks.PromptEdit(ref oConnection)) { tmpReturn = connection.ConnectionString; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } Cursor.Current = Cursors.Default; return(tmpReturn); }
/// <summary> /// Get ConnectionString /// </summary> public string GetConnectionString() { /* Reference DataLinks NOTE: Reference C:\Program Files\Common Files\System\Ole DB\OLEDB32.DLL (Was MSDASC.dll) SEE: http://support.microsoft.com:80/support/kb/articles/Q225/1/32.asp */ MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass(); //note that a reference to: // c:\Program Files\Microsoft.NET\Primary Interop Assemblies\adodb.dll //is also required to read the ADODB._Connection result ADODB._Connection connection; // get a new connection string //Prompt user for new connect string connection = (ADODB._Connection)dataLinks.PromptNew(); //read result return connection.ConnectionString.ToString(); }
private void button3_Click(object sender, System.EventArgs e) { MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass(); ADODB._Connection connection; if (connectionString.Text == String.Empty) { try { connection = (ADODB._Connection)dataLinks.PromptNew(); connectionString.Text = connection.ConnectionString.ToString(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { connection = new ADODB.ConnectionClass(); connection.ConnectionString = connectionString.Text; object oConnection = connection; try { if (dataLinks.PromptEdit(ref oConnection)) { connectionString.Text = connection.ConnectionString; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
private void button3_Click(object sender, System.EventArgs e) { MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass(); ADODB._Connection connection; if (connectionString.Text == String.Empty) { try { connection = (ADODB._Connection) dataLinks.PromptNew(); connectionString.Text = connection.ConnectionString.ToString(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { connection = new ADODB.ConnectionClass(); connection.ConnectionString = connectionString.Text; object oConnection = connection; try { if (dataLinks.PromptEdit(ref oConnection)) { connectionString.Text = connection.ConnectionString; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
private void btnConnectionString_Click(object sender, EventArgs e) { ADODB.Connection Conn = null; String ConnectionString = tbConnectionString.Text; MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass(); if (ConnectionString == string.Empty) { Conn = (ADODB.Connection)dataLinks.PromptNew(); } else { Conn = new ADODB.Connection(); Conn.ConnectionString = tbConnectionString.Text; object TempConn = Conn; if (dataLinks.PromptEdit(ref TempConn)) ConnectionString = Conn.ConnectionString; } tbConnectionString.Text = Conn.ConnectionString; }
/// <summary> /// Displays a Connection String Builder (DataLinks) dialog. /// /// Credits: /// http://www.codeproject.com/cs/database/DataLinks.asp /// http://www.codeproject.com/cs/database/DataLinks.asp?df=100&forumid=33457&select=1560237#xx1560237xx /// /// Required COM references: /// %PROGRAMFILES%\Microsoft.NET\Primary Interop Assemblies\adodb.dll /// %PROGRAMFILES%\Common Files\System\Ole DB\OLEDB32.DLL /// </summary> /// <param name="currentConnectionString">Previous database connection string</param> /// <returns>Selected connection string</returns> private string PromptForConnectionString(string currentConnectionString) { MSDASC.DataLinks dataLinks = new MSDASC.DataLinksClass(); ADODB.Connection dialogConnection; string generatedConnectionString = string.Empty; if (currentConnectionString == String.Empty) { dialogConnection = (ADODB.Connection)dataLinks.PromptNew(); generatedConnectionString = dialogConnection.ConnectionString.ToString(); } else { dialogConnection = new ADODB.Connection(); dialogConnection.Provider = "SQLOLEDB.1"; ADODB.Property persistProperty = dialogConnection.Properties["Persist Security Info"]; persistProperty.Value = true; dialogConnection.ConnectionString = currentConnectionString; dataLinks = new MSDASC.DataLinks(); object objConn = dialogConnection; if (dataLinks.PromptEdit(ref objConn)) { generatedConnectionString = dialogConnection.ConnectionString.ToString(); } else { return currentConnectionString; } } generatedConnectionString = generatedConnectionString.Replace("Provider=SQLOLEDB.1;", string.Empty); if ( !generatedConnectionString.Contains("Integrated Security=SSPI") && !generatedConnectionString.Contains("Trusted_Connection=True") && !generatedConnectionString.Contains("Password="******"Pwd=") ) { if (dialogConnection.Properties["Password"] != null) generatedConnectionString += ";Password="******"Password"].Value; } return generatedConnectionString; }