Re: [U2] Domino and Unidata

2007-11-08 Thread robwills_u2list
I have done plenty of interfacing between Domino and UniObjects (in my 
case with UniVerse rather than Unidata).  Yes you can access U2 databases 
from Domino agents.  I'd be happy to send you some source code if you're 
interested although it might take me a day or two to dig it out.

You could contact me via http://www.inter-weavers.com/

Regards,

Rob Wills

Charles Shaffer wrote on 08/11/2007 14:15:15:

> Has anyone had experience accessing Unidata databases from Lotus Domino 
> databases?  Are the Uniobjects COM libraries callable from Domino 
Agents, 
> or is there a better way?  I need to populate Notes record's fields with 

> data from Unidata.  Documentation, etc would be greatly appreciated.
> 
> Charles Shaffer
> Senior Analyst
> NTN-Bower Corporation
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Incubator - News from the board

2007-05-10 Thread robwills_u2list
It strikes me that one good way to deliver this would be using VMware or 
some other similar virtualisation technology that can be run in a free 
player (VMware Player) on any Windows or Linux operating system.  This 
would make the install easy and all the databases and documentation etc. 
could be pre-installed.

Regards,

Rob Wills
(rob dot wills at inter hyphen weavers dot com)

[EMAIL PROTECTED] wrote on 10/05/2007 04:39:21:

> All,
> The U2UG board has been discussing the 'incubator plan' and we will 
> soon be presenting a draft proposal to membership. Here's what we are 
> discussing in broad brushstrokes - all feedback appreciated.
> 
> We want an *easy* *legal* way to get PE editions into the hands of 
> business people, college students, entrepreneurs, and other market 
> expanders. More than that, we need to get people a version of the PE 
> software which is chock full of examples, training materials, and useful 

> information.
> 
> Here's what we have in mind: We want to build an installer which 
> pulls the PE editions from the IBM website (allowing the user to sign 
> the IBM agreement), pulls Learner Packs from the U2UG website (allowing 
> the user to sign the U2UG agreement - designed to protect the content 
> all of you will - hopefully - contribute). Finally, the installer will 
> bootstrap the Learner Packs into the PE installation, so the accounts, 
> files, and programs, etc. are all in place.
>  The end result will be a full install, with URLs to get them to the 

> U2UG and other key locations. It will allow people to see our technology 

> in the best light possible. Opinions? Flames? Offers to Help?
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] How much RAM is too much

2007-03-14 Thread robwills_u2list
I'm not an expert in this area but my gut feel is that the box isn't 
really the issue.

If you've already decided on XP Pro then get as much memory as it can 
address (which sounds like 3GB or 4GB from other posts).

The speed of the network is going to be the bottle neck so can you modify 
the way the data is accessed?  For example, I have seen huge differences 
between using SQL over ODBC and over OLEDB.  If it is possible, use a 
technology like OLEDB that puts the processing as close as possible to the 
data to eliminate the network overhead.  This is somewhat like using a 
stored procedure but it sounds like changing the configuration of the SQL 
boxes is not an option.

What I am trying to say is that a slight change to the architecture may 
make all the difference.  But I'm sure you know all that!

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

[EMAIL PROTECTED] wrote on 12/03/2007 19:51:53:

> All,
> I need some opinions! I have a client who is willing to spend to put 

> up a nice sized box, but they only want to spend once. Here's what they 
> need to do: run a 4 user copy of Universe, holding a Type 30 file with a 

> mere 200k records. Requests will range from give me one record (average 
> size is under 200 bytes) to give me all records.
> The catch is that two SQL databases, with criminally slow network 
> connections will be feeding a fresh set of records every hour.
>  I need a recommendation on how much RAM and Processor to throw at 
> the system so that SQL joins (6 levels deep) don't slow down the 
> UniVerse part of the system. The response time has to be obscenely quick 

> (eCommerce for a very, very busy site).
> All thoughts appreciated.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Access to IBM knowledgebase for in-house developers

2006-11-13 Thread robwills_u2list
I use the IBM site all the time for Lotus Notes/Domino related 
information.  They have forums and tech notes etc. and none of these are 
password protected.

Incidently I have an IBM ID and password that I received ages ago as a 
Lotus Notes Business Partner.  That password allows me to see the UniVerse 
(and presumably Unidata) tech notes.

Why not become a Lotus Notes business partner (I'm sure it's free) and 
then U2 could access the knowledge base?!

Incidently, I'm a firm believer that keeping knowledge to yourself in 
order to try and retain power or control is ultimately flawed and that 
sharing knowledge is usually a WIN WIN.  If your VAR doesn't agree, you 
could always vote with your feet. 

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

"Stevenson, Charles" <[EMAIL PROTECTED]>  wrote on 
13/11/2006 06:33:56:

> Yes, now it's easy, except for pages that get moved around so bookmarks
> fail, & login confusion that Deb already noted.  But that's a separate
> issue.  (I wonder if the other IBM user groups are complaining about
> that.)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] UCAC0 Conversion

2006-07-17 Thread robwills_u2list
Thanks Adrian.  We are using the PI/open flavour too.

We seem to have a four argument subroutine with the first argument being 
the return value.  I guess that this is the same thing as a three argument 
function?

It does seem to be working (with some warnings) and I will now do some 
further debugging to figure out what has changed between our older server 
on UV9.5 and our new one on UV10.1.18.

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

[EMAIL PROTECTED] wrote on 17/07/2006 02:27:27:

> Here's how we do it:
> 
> Write the code as a function with a name of "U" (where  is a
> FOUR character conversion code) and the following three arguments:
> 
> STATUS.CODE  Input=the conversion code, output=the value to
> set STATUS()
> DATA.FIELD  Input= the data to be converted
> INTERNAL  Input: @true = ICONV, @false= OCONV
> 
> STATUS.CODE can be useful, as you can use conversion codes that are
> longer than the specified 4 characters, you can conditionally do extra
> processing based on these extra characters (eg. all the extra codes on
> the end of date conversions).
> 
> Your function should then RETURN() the required result.
> 
> After compiling the function, you need to GLOBALLY catalog it, using
> this format:
> 
> CATALOG BP $CAC0 UCAC0 FORCE
> 
> That's assuming the program in the BP is called UCAC0.
> 
> Disclaimer: this all works for us in a PI/Open flavour account, I can't
> see why it wouldn't work in other flavours.
> 
> AdrianW
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] UCAC0 Conversion

2006-07-14 Thread robwills_u2list
About 10 years ago I wrote a routine using the UCACn style conversion 
whereby a BASIC program is called to undertake the conversion.  We seem to 
have a minor problem following a server upgrade and I wanted to read up on 
this again.

Could anyone please point me at which manual this would be documented in. 
I had a quick search through some PDF manuals I had but didn't find 
anything.

Thanks in advance ...

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Changing server IP address

2006-07-10 Thread robwills_u2list
Thanks to all of you who responded on this.  Great to have so many 
responses with no conflicting answers!!

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

[EMAIL PROTECTED] wrote on 10/07/2006 15:54:14:

> This is exactly how we have handled new servers in the past.
> -Dianne
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Changing server IP address

2006-07-10 Thread robwills_u2list
We are currently upgrading to a new solaris server.  The plan was to go 
live with the new server this week.  In order to minimise disruption, we 
had planned to modify the IP address and hostname of the new server to 
match the current production server (as well as changing the IP address 
and hostname of the current production server to avoid a clash).  This 
would have meant that no client terminal emulator settings would need 
changing.

Will this be possible or will the UniVerse software complain because it 
thinks it has been copied to a different server?  Are we better off 
configuring the client PCs?

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Fw: [UV] Problem starting the UniRPC Daemon

2006-06-30 Thread robwills_u2list
Scrap what I just said.

The /unirpc/unirpcservices file didn't exist.  All we had in 
the /unirpc directory were two files:

unirpcd
version

I have copied unirpcservices across from another server (with identical 
install pathnames) and have now successfully started the daemon.

Apologies :-<

Not sure why the file wasn't created during the install though?

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

Rob Wills wrote on 30/06/2006 13:22:41:

> We have just installed UniVerse 10.1.18 on Solaris.
> 
> When we tried to start the UniRPC daemon using the instructions from
> chapter 19 of the admin guide:
> 
> Starting the UniRPC Daemon
> Complete the following steps to start the UniRPC daemon:
> 1. Choose Rpc administration from the Package menu, then choose Start 
the
> rpc daemon.
> 2. At the prompt, do one of the following to handle any error messages:
> .. Enter the name of the file to send all error and system messages to.
> .. Enter a space to display messages on your screen.
> .. Press ENTER if you do not want to display or save messages.
> 3. At the next prompt, click Yes to start the UniRPC daemon or No 
toreturn to
> the Rpc administration menu.
> Note: The file that receives all error and system messages can grow 
> unchecked unless
> you monitor it periodically.
> Once you start the UniRPC daemon, it automatically restarts whenever you 
boot
> UniVerse.
> 
> we get the following error message:
> 
> Either the /.unishared file does not exist or is corrupt,
> or the /unirpc/unirpcservices file does not exist,
> or the uvrpc entry in /etc/services does not exist.
> The RPC daemon is not being started.
> 
> Unfortunately the /.unishared file does exist and has the path in it
> that I would expect, the /unirpc/unirpcservices file 
> exists and the uvrpc entry within /etc/services exists.
> 
> Any ideas?  I hope it's something simple but I couldn't find this 
> error in the history that I have for the forum.
> 
> Regards,
> 
> Rob Wills
> (rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] Problem starting the UniRPC Daemon

2006-06-30 Thread robwills_u2list
We have just installed UniVerse 10.1.18 on Solaris.

When we tried to start the UniRPC daemon using the instructions from 
chapter 19 of the admin guide:

Starting the UniRPC Daemon
Complete the following steps to start the UniRPC daemon:
1. Choose Rpc administration from the Package menu, then choose Start the
rpc daemon.
2. At the prompt, do one of the following to handle any error messages:
.. Enter the name of the file to send all error and system messages to.
.. Enter a space to display messages on your screen.
.. Press ENTER if you do not want to display or save messages.
3. At the next prompt, click Yes to start the UniRPC daemon or No to 
return to
the Rpc administration menu.
Note: The file that receives all error and system messages can grow 
unchecked unless
you monitor it periodically.
Once you start the UniRPC daemon, it automatically restarts whenever you 
boot
UniVerse.

we get the following error message:

Either the /.unishared file does not exist or is corrupt,
or the /unirpc/unirpcservices file does not exist,
or the uvrpc entry in /etc/services does not exist.
The RPC daemon is not being started.

Unfortunately the /.unishared file does exist and has the path in it that 
I would expect, the /unirpc/unirpcservices file exists and the 
uvrpc entry within /etc/services exists.

Any ideas?  I hope it's something simple but I couldn't find this error in 
the history that I have for the forum.

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [UV] Replication for DR / for Regional Office

2006-05-19 Thread robwills_u2list
Hi folks, I hope one of you smart people can help me ...

One of my clients has a 48 user Universe licence on Solaris and they have 
just bought another Solaris box for better performance / reduced 
maintenance.

However, they are interested in the option of using Replication to help in 
the event of a disaster at their main site.

They have been told (a while back) that they would need the same number of 
users licenced on their standby box and no-one actually using it day to 
day.

However, in the event that they may only need 10 licences in an emergency, 
is it possible to simply buy an additional 10 users for the older box and 
have this at a regional office and actually in use all the time?

If there are already licence details posted for this, can someone please 
point me at them.  Thanks a lot.

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Unit testing and UniObjects for Java

2006-05-08 Thread robwills_u2list
Great post Brian

It made me think about some of the code I'm working on right now and I 
think I'll make a few changes as a direct result.

Thanks!

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] List dead ?

2006-04-11 Thread robwills_u2list
Yeah Sharyl, you've still some learning to do.

The list administrator is spending plenty of his own good time on our 
behalf and you shouldn't resort to calling him an idiot for a decision 
that was designed to save him some of it.  If you feel so strongly, why 
not offer to help?

Regards,

Rob Wills

[EMAIL PROTECTED] wrote on 11/04/2006 16:25:33:

>  Ever since they changed the 'reply to' from the list to a person, I
> feel the list has died a slow death. I've been thinking of unsubscribing
> myself but I just can't bring myself to lose the chance to stop learning
> *something* just  because I think the list admin is an idiot and the
> people who can't filter whiners. 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Changes to the List

2006-03-16 Thread robwills_u2list
Interestingly, that gmane site had a posting rate chart (see link below) 
which confirms that usage has dropped off.  However, you can see that it 
did the same last year as well so can't necessarily be attributed to the 
list change being discussed.

I don't care either way.  I don't post too often but think I can manage 
fine!

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

Wendy wrote on 16/03/2006 16:05:55:

> If you prefer a newsgroup, it looks like the list is already on Gmane:
>http://dir.gmane.org/gmane.comp.db.u2.general
> 
> HTH,
> --
> Wendy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniObjects Select Error

2006-03-07 Thread robwills_u2list
The error code is partially explained by this line; however I don't know 
what caused it  :-<

Const UVE_SR_SLAVE_READ_FAIL = 39207' Failed to read from the slave 
correctly

HTH

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

"Dave Tabor" <[EMAIL PROTECTED]> wrote on 07/03/2006 21:09:59:

> 
> Any guess what the error code means, and/or what I could try to do 
> to resolve this issue?
> 
> Thanks,
> Dave
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [u2][ud] Poor select performance

2006-02-10 Thread robwills_u2list
Out of interest, how long does the selection take without the index?

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

Martin Philips wrote on 10/02/2006 14:04:26:

> Given the number of records that you say are in the file, you are 
probably
> going to visit most groups anyway so the index is not gaining you much 
for
> this example.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] XML and Accuterm

2005-08-26 Thread robwills_u2list
I wrote on 25/08/2005 19:42:13:

> In my original post, I admitted to not actually using Accuterm.  I was 
> basically saying that if Accuterm supported VBA then it should 
definitely 
> be possible to send and receive XML just as you could in VB.
> 
> I've since been on the Accuterm site just to check what it can do.  It 
> does seem to have the capability to use VB object libraries and here's a 

> URL link to a page on their site which goes into a lot of detail:
> 
> http://www.asent.com/email_white_paper.htm
> 
> As for the actual code to send and receive XML, I will need to dig that 
> out of an application and I'll post it tomorrow hopefully.

I promised some pointers to sending and receiving XML using a Windows 
application such as Accuterm that supports VBA.  Here is a link to a page 
on Microsoft's site that gives some ASP examples:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/e5c17f89-0197-496c-9164-ce0bbbd8490f.asp

Where the code has:

var objSrvHTTP;
objSrvHTTP = Server.CreateObject ("Msxml2.ServerXMLHTTP.3.0");

the VB equivalent that you would use would be something like:

Dim oXMLServer As Object
Set oXMLServer = CreateObject("Msxml2.ServerXMLHTTP.3.0")

The last example on the page shows how to send and receive XML.

The syntax is visual basic so it is identical to using the UniObject 
Libraries.

You need to be aware that if you go down this route then every Accuterm 
client PC that requires the functionality would require the XML library 
installing locally (or the DLL registered).  This is one of the reasons 
why getting code to execute on the server is preferable.

In order to get hold of the library, go onto Micro$oft's site and do a 
search for MSXML from the Download Centre.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] RE: free info - was XML and Accuterm

2005-08-26 Thread robwills_u2list
Tony wrote on 25/08/2005 21:09:03:

> I'll also note that Rob Wills just went to the Accuterm web site and got
> info that anyone could get, and generously volunteered to come up with 
more
> info from research tomorrow.  That's very helpful and I'd usually do the
> same myself, but in this case Rob is volunteering to do research simply
> because Will doesn't feel like doing it.  That is so wrong.

Actually the only reason I got involved was because someone said it 
couldn't be done using Accuterm. I stuck my neck out to say it probably 
could and then felt that I had to justify my opinion.  I find the forum 
incredibly useful as a resource and feel it is important to correct 
anything that is mistakenly posted.

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] XML and Accuterm

2005-08-25 Thread robwills_u2list
In my original post, I admitted to not actually using Accuterm.  I was 
basically saying that if Accuterm supported VBA then it should definitely 
be possible to send and receive XML just as you could in VB.

I've since been on the Accuterm site just to check what it can do.  It 
does seem to have the capability to use VB object libraries and here's a 
URL link to a page on their site which goes into a lot of detail:

http://www.asent.com/email_white_paper.htm

As for the actual code to send and receive XML, I will need to dig that 
out of an application and I'll post it tomorrow hopefully.

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

[EMAIL PROTECTED] wrote on 25/08/2005 15:20:08:

> In a message dated 8/25/2005 12:41:26 AM Pacific Standard Time, 
> [EMAIL PROTECTED] writes:
> 
> VB  including using standard Microsoft 
> XML libraries which include methods for  sending and receiving XML via 
HTTP 
> 
> 
> Do you have example code where you do this?
> Thanks
> 
> I would also be interested in seeing any examples you have of that.
> thanks
> Victor St. Clair 
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] XML and Accuterm

2005-08-25 Thread robwills_u2list
Glen wrote:

>> I'm pretty sure that Accuterm has no capability to perform socket 
connections using scripts.
>> It has VBA(Visual Basic for Applications) capabilities, which is 
nothing like VB.

That is not my experience.  VBA is a lot like VB.  I have no experience of 
Accuterm but if it has a decent implementation of VBA then you could do 
whatever you like that you can do in VB including using standard Microsoft 
XML libraries which include methods for sending and receiving XML via HTTP 
(just an example).

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Uniobjects hack

2005-05-27 Thread robwills_u2list
The ability to bypass application security using UniObjects has really got 
me thinking.  In the absence of any suitable remedies and perhaps as a 
stop gap solution whilst a better solution is written, I would recommend 
the following:

1. As Martin said, make sure that you do not let UniObjects traffic 
through your firewall.  This cuts down the threat from outside but many 
hacks come from employees who are disgruntled or just plain nosey.

2. If you don't require UniObjects on all PCs then don't install it.  If 
you do require it, don't install the documentation that gives the user a 
sample application to copy.  Change the standard port used by UniObjects 
and don't advertise it.

3. Consider an architecture where the UniObjects client is a separate 
server (e.g. web server or Citrix server) and users don't require the 
UniObjects DLLs on their own client.  This is also easier to maintain when 
you upgrade.

4. In addition to application security, make use of OS security.  For 
example, if your HR system is only used by a handful of people, don't give 
all your users access to the data files and rely on the application 
security to keep them away.  If they have to steal a password as well as 
write a VBA program, it is harder than just writing a VBA program.

5. Don't hard code usernames and passwords into your source code!  They 
can be seen in the object code of any application. 

6. Keep an eye on logs and look out for unusual behaviour.  Can anyone 
help me with this?  What logs are written to when someone logs in and can 
you distinguish between a telnet login and a UniObjects login?

The reason it got me thinking was because I am guilty on a number of these 
points :->  so thanks for the question!

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/