Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


How to Utilize MS Access table data in Powerbuilder?

Posted on 2003-02-20
Medium Priority
Last Modified: 2008-01-16
    I need to connect the Powerbuilder Enterprise 7.03 build 10135 to a Microsoft Access97 application's tables and be able to retrieve the data for use in Powerbuilder reports.
The Access97 application resides on a network server ( which I have connected to as a network drive ).
What I have:-  An ODBC connection ( which connects! ); however I get the message "Catalog tables could not be created and are not available for use".  This is reflected in the fact that I can look at the names of the
Access tables; however, when I click into one of them I get the message "Itemstatus table has no columns-possible invalid table format".
Presently I have to supply the Drive and name of the sac.mdb file [ as type Access Databases(*.mdb) when I connect ].
My odbc profile looks like this:-
//Profile PublicationsAccessDB
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=MSAccess97 Database;UID=administrator;PWD=',ConnectOption='SQL_OPT_TRACEFILE,C:Program Files\Sybase703\SQL.LOG'"
Basically, my question is in the title.  How do I connect to the Access tables in order to use their data in reports
through the Powerbuilder Datawindows??
Question by:DilBert

Accepted Solution

mansoor_a_khan earned 1125 total points
ID: 8287892
Try creating the powerbuilder repository table in the Access database first.


Author Comment

ID: 8342930
The repository tables were put into the Access database;
however I still cannot open the individual Access tables
to examine/update their data.  It did get rid of the
"Catalog tables not available for use" message though;  Thanks

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dropbox has a relatively new feature called Smart Sync.  This feature allows Dropbox Professional (not plus) and Dropbox Business (if enabled) users to store information in Dropbox WITHOUT storing any files on their computer.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question