Home arrow Delphi-Kylix arrow Page 3 - Creating Data Link (UDL) Files in Delphi
DELPHI-KYLIX

Creating Data Link (UDL) Files in Delphi


The connection string required to connect to a database server may be created during design time or run time. There are circumstances under which you may want to store the connection string entirely outside the application, however. In those instances, Microsoft Data Link files are useful, as this article will explain.

Author Info:
By: Danish Ahmed
Rating: 5 stars5 stars5 stars5 stars5 stars / 8
August 06, 2007
TABLE OF CONTENTS:
  1. · Creating Data Link (UDL) Files in Delphi
  2. · Section 1: Adding a new ODBC Data Source
  3. · Section 2: Connecting with SQL Server Drivers
  4. · Section 3: Creating Data Link files programmatically
  5. · Section 4: More undocumented routines in ADODB

print this article
SEARCH DEVARTICLES

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.


blog comments powered by Disqus
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...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 
Support 

Developer Shed Affiliates

 




© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials