Connecting to ASA Server (7.01 GA) via OLE
DB in PowerBuilder 8
Adaptive Server Anywhere includes an OLE
DB provider named ASAProv. One of the features of ASAProv (dboledb7.dll)
is that you do not have to deploy ODBC. In other words, you can connect
to an ASA database either via OLE DB or via OLE DB/ODBC bridge.
The steps to establish database connection to
ASA using OLE DB from PowerBuilder are as follows:
Start ASADEMO as a server by executing the following
line at the command prompt:
asademo -x tcpip -n asademo
("asademo" - your choice of database server name.
Make sure you do not have a similar named server running in your internal
network otherwise you will get error running the server)
There are two ways of connecting to an ASA server
via OLE DB
1) OLE DB/ODBC bridge
For this connection, you have to specify a valid
ODBC DataSource in your DBParm. Your connection script will look like this:
// Profile asa_oledb
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = "sql"
SQLCA.LogId = "dba"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='ASAProv',DATASOURCE='asa'"
2) OLE DB (do not have to deploy
You can access data from OLE DB by providing
connection information in a separate file with a .udl extension. This file
is referred to as the Microsoft DataLink (.udl) file. You need to have
the Datalink API installed on the system in order to create and use the
To create a data link (.udl) file from Windows
Explorer - Right-click within the right pane of an Explorer window or from
your desktop and select Microsoft Data Link from the New menu. A new data
link .udl file will be created in the current directory.
If you do not have the option to select Microsoft
Data Link in the New menu, then create a .txt file and rename it to a .udl
file. DoubleClick on the file, it will open the file with the options to
add the connection information.
For more information please check msdn.microsoft.com
and search for ?Datalink?
In Powerbuilder, when using the datalink file
(.udl), make sure that the Catalog Tables have already been created in
the database. To verify, you can connect to the database server using an
ODBC DataSource instead. If the tables don?t exist, you should get an error
indicating that Catalog Tables were not created.
Create an asademo.udl file with following info:
Select "Adaptive Server Anywhere Provider"
Select radio button for ?Use a specific username and password?.
Type Username - dba
Password - sql
Select checkbox - Allow saving password
Click "Test Connection" to verify the connection.
If you are using the datalink file in PowerBuilder,
you cannot use userid and password from PB script or DB profile. You have
to save this information in the udl file itself (cr 239454).
In PB, the connection script will look like
= "OLE DB"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='ASAProv',DATALINK='C:\asaole.udl'"
You can also refer to TechDoc # 47903 - Connecting
to OLE DB Providers from PowerBuilder 7 and 8