UniObjects anyone?

Has anyone ever used UniObjects to access a Unidata / informix database from LotusScript?

ODBC is painfully slow and UniObjects work great with VB6.

I would appreciate any suggestions or ideas.

Thanks,

Subject: UniObjects anyone?

We are using the COM and Java objects here. What do you need?

Subject: RE: UniObjects anyone?

Thanks for a quick response.

I’m implementing this through LotusScript so I’m not sure if I can load the uniobject.dll and register the unisession. Currently I’m using ODBC with the Uselx “LSXODBC” then I create the appropriate ODBCConnection, Query and Resultset.

By the way, how are you using java with lotusscript? Are you using the asjava library?

Thanks again,

Subject: RE: UniObjects anyone?

Sorry for the late response.

The UniObjects have nothing to do with ODBC. They are registered by windows (Using reg32.dll) See the instructions in the redistribution kit. You invoke them as you would a com application (Like Excel) Fill in your info for the session object. Your universe server must be running RPC so it’s listening for the connection.

Set UVSession = CreateObject (“UniVerse.Session.1”)

UVSession.HostName = “”

UVSession.AccountPath = “”

UVSession.UserName = “”

UVSession.Password = “”

You don’t use any of those ODBC classes. It’s a whole different syntax. You create a file object, set a record pointer, read the record to an array, etc.

You can call Java using Uselsx “*javacon”, I think you would need to have the classes loaded in your notes.ini file (JavaUserClasses)

Because the objects need to be installed on the machine talking to Universe, I have put them on the server and I just call a agent running there. I write what I need to a parameter document and the agent writes the results on to the same document. This saves me from having to install and maintain the dlls, but makes the code more complex and harder to test.

Subject: RE: UniObjects anyone?

Thanks for your help on this.

This is running as a web based agent on the server. Using the …/my-database-name.nsf/agent-name!openagent" syntax.

I get an error in my notes log file at the CreateObject line.

05/11/2005 08:28:57 AM Agent message: ************ code error after this line *


05/11/2005 08:28:57 AM Agent ‘Query’ error: Cannot create automation object

Do I need to declare something?

Thanks again for your help.