|
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:
dbsrv7 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 ODBC)
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 .udl
files.
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
揇atalink?/tt>
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抰
exist, you should get an error indicating that Catalog Tables were
not created.
Create
an asademo.udl file with following info:
Provider Tab:
Select "Adaptive Server Anywhere Provider"
Connection Tab:
Location: eng=asademo;dbn=asademo;Links=TCPIP{};
Select radio button for 慤se
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 this:
// Profile asa_oledb
SQLCA.DBMS = "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
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:
dbsrv7 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 ODBC)
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 .udl files.
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
揇atalink?/tt>
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抰
exist, you should get an error indicating that Catalog Tables were
not created.
Create an asademo.udl file with following info:
Provider Tab:
Select "Adaptive Server Anywhere Provider"
Connection Tab:
Location: eng=asademo;dbn=asademo;Links=TCPIP{};
Select radio button for 慤se
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
this:
// Profile asa_oledb
SQLCA.DBMS = "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
|