Search results

You are welcome to the forum

You probably need to enclose the table name in quotes e.g. select * from pub."customer" ; Cheers

good to know. you always welcome when help is needed

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...

Thanks, I would work on this new response.

Hi, am back again. The admin guy did not use the data dictionary.

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...

I would advise you utilize this driver MERANT 3.60 32 Bit Progress SQL92 v9.1D

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...