On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
   
 
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login


Tools
Table of Contents

Quick Bid - 15.03.02 Connecting to a Microsoft SQL Database - QB

Views: 1278 Last Updated: 09/17/2024 09:53 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

To connect to any SQL database:

Right-click anywhere in the Bids Tab and select Open, or

Click the Open icon, the Open Database button looks like a manila folder with a curved arrow at the top on the Main toolbar, or

Click File > Open

The Open Databases dialog box opens

The Quick Bid Open Databases dialog box shows all databases you have previously opened

Click the "Find..." button - the Select Database Type dialog box opens:

Select Microsoft SQL in the database type pop-up

In the Open Databases dialog box select "Microsoft SQL Server" in the "Select Database Type" window.

This opens the "Connect to SQL Server" dialog box.

in the Connect to SQL Server dialog box, you tell Quick Bid where to find your SQL Server and your log in credentials

Type the name of the SQL Server in the SQL Server field (On Center Software is unable to provide this information - contact the SQL or Network Administrator for assistance).

Warning

It is important that all users sharing this database enter this Server Name exactly the same, especially if you are using On-Screen Takeoff and Quick Bid interactively (we recommend entering the Server name in all lower-case letters, for consistency).

When users enter the Server Name in different case, even one letter, the program sees that as a different connection and breaks the interactive link.

When using a "Named Instance" type in the name of the server followed by the instance, for example: "sqlserver\instance"

Select appropriate server authentication under "Connect using" (this also is determined by your SQL Server Administrator, please contact him or her with questions on how you should connect to the server)

  • Windows authentication passes the Windows login information to SQL
  • SQL Authentication requires a Login Name and Password provided by the SQL Server Administrator (recommended)

Click Connect - the program attempts to connect to the SQL Server, then displays all databases found on that server (until a database is opened, Quick Bid has no way of knowing if it is an OST/QB database until it attempts to open the database - so it is important that your Organization names its databases logically):

Quick Bid SQL Database Properties dialog box

Select a database to open and click OK

The database is now listed in the Open Databases dialog box with a check mark:

The Open Database dialog box shows SQL type databases a little differently than Access type databases

Click OK to close the Open Databases dialog box and return to the Bids Tab

All checked databases are displayed on the Bids Tab.

Note
SQL databases do not show a Date Modified or Size entry.

click here to view the previous article Finding an Access-type Database Creating a Microsoft Access Database click here to view the next article



Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! The information in this site is protected by copyright by ConstructConnect. You may not reproduce, adapt, or publish any content from this site in whole or in part for any purpose, without the express written consent of ConstructConnect, Inc.
Copyright 2024 - All Rights Reserved.