To specify AIS Server as the provider through ADO, use the Open method of the Connection object. You can connect to AIS Server as the provider using a Microsoft UDL, as follows:

connection.Open "file name=UDL_filename"

where UDL_filename is the full path of the UDL file.
Alternatively, you can use the following format:
connection.Open "provider=AttunityConnect
[;parameter=value[;parameter=value]...]"


The following connect string connects to AIS Server via a UDL:
connection.Open "file name=c:\provider.udl"

The following connect string specifies AIS Server as the data provider and uses all the AIS Server defaults (such as the location of binding information and the default user profile):
connection.Open "provider=AttunityConnect"

The following connect string additionally specifies both the binding and the user profile:
connection.Open "provider=AttunityConnect;
binding=production;
User ID=QAsmith;password=asdfaa"