BorlandTalk.com

Doug Schmidt · Guest

Hi all. I have a Paradox 7 DB on a windows 2000 network server and an
application written in BCB 6 talking to it through the BDE with 15
users. A VB.Net contract programmer needs read/write access to the
Paradox DB.
Now the political battle that is ensuing aside, how can I make this
happen? I would like to hear all suggestions plus I will need to
provide some pros and cons.
For example:
Convert to SQL Server, but you will have to rewrite your TTable and TSql
to use ADO objects or buy the BDE SQL access components and buy SQL
server and all the seat licenses that goes along with that.

Revert the Paradox DB to version 5 but these are your problems... ( I
am really looking for some backup here why not to do this.)

Thanks in advance. Doug.

Phil Robertson · Guest

Doug,

I'm not exactly sure what your looking for but a Paradox database can be
opened from VB as easily as from Builder.
Here is a link to Microsoft which details how;
http://support.microsoft.com/default.aspx?scid=kb;en-us;217213

Here's another link to general Paradox config info
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetparadoxsqlconfigdatasource.asp

As far as whether its advisable to have a VB program and a Builder program
accessing the data I see no problems with this. The Paradox lock file should
be able to control database access. I am not aware of any access differences
between Paradox 5 and Paradox 7 so I'm not sure why you feel reverting would
change anything.
The differences between the two are:
============================================================================
=========================================
The Paradox 7 table format was introduced in Paradox version 7 for Windows
95/NT. The Paradox 7 table format has all the same specifications as the
Paradox 5 table format with two additions. Following are the specification
additions for the Paradox 7 table format.

a.. Added descending secondary indexes.

b.. Added unique secondary indexes
Prestwood Software. (2003). Paradox 7 and above Table Specifications. From:
http://www.prestwood.com/community/database/info/paradox_spec.asp
============================================================================
=========================================
The real question is what the contract programmer is planning to do with the
data. If he is using VB as a front end to design a program that access's the
database I would be leery but only because I am not a fan of VB (personal
opinion). VB, at its best, is still an interpreted program like JAVA, not
compiled like C++. Token driven programs always bother me.

--
Phil Robertson

BSIT [email]phil4114 (AT) email (DOT) uophx.edu[/email]
Work [email]Phil.Robertson (AT) hayssen (DOT) com[/email]
Home [email]PhilR80245 (AT) aol (DOT) com[/email]

-----------------------------------------------------------

"Doug Schmidt" <dugschmidt (AT) earthlink (DOT) com> wrote