MS SqlServer Notes

References

• http://www.databasejournal.com/features/mssql/article.php/3489661
• Get Started with Microsoft JDBC

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

Select the Driver

Specify names

Setup Authentication

Specify Default DB

Finish

Test

Done