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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

We are witnesses that everyone is saying that our children shouldn't "play" with a technology because it is dangerous. This article is going to prove that they are wrong.
I don't pretend to be an expert at this, but I have found a few things that are useful. I hope that sharing them here will help others, so they will not have to face some rather hard choices. Since I felt this to be a topic of enough importance and…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month8 days, 14 hours left to enroll

764 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