Code covered by the BSD License  

Highlights from
change system DSN to a difference MS Access Database

change system DSN to a difference MS Access Database

by

 

matlab script to change which ms access database (.mdb) is set as the Data Source Name (DSN)

setDBgui(varargin)
function varargout = setDBgui(varargin)
% SETDBGUI M-file for setDBgui.fig
%      SETDBGUI, by itself, creates a new SETDBGUI or raises the existing
%      singleton*.
%
%      H = SETDBGUI returns the handle to a new SETDBGUI or the handle to
%      the existing singleton*.
%
%      SETDBGUI('CALLBACK',hObject,eventData,handles,...) calls the local
%      function named CALLBACK in SETDBGUI.M with the given input arguments.
%
%      SETDBGUI('Property','Value',...) creates a new SETDBGUI or raises the
%      existing singleton*.  Starting from the left, property value pairs are
%      applied to the GUI before setDBgui_OpeningFcn gets called.  An
%      unrecognized property name or invalid value makes property application
%      stop.  All inputs are passed to setDBgui_OpeningFcn via varargin.
%
%      *See GUI Options on GUIDE's Tools menu.  Choose "GUI allows only one
%      instance to run (singleton)".
%
% See also: GUIDE, GUIDATA, GUIHANDLES

% Edit the above text to modify the response to help setDBgui

% Last Modified by GUIDE v2.5 13-Nov-2012 08:32:49

% Begin initialization code - DO NOT EDIT
gui_Singleton = 1;
gui_State = struct('gui_Name',       mfilename, ...
    'gui_Singleton',  gui_Singleton, ...
    'gui_OpeningFcn', @setDBgui_OpeningFcn, ...
    'gui_OutputFcn',  @setDBgui_OutputFcn, ...
    'gui_LayoutFcn',  [] , ...
    'gui_Callback',   []);
if nargin && ischar(varargin{1})
    gui_State.gui_Callback = str2func(varargin{1});
end

if nargout
    [varargout{1:nargout}] = gui_mainfcn(gui_State, varargin{:});
else
    gui_mainfcn(gui_State, varargin{:});
end
% End initialization code - DO NOT EDIT


% --- Executes just before setDBgui is made visible.
function setDBgui_OpeningFcn(hObject, eventdata, handles, varargin)
% This function has no output args, see OutputFcn.
% hObject    handle to figure
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)
% varargin   command line arguments to setDBgui (see VARARGIN)

% Choose default command line output for setDBgui
handles.output = hObject;

% Update handles structure
guidata(hObject, handles);

% UIWAIT makes setDBgui wait for user response (see UIRESUME)
% uiwait(handles.figure1);


% --- Outputs from this function are returned to the command line.
function varargout = setDBgui_OutputFcn(hObject, eventdata, handles)
% varargout  cell array for returning output args (see VARARGOUT);
% hObject    handle to figure
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

% Get default command line output from handles structure
varargout{1} = handles.output;


% --- Executes on button press in pushbutton1.
function pushbutton1_Callback(hObject, eventdata, handles)
% hObject    handle to pushbutton1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

clc;

%users selects database
[newDB,newDBpath] = uigetfile('*.mdb','Select Database','C:\aisGPSLADO\Database');

if newDB ~= 0
    
    %set new system DSN vai registry
    [status,result] = dos(['reg add HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\GPSLADOSERVER /v DBQ /d "',newDBpath,newDB,'" /f']);

    msgbox(result);

end

%database open, access, and close
conn = actxserver('ADODB.Connection');
conn.Open('DSN=GPSLADOSERVER');

h = findobj('tag','edit1');
set(h,'string',conn.DefaultDatabase);

conn.Close;

function edit1_Callback(hObject, eventdata, handles)
% hObject    handle to edit1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    structure with handles and user data (see GUIDATA)

% Hints: get(hObject,'String') returns contents of edit1 as text
%        str2double(get(hObject,'String')) returns contents of edit1 as a double


% --- Executes during object creation, after setting all properties.
function edit1_CreateFcn(hObject, eventdata, handles)
% hObject    handle to edit1 (see GCBO)
% eventdata  reserved - to be defined in a future version of MATLAB
% handles    empty - handles not created until after all CreateFcns called

% Hint: edit controls usually have a white background on Windows.
%       See ISPC and COMPUTER.
if ispc && isequal(get(hObject,'BackgroundColor'), get(0,'defaultUicontrolBackgroundColor'))
    set(hObject,'BackgroundColor','white');
end


Contact us