You want
your application to reference connection information that is stored
in a Microsoft Data Link (.udl) file. The .udl file is a special text
file that can be used in conjunction with ADO and the Visual Basic
DataEnvironment tool in order to initialize an ADO Connection object.
(This connection method is similar to the method that is provided
for ODBC by the ODBC Administrator.)
Note: DataEnvironment
is a Visual Basic 6 GUI tool that can be used to manage static connections
to known data sources. To add it to your project, select
ProjectAdd Data Environment.
This recipe
applies to all the SAS providers. This recipe applies only to ADO.
Sample code is included.
Note: To use the
sample code, you must reference the Microsoft ActiveX Data Objects
Library in your Visual Basic project.