hi guys! currently i have MS SQL server 2005 as my back-end/database but im planning to transfer from MS SQL 2005 to Oracle 10g. Can i have some advice on what to consider when changing database. Do I just need to change my connection string?
my current connection method:
Code:SqlConnStr = @"Data Source = " + txtSettingsDatasource.Text + "; Initial Catalog=" + txtSettingsDatabase.Text + "; User ID=" + txtSettingsLogin.Text + "; " + "Password=" + RndCrypt(txtSettingsPassword.Text, default_key); public bool db_connection() { try { sqlConn = new SqlConnection(SqlConnStr); sqlConn.Open(); return true; } catch (System.Data.SqlClient.SqlException ex) { //MessageBox.Show("DB CONNECTION ERROR: " + ex.Message + "\r\nPlease contact your administrator.","BCMD",MessageBoxButtons.OK,MessageBoxIcon.Error); show_error_message("db_connection", ex.Message); return false; } }




Reply With Quote