How to Utilize MS Access table data in Powerbuilder?
Posted on 2003-02-20
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:-
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??