Delphi-Kylix
  Home arrow Delphi-Kylix arrow Page 3 - Creating Data Link (UDL) Files in Delphi
Dev Articles Forums 
ADO.NET  
Apache  
ASP  
ASP.NET  
C#  
C++  
ColdFusion  
COM/COM+  
Delphi-Kylix  
Design Usability  
Development Cycles  
DHTML  
Embedded Tools  
Flash  
Graphic Design  
HTML  
IIS  
Interviews  
Java  
JavaScript  
MySQL  
Oracle  
Photoshop  
PHP  
Reviews  
Ruby-on-Rails  
SQL  
SQL Server  
Style Sheets  
VB.Net  
Visual Basic  
Web Authoring  
Web Services  
Web Standards  
XML  
Mobile Linux 
App Generation ROI 
IBM® developerWorks 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
DELPHI-KYLIX

Creating Data Link (UDL) Files in Delphi
By: Danish Ahmed
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 4
    2007-08-06

    Table of Contents:
  • Creating Data Link (UDL) Files in Delphi
  • Section 1: Adding a new ODBC Data Source
  • Section 2: Connecting with SQL Server Drivers
  • Section 3: Creating Data Link files programmatically
  • Section 4: More undocumented routines in ADODB

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Creating Data Link (UDL) Files in Delphi - Section 2: Connecting with SQL Server Drivers


    (Page 3 of 5 )

    However, if you want to connect to the database with native drivers instead of ODBC drivers you can do so by selecting the Microsoft OLE DB Provider for SQL Server Drivers in the Provider tab of the Data Link Property dialog box. Click next; the connection tabsheet now asks you to enter the SQL Server name instead of DataSource Name. The drop-down box lists all the servers available on the network. Select the one you want to work with, and then chose the type of authentication the server should make. Enter the user name and password and check allow saving.

    Note: Any password you save will be stored as plain text and thus readable to anyone who has access to the file, so if you are concerned about security you might as well not save the password enter it every time you connect.

    [dlinkScreenShot1]

    Once the correct user credentials have been supplied you can select one from the list of available databases on the server as listed in the drop-down box or you can also specify an existing file by selecting "Attach a database file as a database name" option.


    [dlinkScreenShot2]

    Click on Test Connection to verify that the connection was successful. You can now use the Data Link file to connect to the database server.

    More Delphi-Kylix Articles
    More By Danish Ahmed


     

    DELPHI-KYLIX ARTICLES

    - Loading an XML Document into the DOM
    - Delphi Wrapper Classes and XML
    - Delphi and the DOM
    - Delphi and XML
    - Internet Access: Client Service
    - Finishing the Client for an Internet Access ...
    - The Client for an Internet Access Control Ap...
    - User Management for an Internet Access Contr...
    - Important Procedures for an Internet Access ...
    - Server Code for an Internet Access Control A...
    - Constructing the Interface for an Internet A...
    - Building a Server Application for an Interne...
    - Building an Internet Access Control Applicat...
    - Client Dataset: Working with Data Packets an...
    - Using the Client Dataset in an N-Tiered Appl...







    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 1 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek