Table of Contents

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

Views: 730 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.

Finding an Access-type Database

Creating a Microsoft Access Database