Setting up ODBC: Difference between revisions
Luke.nuttall (talk | contribs) No edit summary |
No edit summary |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<ul> | |||
<li>DSN Setup Tool</li> | |||
<ul> | |||
<li>Open Control Panel -> Administrative Tools -> Data Sources (ODBC) <br><br></li> | |||
<li>In a 64 bit environment Open C:\Windows\SysWOW64\odbcad32.exe (ODBC) <br><br></li> | |||
</ul> | |||
<li>Select the “System DSN” tab. [[Image:systemDSN.png|centre|frame]]<br></li> | |||
<li>Click ‘Add…’ for a new DSN.<br><br></li> | |||
<li>Select DSN as an “SQL Server”. A window to ‘Create a New Data Source to SQL Server’ will appear. Choose the ‘Name:’ of the database added in Enterprise manager. (i.e. QESTLab_AUBOR) and enter in ‘Server:’ “(local)”. Note the DSN name has to match the name in the Enterprise manager. [[Image:newDataSourceAsSQL.png|frame|centre]]<br></li> | |||
<li>Click next -> next<br><br></li> | |||
<li>Change the default database to the newly added database. (i.e. QESTLab_AUBOR). [[Image:newDataSourceAsSQL2.png|frame|centre]]<br></li> | |||
<li>Click ‘Next’ and ‘Finish’ on the following screen. | |||
[[Category:Internal|{{PAGENAME}}]] | |||
[[Category:SQL|{{PAGENAME}}]] | |||
</li> | |||
</ul> | |||
Latest revision as of 03:27, 25 March 2014
- DSN Setup Tool
- Open Control Panel -> Administrative Tools -> Data Sources (ODBC)
- In a 64 bit environment Open C:\Windows\SysWOW64\odbcad32.exe (ODBC)
- Select the “System DSN” tab.
- Click ‘Add…’ for a new DSN.
- Select DSN as an “SQL Server”. A window to ‘Create a New Data Source to SQL Server’ will appear. Choose the ‘Name:’ of the database added in Enterprise manager. (i.e. QESTLab_AUBOR) and enter in ‘Server:’ “(local)”. Note the DSN name has to match the name in the Enterprise manager.
- Click next -> next
- Change the default database to the newly added database. (i.e. QESTLab_AUBOR).
- Click ‘Next’ and ‘Finish’ on the following screen.
