Difference between revisions of "MS SqlServer Notes"

From PeformIQ Upgrade
Jump to navigation Jump to search
Line 32: Line 32:


[[Category:Database]]
[[Category:Database]]
[[Category:ODBC]]

Revision as of 16:31, 2 May 2008

References

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...
     » Type: "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

Retrieved from "https://performiq.com/kb/index.php?title=MS_SqlServer_Notes&oldid=2048"