Difference between revisions of "Settings:Application Global Database Location"
From WireCAD Online Help
Wirecadadmin (Talk | contribs) (Created page with "{{PageHeader |shortcut=set |perms=Administrator |level=All |desc=Settings related to the type and location of the Global Equipment Database.}} {{note|If your organization is ...") |
Wirecadadmin (Talk | contribs) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
|shortcut=set | |shortcut=set | ||
|perms=Administrator | |perms=Administrator | ||
| − | |level= | + | |level=PRO, ENT |
|desc=Settings related to the type and location of the Global Equipment Database.}} | |desc=Settings related to the type and location of the Global Equipment Database.}} | ||
| Line 11: | Line 11: | ||
[[File:Globaldbconnectionpanel.png|thumb|Project>Settings Dialog]] | [[File:Globaldbconnectionpanel.png|thumb|Project>Settings Dialog]] | ||
| + | |||
| + | ==Settings Explanation== | ||
| + | |||
| + | {| class="wikitable" style="background-color:#ffffcc;" cellpadding="10" cellspacing="0"; border="1"; width="100%" | ||
| + | |- | ||
| + | ! Setting !! Description | ||
| + | |- | ||
| + | | '''Database Type'''|| Sets the type of database. Choices are '''VISTA''' and '''SQL'''. For a discussion on choosing a database type click [[Selecting a Database|'''here...''']]<br> | ||
| + | For information on setting up your application click here. | ||
| + | |- | ||
| + | | '''VISTADB Location''' ||This is the path to your Shared Documents folder by default. You may share the database by placing on a network share and repointing this path.<br> | ||
| + | {{warning|Using a VISTADB on a network share is not a recommended practice. Consider switching to SQL databases if you need to share among multiple users.}} | ||
| + | |- | ||
| + | | '''Host and Instance Name''' || Set to the host name or IP address of the database server.<br> | ||
| + | {{note|You may or may not need the server instance name. If you cannot connect try removing the instance name}} | ||
| + | |- | ||
| + | | '''Use Windows Security''' || Use your windows user login<br> | ||
| + | {{note|While this works just fine for a local host if presents a number of maintenance issues for a multiuser installation. We recommend creating a single SQL login for all users to use. This is the least obtrusive approach.}} | ||
| + | |- | ||
| + | | '''User Name'''|| Set to your SQL user name. | ||
| + | |- | ||
| + | | '''Password'''||Set to your SQL password. | ||
| + | |- | ||
| + | | '''[Test Connection]'''||Test the connection and ownership of the WireCADGlobalEquipment database on your database server. | ||
| + | |} | ||
Latest revision as of 17:07, 28 December 2010
| Command Line Shortcut: set User Permissions Level: Administrator |
 Note: If your organization is using WireCAD Security your user will require Administrator privileges in order to edit Application level setting and some Project level settings.
|
Settings Explanation
| Setting | Description | |
|---|---|---|
| Database Type | Sets the type of database. Choices are VISTA and SQL. For a discussion on choosing a database type click here... For information on setting up your application click here. | |
| VISTADB Location | This is the path to your Shared Documents folder by default. You may share the database by placing on a network share and repointing this path.
| |
| Host and Instance Name | Set to the host name or IP address of the database server.
| |
| Use Windows Security | Use your windows user login
| |
| User Name | Set to your SQL user name. | |
| Password | Set to your SQL password. | |
| [Test Connection] | Test the connection and ownership of the WireCADGlobalEquipment database on your database server. |
