Hello All,
I am now able to retrieve the data. The solution is quite simple. Powerbuilder required putting the table name in quotes for reasons best known to them.
e.g. pub.tablename should be pub."tablename"
Thanks for all the help so far
Hello marca,
Am going through excel menu
Data -> Import External Data -> Import Data ->New source -> ODBC DSN -> ODBC Data source/ Progress SQL 92 driver
Thanks
The client networking is an application that you have to install on your machine. It usually supplied with a driver that permits ODBC connection.
With a license am sure you would be able to download the client networking software from www.progress.com.
Hello All,
I would appreciate any response on this.
plus_marca i need your input once again.
I can retrieve data from a progress db thru ms access and crystal report 9.2.
However, in powerbuilder and ms excel I can only view the table structure and not retrieve the data.
Thanks in...
Hello marca,
I got a dba with admin rights to grant me access to the tables needed but I still get the same error.
Am using Progress 9.1D.
the security for each and every table to query is set to
Can-Read: *
Can-Write: *
Can-Create: *
Can-Delete: *
Can-Dump: *
Can-Load: *
the version...
Hello All,
Am getting this error when I try to access a progress database through power builder or crystal reports.
Error: Falied to open the rowset Details: HY000:[DataDirect - Technologies][DBC Progress driver][PROGRESS]Accesss denied(Authorisation failed)
However i can view the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.