Difference between revisions of "MS SqlServer Notes"

From PeformIQ Upgrade
Jump to navigation Jump to search
(New page: =References= * http://www.databasejournal.com/features/mssql/article.php/3489661 Category:Databases)
 
 
(11 intermediate revisions by the same user not shown)
Line 2: Line 2:


* 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]


[[Category:Databases]]
=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=
 
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===
 
[[Image:ODBC_Drivers_Tab.gif]]
 
===Select the Driver===
[[Image:ODBC_Create_DS_01_Select_Driver.gif]]
===Specify names===
[[Image:ODBC_Create_DS_02_Names.gif]]
===Setup Authentication===
[[Image:ODBC_Create_DS_03_Authentication.gif]]
===Specify Default DB===
[[Image:ODBC_Create_DS_04_Specify_DB.gif]]
===Finish===
[[Image:ODBC_Create_DS_05_Finish.gif]]
===Test===
[[Image:ODBC_Create_DS_06_Test.gif]]
===Done===
[[Image:ODBC_Create_DS_07_OK.gif]]
 
[[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

ODBC Drivers Tab.gif

Select the Driver

ODBC Create DS 01 Select Driver.gif

Specify names

ODBC Create DS 02 Names.gif

Setup Authentication

ODBC Create DS 03 Authentication.gif

Specify Default DB

ODBC Create DS 04 Specify DB.gif

Finish

ODBC Create DS 05 Finish.gif

Test

ODBC Create DS 06 Test.gif

Done

ODBC Create DS 07 OK.gif