Entry

Delphi: v8: Database: Microsoft SQL Server: Northwind: Connect: How to open Northwind database?

May 24th, 2004 15:36
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 24 May 2004 - 11:55 pm ------------------------

Delphi: v8: Database: Microsoft SQL Server: Northwind: Connect: How to 
open Northwind database?

---

Steps: Overview:

 1. -Make sure your (local) Microsoft SQL server is running
     (you should see the process 'sqlservr.exe' in your
      Microsoft task manager processes, otherwise start
      it via Microsoft SQL server Enterprise Manager->your
      SQL server->right click on it->choose 'connect')

 2. -Click on 'Data Explorer' pane
     (on the right side of your Delphi v8)

 3. -Right click on the '+' of MSSQL

 4. -Right click on MSSConn1

 5. -Select from list 'Modify connection'

 6. -That will open a window 'Connections Editor'

     1. -Fill in the fields:

        1. Database = northwind

           (I first tried to type the full path, but that gave 'login 
failed' errors)

        2. Hostname = (local)

           otherwise, if not local, usually <your sql server name>

        3. Name = MSSConn1 (can not be changed by you here)

        4. OSAuthentication = FALSE

        5. Password = <leave this blank>

                      (or <your password> when you changed this in the
                       Microsoft SQL server Enterprise
                       Manager->Security->Logins->double
                       click->'sa'->right click->Properties->change
                       your password)

        6. User name = sa
           (this is the default user name, in general any user name 
with access to
            this database)

        7. BlobSize 1024

        8. LoginPrompt = False

        9. QuoteObjects = False

       10. TransactionIsolation = ReadCommitted

       11. Assembly = 
Borland.Data.Mssql,Version=1.5.1.0,Culture=neutral,PublicKeyToken=91d62
ebb5b0d1b1b

       12. Provider = MSSQL (can not be changed by you here)

       13. VendorClient = sqloledb.dll (can not be changed by you here)

       14. Given this information, and given that Microsoft SQL server
           has been installed and its server is running successfully,
           if you then click the button 'Test' you should see:

            ['Connection successful']

           ---

           This worked successfully on Microsoft Windows XP
           Professional, using the Delphi v8 architect trial version.
           After that I could click on this connection in the data
           explorer, and see all the tables (e.g. 'Employees') inside
           this 'Northwind' database.

---
---

Internet: see also:

---

Delphi: v8: Database: Microsoft SQL Server: Northwind: Overview: Can 
you give an overview?
http://www.faqts.com/knowledge_base/view.phtml/aid/30029/fid/175

----------------------------------------------------------------------