Version: Pro 2003-2009
Subject: Setting up multi-user databases
Issue: I want two or more users to share the same EnergyCAP database across a small peer-to-peer network.
â€¢ An energy manager and an assistant want to share the same database. They each have a PC running Windows 2000, XP or Vista,Â and are connected together through a small 4-port hub. They are not connected to the school districtâ€™s LAN.
â€¢ A school district has three energy managers. They all share an office. They want to share one Energy CAP database and segregate the data by region (each energy manager has one specific region, and each site is assigned to one of the three regions.) Their three PCs are connected via a 4-port hub and are also connected to the districtâ€™s LAN, primarily for Internet access. They want the Energy CAP database to reside on one of their local PCs, not on the LAN server.
Itâ€™s very easy to share an Energy CAP database. No special version of EnergyCAP is needed. The standard version has full multi-simultaneous-user functionality.
1. Connect the PCs via a peer-to-peer hub, such as a Linksys 4-port hub. Cost can be under $50.
2. Decide which PC will host the database. You will need the full name of the host computer. You can obtain this via: Control Panel>System>Computer Name>Full Computer Name.
3. Install EnergyCAP on each PC.
4. Create the database on the host PC by selecting File-New Database in Energy CAP. NOTE: Associated database files are normally located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
5. Be sure that the database is running properly on the host PC.
6. On the remote PCs, run EnergyCAP. Go to File/Login to Server and in the SQL Server field enter the name of the host computer. (Example: Hewlett-my4v2yb)
7. In the Dataset field, enter the name of the host database. If you donâ€™t know the exact database name, run EnergyCAP on the host PC and look at the database name in the lower right status bar.
8. Verify that the remote PCs are properly logged in to the host database â€“ you should see the name of the host PC and the host database in the lower right status bar of each remote PC.
9. If a remote user ever wants to run an EnergyCAP database that resides on his/her own hard drive, the user must use File/Login to Server, then enter (local) as the SQL Server name in order to get back to his/her hard drive.
10. The above procedure is for a small peer-to-peer network through a local hub, but the process is much the same when the database resides on a server on the LAN. All you have to do in the remote userâ€™s EnergyCAP is to use File/Login to Server and identify the host server name. Once connected to that host server, you will have access to all EnergyCAP databases located on that server. (Note: In order for a database to be available to you, it must be â€œattachedâ€ to SQL. To be attached to SQL, it must be located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data. If it was moved there from another location or if it was ever detached, you must attach it by running Energy CAP on that server with user initials of SYS, then File/Attach Database. If the desired file is not shown in the pull-down when you run Attach Database, it must either be already attached or is not located in C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.)
by Administrator â€” last modified by Barry KroekerÂ 06/30/2009Â EnergyCAP Professional Rel. 2005 and newer