Hello,
After doing research on internet I finally decided to post my question.
We have IBM UniVerse 9.4.1 (therefore it don't comes with UniObjects
for Java). It comes with UCI, ODBC, and UDK.

first I don't want to touch UCI because it is not gonna make my life
easy.
I tried ODBC and am seccessful in connecting to the system and Also
import some files to MS access but all this file is like a DICT
defination for that file i.e. no data just Dict fields. and sometimes
it gives me errors so I left it.

Then I tried UDK which has Objects for VB4 i.e. it is giving me an
error when I try it with VB6.
I also tried JDBC:ODBC bridge which gives me result set is not
suppported.

Why Am I doing all this?

because I want to make a front end forms in Java with nice GUI instead
of console based prompts. All I need is a way to send the data back and
forth between Java and Universe or may be to VB6 if not possible with
this version.

I have found out somewhere that UniVerse shipped with UniObject for
Java with version 9.5 and it is compatible with 9.4. but I am unable to
find a copy available to download.

I will be very thankful to you for saving my time writting C++
routines.
Regards ....

One of our clients was using ODBC on Universe and had issues. They
went to OLEDB and had different issues. We worked with them to use
mv.NET and they are very happy. If you want to venture into .NET and
don't mind spending something for development tools then send me an
e-mail.

If you want to try a free web interface, have a look here:
http://www3.sympatico.ca/ian_renfrew.../docframe.html

I have no experience with UO/VB6 over Universe 9.4 so I have no idea
what the issues are there. If you are proficient with VB you might
just want to use UO for connectivity and send simple messages to UV to
call BASIC programs, not manipulate arrays or use the other extended
API functions. This makes it more of a pipe like for web services.

HTH
Tony
TG@ removethisNebula-RnD.com



"JLo" wrote:

I have heard of many people playing with ODBC and having problems - my
own experiance is that if it is set up correctly then it works well. It
may be worth while to keep trying the odbc and in particular ensure
your dict items and files are set up correctly for SQL, using the tools
provided.

Are they clay tablet user manuals anywhere to be found? Seriously,
ifyou want to put a odern interface on the application, you really
should consider getting up to a current version of the database ....
life will be much easier overall, and more things work

Thank you I will look at mv.Net and for the url you gave me uses
UNIOBJECTS, but the problem is the version I am using don't come with
that, though it is compatible with UniObjects.

I've not touched Universe for 4 or 5 years but back then UniObjects was
the preferred solution for Java integration. The API looked clean and
simple.

I also used RedBack as a pooled connection transport for web
integration but I can't remember if it supported java.

You may want to try the U2 user list for the latest advice on universe
connectivity.

Best of luck.

Dave P.

JLo wrote:

Is there a technical reason you have remained with release 9.4.1? IBM
announced "End of Marketing" for UniVerse 9.6 and below effective
December 31, 2005. You can still obtain licenses and support but no
patches will be available. IBM has added numerous tools and
enhancement to the UniVerse since 9.4.X. You may want to check them
out....

Is there a technical reason you have remained with release 9.4.1? IBM
announced "End of Marketing" for UniVerse 9.6 and below effective
December 31, 2005. You can still obtain licenses and support but no
patches will be available. IBM has added numerous tools and
enhancement to the UniVerse since 9.4.X. You may want to check them
out....

symeonb (AT) gmail (DOT) com wrote:
Not to belabor the matter or disagree with your own personal
experience, but this client took issues through their VAR and IBM. We
were then called because Nebula R&D Team1 has a few U2 guys with
specific expertise with UV/SQL/ODBC. None of these groups of
professionals were able to work out the issues. I posted requests for
assistance to the u2ug forum, and no one there was able to work it out
either, but we did get confirmation that others have experienced
similar problems with no resolution. IBM Support was given a couple
months and was unable to resolve the issues. The ODBC server in
Universe has bugs that cause it to randomly fail but leave licenses
attached. This eventually results in the DBMS running out of licenses
and requiring a restart.

The developer was already using .NET, and with some minor code changes
was able to shift to mv.NET for production use. This site is now
processing (I believe) over 100 users at peak time on 8 licenses.
Speaking of which, the OP didn't mention how many users he has on the
app but since UO doesn't have pooling he may have license consumption
issues even if he does get it working.

JLo, if you want info on mv.NET, see:
http://removethisNebula-RnD.com/prod...t/mvdotnet.htm

Thanks.
Tony

Seriously, you need to upgrade to the current releases.

UV ODBC was completely re-written with release 10.1, and there have
been further
refinements added in later sub-releases.

UniObjects.NET has also been been released and refined, the latest
adding connection
pooling and XML into the mix.

IBM has done the work, it is up to the end user to upgrade and get the
benefits.

Regards, Barry