Difference between revisions of "MS SqlServer Notes"
Jump to navigation
Jump to search
PeterHarding (talk | contribs) |
PeterHarding (talk | contribs) |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
* http://www.databasejournal.com/features/mssql/article.php/3489661 | * http://www.databasejournal.com/features/mssql/article.php/3489661 | ||
* [http://support.microsoft.com/kb/313100 Get Started with Microsoft JDBC] | * [http://support.microsoft.com/kb/313100 Get Started with Microsoft JDBC] | ||
=Products= | |||
* http://www.sqlsentry.net/ | |||
=Connection Strings= | |||
* http://www.connectionstrings.com/Articles/Show/all-sql-server-connection-string-keywords | |||
=Setting up ODBC Connection under Windows= | =Setting up ODBC Connection under Windows= | ||
| Line 8: | Line 16: | ||
The program you need for this is odbcad32 which is contained in the control panel. You can run it directly with the following commands: | The program you need for this is odbcad32 which is contained in the control panel. You can run it directly with the following commands: | ||
Start | <Start> | ||
» Run | » <Run> | ||
» | » odbcad32 | ||
===ODBC Datasource Administration Tabbed Pane=== | |||
[[Image:ODBC_Drivers_Tab.gif]] | [[Image:ODBC_Drivers_Tab.gif]] | ||
===Select the Driver=== | |||
[[Image:ODBC_Create_DS_01_Select_Driver.gif]] | [[Image:ODBC_Create_DS_01_Select_Driver.gif]] | ||
===Specify names=== | |||
[[Image:ODBC_Create_DS_02_Names.gif]] | [[Image:ODBC_Create_DS_02_Names.gif]] | ||
===Setup Authentication=== | |||
[[Image:ODBC_Create_DS_03_Authentication.gif]] | [[Image:ODBC_Create_DS_03_Authentication.gif]] | ||
===Specify Default DB=== | |||
[[Image:ODBC_Create_DS_04_Specify_DB.gif]] | [[Image:ODBC_Create_DS_04_Specify_DB.gif]] | ||
===Finish=== | |||
[[Image:ODBC_Create_DS_05_Finish.gif]] | [[Image:ODBC_Create_DS_05_Finish.gif]] | ||
===Test=== | |||
[[Image:ODBC_Create_DS_06_Test.gif]] | [[Image:ODBC_Create_DS_06_Test.gif]] | ||
===Done=== | |||
[[Image:ODBC_Create_DS_07_OK.gif]] | [[Image:ODBC_Create_DS_07_OK.gif]] | ||
[[Category:Database]] | [[Category:Database]] | ||
[[Category:ODBC]] | |||
Latest revision as of 09:06, 13 March 2013
References
Products
Connection Strings
Setting up ODBC Connection under Windows
The program you need for this is odbcad32 which is contained in the control panel. You can run it directly with the following commands:
<Start>
» <Run>
» odbcad32
ODBC Datasource Administration Tabbed Pane
Select the Driver
Specify names
Setup Authentication
Specify Default DB
Finish
Test
Done
