U2 Connection (OpenInsight 32-Bit)
At 22 AUG 2005 03:38:52PM Richard Hunt wrote:
I tried setting up a U2 connection. Got an error message…
ENG0805: U2_CONNECTION_INFO, line 1. Function ic_universe_session does not exist in dynamic link library UVIC32.
I do have UVIC32.DLL in the windows\system32 folder. I was wondering if my UniVerse version 9.4.1.2 is capable of this?
At 22 AUG 2005 05:05PM Richard Hunt wrote:
Nevermind… an invalid path in the "usr/path" caused the error message.
So… about the "u2_subs"… any documentation? It would be very nice to be able to "select", "readnext", "read", and "readlist".
My imaging software would be enhanced greatly if I could index the images not only by "invoice". I would like to include indexing the images by "customer", "customer bill of lading", "customer purchase order", and since all that indexing is already on the U2… would be nice to access it.
At 22 AUG 2005 07:52PM dsig _at_ sigafoos.org wrote:
The concept to the U2 bond is that it works under OI just as it does with OI tables.
So once you have a connection and have attached your 'U2' volume then you should be able to
subroutine foobar( void )
open
,'u2table' to hu2table then select hu2table eof=0 loop readnext idu2table else eof=1 until eof do read rec from hu2table, idu2table then … … end repeat end return You can also rlist('SELECT u2table WITH NDXD_COLUMN=FOOBAR"',target_activelist$,,,)which would create your select list.
On indexes .. OI simply uses what is there.
hope this helps .. if i didn't miss your point
dsig
At 22 AUG 2005 07:56PM dsig _at_ sigafoos.org wrote:
If i remember right .. this error is normally caused by not having the UniDK .. InterCall dll installed on the client
dsig
At 25 AUG 2005 11:10AM dsig _at_ sigafoos.org wrote:
Richard .. is this all working for you now?
dsig
At 25 AUG 2005 11:55AM Richard Hunt wrote:
Oh yes, thanks…
I simply mis understood things. Your post directed me in the right direction.
By the way… I have found that I can not use "alias table". If I have a table that has the same file name on both U2 and OI, what do you do?
At 25 AUG 2005 10:52PM dsig _at_ sigafoos.org wrote:
Hmmm .. i don't have that .. or haven't. You will just have to alias_table the OI table.
What are you trying to do. have them both attached all the time? or just to copy etc?
dsig
At 26 AUG 2005 11:28AM Richard Hunt wrote:
Well… I am trying to do silly things. I have customers on U2 and I have darn near completed the OI equivelant. So… I was just trying to use OI to see if I could access the U2 system. I just happen to run into identical table names. I was just playing and testing and found that I could not alias the U2 tables, that is all. I do already have the export, import, and conversion for the tables.
I might use the U2 connetion routines for enhancing my imaging software. And I do believe it will also inspire some customers to move to my OI software.