| |
| Publicado el 23,julio 2015 - 09:46 |
Hello,
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 Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,julio 2015 - 10:25 |
| Hi, 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 out how to use HFSQL from C++ ? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,julio 2015 - 12:50 |
Yes Guenter, I installed OLE DB driver for HFSQL. That's why I could use it with Excel successfully.
Powerbuilder is not C++, but it could generate C code, if required, on compilation. It's different.
I read all examples given in online help. Tried combinations that came to my mind. Still, couldn't get it working successfully. Not sure whether we can add new OLE DB drivers with Powerbuilder.
I think few powerbuilder developers are also using Windev, who could help me.
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,julio 2015 - 14:11 |
Hi
I have no experience with powerbuilder, but there are some things that you should be able to do:
-1-
- create a webservice in windev. This webservice will know how to access HFSQL
- call the webservice from the legacy powerbuilder app
-2-
- Create a .net assembly in windev to access your data
- use the .net assembly in powerbuilder
-3-
- Create an awp page in webdev to access the data
- from powerbuilder, do httprequest to compunicate with it
One (or several) of these solutions should work for you
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,julio 2015 - 09:34 |
Hello Guenter.
Could you tell me where to enter password for file(s) in ODBC Connection or link with that details ? I couldn't get it in the online documentation.
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,julio 2015 - 10:19 |
Hello,
I got the following information from online documentation
//
The ODBC driver on HFSQL cannot be used to access an encrypted HyperFileSQL database.
//
Whether this applies to password protected files also ?
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,julio 2015 - 13:09 |
Hi
Give it a try as below:
DBParm="PROVIDER='PCSOFT.HFSQL';DATASOURCE='Server:4900';User ID=admin;Password='';Initial Catalog=Acc_HFCS
try not setting any password in server and it looks like the PB translation/syntax issue vs Excel and why Excel works because it's been tested by pcSoft with example.
HTH
Cheers
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,julio 2015 - 14:03 |
No luck King.
Anything which I try with OLE DB / HyperfileSQL / Powerbuilder makes the application to crash. Trying to connect the db from Powerbuilder IDE itself makes the PB IDE to crash.
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,julio 2015 - 14:05 |
Hello,
Yes, I could connect to HFCS db via ODBC from Powerbuilder. The only limitation is files (tables) should not have password. Or I don't know how to open a file that's password protected from powerbuilder.
Any clues ?
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,julio 2015 - 14:33 |
Hi
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 created in project and it's expensive vs WX20.
It's hard to use without wx product when using hfSql as it's not like oracle, sqlServer...
Dataflex was good in 1990 but...
ps. using ODBC is far better than OLEDB in hqSql or native is the best and m/s
is not going to support it in future, I guess.
Cheers
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 25,julio 2015 - 08:01 |
Hello King,
I'll try using ODBC, as I could connect password less HFCS files from powerbuilder. Since you say it's better than OLE DB and ms also planning to go in that way and that's the only option so far successful, I'll be going that way.
Thanks for your time and suggestion. I'll know again, if necessary. ha ha
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |