What to do when my database does not connect?
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 onthe database connection pop up on G-Electrical. To check this out, launch G-Electrical, from G-Electrical Ribbon > GE Manage > Connection with Database... 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 > GE2020R1. Make sure this is the pointed address.
💡TIP: On “Server”, still on LocalDB, will be GE + the version of your G-Electrical. Example: GE2020R1.
MDB
First of all, launch G-Electrical > Go to GE Manage > Connection with Database... 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.
💡TIP: To check 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, then Enter.
⚠️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.
SQLserver
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 > Connection with Database... 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.
💡TIP: The standard logon is “sa”.
Click to expand 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.
⚠️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 andtype: SQLServerManager12
📖Info: If you are using the SQL Management Studio 2008 version, open the SQLServerManager10
Launch the app.
On SQL Server services, check if the SQL instance are running. If not, right click and start it. If the start option is not available, right click > properties > Services > Initial mode: Automatic. Then, restart the instance.
Adding to this, we could go to “SQL Server Network settings”. in (InstanceName) protocols, check if all the 3 protocols are enabled. If 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.