Simplicty and flexibility!


How To Setup an ODBC Connection to a SQL Server Database





How To Setup an ODBC Connection to a SQL Server Database

The following Steps will explain how to setup an ODBC (Open Database Connectivity) Connection to a SQL Server Database.

Note: The used Operating system in the following steps is “XP” and the version of SQL server is “SQL Server 2005″.


1- Go to your “Control Panel”, double-click “Administrative Tools” and then double-click “Data Sources (ODBC)”;


2- In the “Data Sources Administrator” dialog box, select the “System DNS” tab. This lists all the ODBC connections. Click the “Add” button;


3- A list of drivers will be presented, scroll down until you find the driver for the database which is “SQL Server”, then click “Finish”;


4- The “Data Source SQL Server Setup” window appears, enter a Name for your ODBC connection (This can be any name you desire and will be used later) i.e. <SQL Data Source>, then enter a Description for the data source (this can be any descriptive information you want).


5- Then, enter the server name for the SQL Server, click on “NEXT”;


6- Click the appropriate radio button for your connection type;

If you access your SQL Server Database using your standard Windows login, keep the default option for “With Windows NT Authentication…”, otherwise, if you access your SQL Server Database using a SQL Server Login, click on the radio button option for “With SQL Server Authentication…” Then, you must enter your SQL Server Login ID and Password.


7- Once you finish, click on “Next”;


8- Click on the box for “Change Default Database To:”, then, in the drop-down menu, select your SQL Server database name. Then click on NEXT;


9- In the next window, keep the default options as they are, so do not make any changes and click on the “Finish” button;


10- In the “ODBC Microsoft SQL Server Setup” Window, click on the Test Data Source button to test connection;


11- If your connection setting is correct, you should see a message “TESTS COMPLETED SUCCESSFULLY.”, if the test failed, you will need to click the “BACK” buttons to determine which setting is wrong and then repeat the above steps.


See Also

On the forum about How To Setup an ODBC Connection to a SQL Server Database


Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32

Hi there,I am trying to use an external MySQL DB in dataease. I have successfully create the ODBC link and added the DB to dataease. I can also access the DB from dataease. Now, just for testing purposes, I am trying to create a simple report b...

Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17

no se pude exportar ahora archivos a pdf, ni a excel o otros cosa mala. en verdad creo que hace faltaen las versiones anteriores me funcionaba mas o menos bien.&nbsp;le hace falta a los aplicativos que se desarrollan en Dataeasegr...

Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11

Thanks. Anyway I'm trying to use this fuction but it seems to me that it doesn't work on 8.2. I tried also in a DQL.There's something wrong?<img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAA9IAAAJ3CAYAAAB4NWk3AAAAAXNSR0IArs4...

Product: . Written by Marco Marchesi 15/02/16 at 14:50:46


Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46

Thanks for the very good explanation!AS...

Product: . Written by afonso santos 28/10/19 at 00:50:14

I am pleased to see that the migration from Dos 4.53 is then sa 5.5 works. A really useful thing would be a compiler of SQL languages. Will you get there?Original Text:Mi compiaccio a vedere che la migrazione da Dos 4.53 รจ poi sa 5.5 funzio...

Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44

On the blog about How To Setup an ODBC Connection to a SQL Server Database