Tim,

I have the ANSI on D2007 and Unicode on D2010.  I'm doing a project in
D2010 but need to have an app in D2007 access it.

Is there anyway I can have the ANSI/Unicode versions exist in the IDE
Without having them have seperate VM's with an Ansi/Uni version?  I
don't have a problem with constraints being that an app can only have
unicode or ansi but not both.

Right now, the only routes I see are:

1. Make a DLL in D2010 to have the D2007 call.
2. Use the ODBC route with the unicode ODBC.
3. Duplicate VM's with Uni/Ansi

Lance

Lance,

<< Is there anyway I can have the ANSI/Unicode versions exist in the IDE
Without having them have seperate VM's with an Ansi/Uni version? >>

Not at the same time, no.  You can only have one active design-time package
for EDB in a single IDE at a time.

<< Right now, the only routes I see are:

1. Make a DLL in D2010 to have the D2007 call.
2. Use the ODBC route with the unicode ODBC.
3. Duplicate VM's with Uni/Ansi >>

What kind of functionality does the 2010 application have that the 2007
needs to access ?  Or is it just the data that it needs to access ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Lance,
>
> << Is there anyway I can have the ANSI/Unicode versions exist in the
> IDE Without having them have seperate VM's with an Ansi/Uni version?
> >>
>
> Not at the same time, no.  You can only have one active design-time
> package for EDB in a single IDE at a time.
>
> << Right now, the only routes I see are:
>
> 1. Make a DLL in D2010 to have the D2007 call.
> 2. Use the ODBC route with the unicode ODBC.
> 3. Duplicate VM's with Uni/Ansi >>
>
> What kind of functionality does the 2010 application have that the
> 2007 needs to access ?  Or is it just the data that it needs to
> access ?

Just needs access to the data.

Two different applications using the DB, with the D2007 application
doing the initial inserts and the D2010 application doing some updates
in some fields.

I wanted to try and keep unicode on the D2010 due to the IDE being just
that.

My major apps are still in D2007 and use the ansi DB's still.

Maybe installing the unicode in a different location and a package
switcher in the IDE?

Lance,

<< Just needs access to the data. >>

Okay, you can make that work, but you'll have to use a DLL that contains the
Unicode access layer for 2007, and call that from the 2007 application.
It's kludgy, but it's indicative of the same issues that I've been wrestling
with for some time in terms of the trying to write a migrator that can
transfer an ANSI database to a Unicode database, or vice-versa.

--
Tim Young
Elevate Software
www.elevatesoft.com

Arg....

Let me ask you this.   How difficult would it be to have both installed
in the IDE at the same time, with the understanding they can not be in
the same project at the same time?

While I know you wouldn't want a third installer, I was thinking that
if you have an option in the UNI installer that has a "UNI Only" or
"Compatible with ANSI Packages" option which would use a differently
named package for the UNI, then that might be nice...  (Didn't say easy
 )

With some fudging, I might be able to rebuild the source code, install
both uni / ansi in different directories and use a package switcher to
use the appropriate one.

Sounds like I may have to abandon unicode on the DB, which I don't
really want to do.

Lance



Tim Young [Elevate Software] wrote:

> Lance,
>
> << Just needs access to the data. >>
>
> Okay, you can make that work, but you'll have to use a DLL that
> contains the Unicode access layer for 2007, and call that from the
> 2007 application. It's kludgy, but it's indicative of the same issues
> that I've been wrestling with for some time in terms of the trying to
> write a migrator that can transfer an ANSI database to a Unicode
> database, or vice-versa.

Lance


I haven't looked at unicode but I think the problem is component names. Unless Tim has different names for the engine, session, query, table etc components you can't have both in the IDE or a project simultaneously. If you have the source and feel adventurous you could alter the names yourself.

Then again I could be totally wrong.

Roy Lambert [Team Elevate]

Lance,

<< Let me ask you this.   How difficult would it be to have both installed
in the IDE at the same time, with the understanding they can not be in the
same project at the same time? >>

As Roy indicated, the component names are the same, so you can't have both
design-time packages loaded at the same time in the IDE.  And I'm not real
keen on changing the component names.

--
Tim Young
Elevate Software
www.elevatesoft.com