What todo I do when my database does not connect?
The first step is to verify the database type you are using. OnG-Electrical, there are 3 available types: LocalDB, MDB e SQL Server.
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 > 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.
TIP:On “Server”, still on LocalDB, will be GE + the version of your G-Electrical. Example: GE2018R1.
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 on 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.
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.
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: Ifthe 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: Ifyou 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. Case not,right click it and start it. If the start option is not available,right click it > properties > Services > Initial mode:Automatic. The, 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. 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.