Sean,

<< I did a quick check last night and came across the instructions to change
a paradox report to advantage database. Looks like there are also
issues with the report engine not keeping the joins the same when switching
to their ODBC driver. For example, the default join for paradox is left
outer join and it looks like the default for their ODBC driver is inner
join. From what I can tell when you switch drivers you must manually change
each link to the proper join. The notes say this is version 8, so maybe this
has been fixed in Crystal XI. Once EDB is out I'll check into it. >>

I'm not aware of any join issues with Crystal.  The only issues we've had
are with pathing and directoy names in the SQL.

<< Out of curiosity, will there be a way using EDB and its ODBC driver so
that I can use code to specify the database location? >>

Sure, you can do it just like with the DBISAM ODBC driver - just specify the
catalog name in the connnection string:

http://www.elevatesoft.com/dbisam4odbc_connection_strings.htm

<< I seem to remember that when I tried the ODBC driver before, I needed an
alias for every database on each machine. >>

Nah, you don't need a DSN for every database if you use connection strings.

<< We have users with 20-30 databases that they switch between, so the
application needs to be sure the report engine is getting the data from the
correct location. Any idea if this can be done with EDB and/or Crystal in
code? >>

Well, I believe Crystal allows you to specify ODBC connection strings, but I
could be wrong.  I'd have to double-check on that.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dominic Willems wrote:


> DBISAM is so extremely stable I can't fathom ever having had to deal
> with the Russian roulette that Paradox embodied. Are there really
> STILL people using that thing? They deserve bravery medals.

Believe it or not, I still have a D1 app being used by several hundred
users that uses Bde/Dbase.  We are discontinuing support this year
after more then 12 years of service. I have had my share of nightmares
with the BDE. We have had to do a lot of things to keep that thing
running.


--
David Farrell-Garcia
Whidbey Island Software, LLC