Connecting to Microsoft SQL Server. Tuc Goodwin. Introduction . We are going to discuss establishing an connection to a SQL Server Database. You will learn that there is an easy way and a hard way. Agenda. Overview – What do you have to know… Security Modes Database Interfaces
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
There are two types of modes:
A DSN is a registry entry (Machine DSN) or text file (File DSN) that contains information about a database and the SQL Server it resides on.
Control Panel -> Administrative Tools -> Data Sources (ODBC)
Start Menu -> Administrative Tools -> Data Sources (ODBC)
APP=Microsoft Open Database Connectivity
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=dalgoodwin3\dalgoodwin32000
Can you say “Connection string”