Page 1 of 1

out of topic Accessing DBFCDX files

Posted: Mon May 11, 2009 6:41 pm
by SylRob
Good afternoon everyone,

My question is not really related to FWH nor Harbour / Xharbour ! :)

I'm an old timer user of Fivewin and Xharbour, Now I'm working on a completely different plateform.

I need to acces and maintain DBFCDX of an application written in Xharbour. Just want to know wich approach I can use, I tried Advantage database server with Arc32.EXE that created my dictionnary to maintain the DBFCDX while I'm using SQL command and it worked as expected, but I have a lot of problem to reach the sales department of Sybase to buy a server license I can't use ADS LOCAL server because I can't give acces to the directory where the database are.

I can use OCX, OLEDB, ADO technologie

Any suggestion ?

BTW: To all my old friends here I say HELLO and hope that thing's are going pretty well for you guys ! :)

Best Regards,

Sylvain Robert

Re: out of topic Accessing DBFCDX files

Posted: Mon May 11, 2009 8:49 pm
by Enrico Maria Giordano
Hi Sylvain, glad to read you again!

EMG

Re: out of topic Accessing DBFCDX files

Posted: Tue May 12, 2009 4:17 am
by codemaker
Hi Sylvain,
really glad to hear you're ok, up and runing :)

Boris

Re: out of topic Accessing DBFCDX files

Posted: Tue May 12, 2009 4:33 am
by nageswaragunupudi
I understand you like to hide the tables and folders from the user.
If possible, working with ADS server is the best way.
Even otherwise we can open and work with hidden folders and tables even with DBFCDX. This does not prevent authorised users from viewing hidden folders and hidden tables. You can still use some tricks to hide them away and keep prying eyes keep guessing where they are.

ADO ( OLEDB ) works with DBF tables also. We can use native windows drivers or visual foxpro drivers. But accessing DBF tables through ADO is slower and functionality is limited than working directly with RDD. Even then we gain no additional advantage as to hiding of the tables.

I understand there are other client server utilties available for DBFs. I dont have experience with them.

Re: out of topic Accessing DBFCDX files

Posted: Tue May 12, 2009 9:34 am
by SylRob
Boris, Enrico

Hey hello guys it was also a pleasure for me to read you ! . Nice to see what Antonio did and do with Fivewin, I'm really missing all the flexibility of Harbour/Xharbour and Fivewin !

G.N naro,
I already test PURE Oldeb for Visual foxpro and it don't maintain CDX correctly, because the software that I have to maintain are CDX but not production index so I have to open it separately, I tested MSSQL Linked server yesterday and it's a NOGO, SO I'll try to reach Sybase for a lincesed server for ADS, I hope they want to sell it ! :)

Best Regards to ALL and I wish you all the best with the wonderful Harbour/Xharbour FWH environnment you are lucky guys ! :wink:

BTW AdoRDD will be a HUGUE step for the Xbase world congratulation Antonio !

Best Regards,

Sylvain Robert

Re: out of topic Accessing DBFCDX files

Posted: Tue May 12, 2009 10:28 am
by nageswaragunupudi
>
SO I'll try to reach Sybase for a lincesed server for ADS, I hope they want to sell it !
>
I don't think you should have problems in purchasing it. 5 user version costs around $650. For developers it may work out better to become advantage partner at $750

Re: out of topic Accessing DBFCDX files

Posted: Tue May 12, 2009 10:31 am
by Otto
Hello NagesWaraRao,

>You can still use some tricks to hide them away and keep prying eyes keep guessing where they are.
Would you be so kind to share some tricks?
Thanks in advance
Otto