# 3G Guide - ODBC Setup

1. First we need to Access the ODBC COntrol Panel - On Windows XP for example you head off to Control Panel, Administrative Tools, Data Source (ODBC)

2. Select SYSTEM DSN (it is required for them to be in SYSTEM not any other or it all won't work). Now lets click ADD and the next screen comes up:

3. Scroll down to the Bottom and click SQL Server

5. Now to fill in these Boxes:

> A. Name : Same name as Database (see SQL section for names) such as Account etc.

> B. Description: Anything you want in here, not required

> C. Server: Drop down the box to find your Server, should come up as Local if same machine.

6. Click NEXT and the AUTH Box will come up:

Now at this point you can either pick Windows Aith Mode (if your Logged in with Admin Rights) or you can select SQL Server auth and put in your SA and PASSWORD you picked when Installing the Server.

7. The next screen, you drop down the "Change Default Database" to the same Database as the ODBC name, in this case Account. If it does not present the list of Databases names such as Account etc, then you have not done the step to Restore the Databases.

8. Click you way through the screen, test Connection if Required and repeat this process for Each ODBC that is required:

Account

ConLog

CruelDragon3GbaseData

Game3G

Hero3G

Manage

9. This concludes our Part on setting up ODBC.