The database will then be copied - wait for the process to complete: You will then be prompted to enter administrator credentials for the database server. ![]() Select the database you wish to copy from the list of databases, then click Copy Database.Įnter the name for the copy of the database and click OK. Note: Only databases you have permission to connect to will be shown in the list.Īlternatively, you can copy an existing database, or create a new database: If the database to use already exists, choose it from the list. If Instrument Manager cannot do this automatically (ie, the selected server does not allow Windows Authentication, or your Windows account doesn't have permission to access the server), you will be prompted to login using standard SQL Server Authentication (username and password). Instrument Manager first tries to connect to SQL Servers using Windows Authentication (also known as "Integrated Security"), using the windows credentials of the currently logged in user. ![]() If you do not have SQL Express installed then connecting to that server entry will fail.Ĭlick the button and the databases on the chosen server will be displayed in the list. This is done because SQL Server Express is not found by the search function. Alternatively enter the server name in the box.Īn entry for SQL Server Express will be forcibly added to the list regardless of whether you have SQL Server Express installed. The Project Wizard window will be displayed.Ĭlick the button to configure the project to use an SQL server database.Ĭlick the button to load a list of available servers (this may take considerable time). This procedure is used to create a new Instrument Manager Project with a project database on an SQL Server.įrom the "File" menu, select "Create/Open Project". See the First Run section below for details. You will now be asked if you wish to enable username and password access to the new project. See Database Template in the Instrument Manager customisation guide for more information. You may create your own project database templates. EDS ships with one default template (for Access 2000 and higher): When creating a new database, a template needs to be specified. If the database to use already exists, choose it from the list otherwise enter the name of a new database to create. This will display the database configuration page:Ĭlick the button to configure the project to use an Access database. Select an existing EDS project that has no Instrument Manager database associated with it, or enter the name of a new EDS project to create.Ĭlick the button. ![]() The Project Wizard window will be displayed:Ĭlick the button to specify the project file. This procedure is used to create a new Instrument Manager Project with a project database in Microsoft Access format.įrom the "File" menu, select "Create/Open Project". Instrument Manager creates the data source file when you first open or create a project by copying a template DSN file from the folder "\ODBC\Data sources". This entry retains Instrument Manager's link to the project database. The "DSN" file for a project database is listed in the Ebase project along with any drawings that are also part of the project. This data source file will have the same name as the project database to which it is supposed to connect. ![]() For Instrument Manager this is a file with the extension ".DSN", usually called a "File DSN". ODBC Data Source: ".DSN" FileĪn "ODBC Data Source" is used to connect to the project database. Since the project database is the central storage of all of the data, it is possible to share or copy an entire Instrument Manager project by sharing or copying the database file. The Instrument Manager specific data is stored in this project database, which can be either a Microsoft Access database or SQL Server database. This will be referred to as the "project database". Each project can contain only one Instrument Manager database. Projects created by Instrument Manager are the same as the EDS projects used by Elecdes. Create a new Instrument Manager project and database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |