PocketBuilder 2.5.2 and SQL Anywhere 12

[Former Member]

Hi all,

I have a Windows Mobile device . It should run SQL Anywhere 12 with Pocket Builder 2.5.2. But at the start on the mobile device always get the message that the driver dbodbc10.dll missing . Where can I set that the driver of ASA 12 should be taken ? Or does this not work with ASA 12 .

Thanks for help.

André Rust

[CobyKako]

Hello Andre,

PocketBuilder 2.5.x is not supported and no longer sold anymore. Moreover, it has not been tested against ASA 12:

Software used for database connection

You might try what is explained below from link SyBooks Online (Archive)

Connecting to a SQL Anywhere database

By default, PocketBuilder runtime applications on the Windows CE device use
the PKODB25.DLL dynamic link library to connect to SQL Anywhere data
sources through the SQL Anywhere version 10 ODBC driver (dbodbc10.dll).
You can specify a different ODBC driver by including the
driver=dbodbcX.dll parameter in your DBPARM
ConnectString assignment or in the file data source, where X is
the version number of the ODBC driver for Adaptive Server Anywhere or SQL
Anywhere.

For example, to use the Adaptive Server Anywhere 9 ODBC driver on the Windows
CE device, you can use the following DBPARM:

SQLCA.DBPARM="ConnectString='DSN=myDSN;driver=dbodbc9.dll;UID=dba;PWD=sql'" 

CONNECT using SQLCA; 

SQLCA is the default connection object in all PocketBuilder environments.

In all runtime environments, the connect string for the DBPARM parameter must
not include spaces other than those in the data source name (DSN). The DSN you
assign must exist in the root directory on the Windows CE device or emulator.

When you install the complete PocketBuilder runtime package to the device or
emulator (rather than just the runtime DLLs), the ASA 9.0 Sample.DSN file
is added to the root directory. Instead of using the ConnectString DBPARM to set
the driver name, you can modify ASA 9.0 Sample.DSN, or any other DSN file
that you use, so that it includes an assignment for the database driver:

[ODBC] enginename=asademo databasename=asademo databasefile=\Program Files\Sybase\ASA\asademo.db start=\Program Files\Sybase\ASA\dbsrv9.exe Driver=dbodbc9.dll 

If you are using the ASA Sample database that is migrated to SQL Anywhere 10,
you can deploy the DemoDB_SA10.DSN file with your application. The
PocketBuilder setup program installs this DSN file in the PocketBuilder
Code Examples\SADemoData\SA10 directory. The DSN file sets the the
databse file to \Program Files\SQLAny10\ASADemo_10.db, and the driver
name to dbodbc.dll.

SQL Anywhere requires that DSN files be saved in ANSI format rather than
Unicode format.

If you are running your PocketBuilder applications from the desktop, it is
recommended that you use the actual name of the driver (for example, “Adaptive
Server Anywhere 9.0”) in a ConnectString DBPARM rather than the name of the DLL.
Otherwise, the driver you select in the connection string might be ignored.

HTH

Jacob