If starting the SQL instance does not resolve the issue, or the instance was not stopped to begin with, running an ODBC is the next step.
To run an ODBC on a 32 bit machine go to Control Panel> System and Security? Administrative Tools> ODBC.
To run an ODBC on an 64 bit machine got to the following file location, C:\Windows\SysWOW64 and select odbcad32.exe from the list. If extensions are hidden ensure the type is application
Double click on the Application, the following screen will be displayed. From here select 'Add'
Browse to the bottom of the list and select 'SQL Server' select 'Finish'
Type the following information
- Name: DRIVE
- Description: DRIVE
From the server option select the drop down arrow. This will list available SQL Server. Choose your server name. This is the same name that display when DRIVE advises you of a failed connection
When you have entered all the above information select 'Next'. If the connection fails as this point the most likely cause is that the server name is incorrect, or the server cannot be reached.
On the next screen choose Client Configuration.
From the left choose Named Pipes, then select OK
You will be brought back to the previous screen, select Next
Choose the default database.
1. Select 'Change the default database to:
2. From the drop down menu choose your database
3. Select Next.
Select 'Test Data Source'
The test should complete successfully, select OK.
Press OK on all screens until the ODBC has closed. You should now be able to login to DRIVE.
If the connection fails at any point check the server name and database name. These will be displayed on the DRIVE screen when a connection fails.
Alternatively if you are working in an office and other have access to the same database you are trying to connect to you can find these by going to DRIVE on another machine and selecting Tools>Change Database.
If you are still experiencing issues, please contact the support team at support@relate-software.com