pcsoft.us.windevCopyright 2026, PC SOFT25 Jul 2015 08:01:00 Z23 Jul 2015 09:46:00 ZHello, Is it possible to access HFCS from Powerbuilder using OLE DB (any other way) ? I tried with the following parameters. DBMS="OLEDB" UserId=admin ServerName=webmobile AUTOCOMMIT=True Lock="RC" DBParm="PROVIDER=PCSOFT.HFSQL;DATASOURCE=Server;User ID=admin;Password='***';Initial Catalog=Acc_HFCS;Extended Properties="Password=*:Secret"; But I get No OLE DB provider name was specified in the connection parameter I tried to connect this db from Excel (as per documents) it works. I feel some settings need to be done, which I'm missing...... Any help is really appreciated. Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53260/read.awp25 Jul 2015 08:01:00 ZHello King, I'll try using ODBC, as I could connect password less HFCS files from powerbuilder. Since you say it's better tha…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53260/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53260/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53253/read.awp24 Jul 2015 14:33:00 ZHi Hmm, not much help from me as I used PB in 1997 and it crashed all the time esp. when thousands of sp/data windows create…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53253/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53253/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53250/read.awp24 Jul 2015 14:05:00 ZHello, Yes, I could connect to HFCS db via ODBC from Powerbuilder. The only limitation is files (tables) should not have pass…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53250/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53250/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53249/read.awp24 Jul 2015 14:03:00 ZNo luck King. Anything which I try with OLE DB / HyperfileSQL / Powerbuilder makes the application to crash. Trying to connec…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53249/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53249/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53244/read.awp24 Jul 2015 13:09:00 ZHi Give it a try as below: DBParm="PROVIDER='PCSOFT.HFSQL';DATASOURCE='Server:4900';User ID=admin;Password='';Initial Ca…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53244/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53244/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53234/read.awp24 Jul 2015 10:19:00 ZHello, I got the following information from online documentation // The ODBC driver on HFSQL cannot be used to access an …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53234/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53234/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53231/read.awp24 Jul 2015 09:34:00 ZHello Guenter. Could you tell me where to enter password for file(s) in ODBC Connection or link with that details ? I couldn'…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53231/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53231/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53210/read.awp23 Jul 2015 14:11:00 ZHi I have no experience with powerbuilder, but there are some things that you should be able to do: -1- - create a webser…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53210/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53210/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53206/read.awp23 Jul 2015 12:50:00 ZYes Guenter, I installed OLE DB driver for HFSQL. That's why I could use it with Excel successfully. Powerbuilder is not C++,…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53206/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53206/read.awpRe: Accessing HFCS from Powerbuilderguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53203/read.awp23 Jul 2015 10:25:00 ZHi, did you install the OLE DB driver for HFSQL? Did you try ODBC? Powerbuilder is C++, right? Why not look into Wx-Help to find…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53203/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53202-accessing-hfcs-from-powerbuilder-53203/read.awpRe: Accessing HFCS from Powerbuilder