1. Home
  2. Tips and tricks
  3. What do I do when my database does not connect?
  1. Home
  2. Settings
  3. What do I do when my database does not connect?

What do I do when my database does not connect?

Are you facing problems with the database connection?

 The first step is to verify the database type you are using. On G-Electrical, there are 3 available types: LocalDB, MDB e SQL Server.

LocalDB

 In case you database is LocalDB, you should check the folder address on the database connection pop up on G-Electrical. To check this out, launch G-Electrical > GE Manage > Database connection. Check if the database type is LocalDB. Then, check if the address points to the “dados” and “qccfg” folders.

Tip

The standard directory of those folders is %programdata% > QC > BASE > GE2018R1. Make sure this is the pointed address.


Info

On “Server”, still on LocalDB, will be GE + the version of your G-Electrical. Example: GE2018R1.

MDB

First of all, launch G-Electrical > Go to GE Manage > Database connection and check if the database type “MDB” is selected. Then, check if the address points to the “dados” and “qccfg” folders.

After this, check the compatibility of the office package. If your DraftSight is 64 bits, your office package shall be too. The same applies to 32 bits version. In case this incompatibility exists, you can check this article out to fix it.

Tip

To check to office package version out, launch a new document on word and go to: File > Account > Product information. To check the DraftSight (G-Electrical) version, type _ABOUT on the command window.

Warning

If your database opens, but there are some inconsistencies, it is possible that this base has already been modified by an SQL table. In this case, use the SQL base.

SQL server

If your database is a SQL Server type, begin checking if the computer running the G-Electrical is communicating with the computer of the SQL instance (server).

Tip

To check this out, launch the cmd and type ping (SQL computer´s IP address). To find out the IP Address of the SQL computer, open the cmd on this computer and type: ipconfig /all and seek for the “IPv4” information.

If the computers are communicating with each other, launch G-Electrical, go to GE Manage > Database connection and check if the database type “SQL Server” is selected and if the settings are equal to the ones on SQL Management Studio.

Tip

The required password is the same as the one created and used to connect with the SQL Server instance. Check out if the pointed address of the “dados” and “qccfg” folders are accurate.


Info

Usually, this directory with the dados and qccfg folders are located somewhere on a mapped directory on the own SQL Management Studio Server.

In case all the information is right, launch the SQL Management Studio with the G-Electrical database and check out if the instance is running. If it is, it will appear as shown below.
img1

Tip

The standard logon is “sa”.

Click to expande the “database”, then click to expand the content of the reffered database. Check if there are any content inside this folder.

Check if it was connected with the SQL Server authentication. If not, give it a try and restart the instance.

In case it is not running, fill in the server information and click on connect.

img2

Warning

If the instance did not connect, it is possible that it is stopped, or with the pipes disabled. To check this out. Open the files explorer (windows + e) > Local drive (C:) > Windows > SysWOW64 and type: SQLServerManager12img3

Info

If you are using the SQL Management Studio 2008 version, open te SQLServerManager10.

Launch the app.

On SQL Server services, check if the SQL instance are running. Case not, right click it and start it. If the start option is not available, right click it > properties > Services > Inicial mode: Automatic. The, restart the instance.

Besides this, we could go to “SQL Server Network settings”. in (Instance Name) protocols, check if all the 3 protocols are enabled. Case not, enable them all and then restart the instance.

Tip

Also check if the SQL Browser is running. If not, perform the same procedures as before.

After that, launch SQL Management Studio again and try to connect to the instance. Then, try to connect to the database on G-Electrical.

Was this article helpful?

Related Articles

Add A Comment