RE: [U2] connection from UniBasic to a SQL database

2005-10-19 Thread Bob Witney
Kathy This is how you do it ODBC OpenLink Installation The installation of ODBC multi-tier software requires the following steps; Download the following files from the OpenLink website; 1.) Data Source Administrator Samples(taz)(recommended)Web-based Data Source Administrator JDBC

RE: [U2] ODBC

2005-10-19 Thread Bob Witney
Yes We use OpenLink ODBC drivers across to MS SQL Server 2000 No problems at all once you prise the correct driver out of OpenLink This is how you do it ODBC OpenLink Installation The installation of ODBC multi-tier software requires the following steps; Download the following files from

Re: [U2] Strange $INCLUDE behavior

2005-10-19 Thread Mats Carlid
Bob Woodward wrote: I just wanted to report back to everyone that the problem seems to have disappeared. I wanted to go back and try some suggestions but I now can't seem to duplicate the problem. Everything is back to the way it was, including the OKAY$ variable, and it all compiles without

RE: [U2] ODBC

2005-10-19 Thread gerry-u2ug
isn't this the exact opposite of what was asked ? this explains how to setup uv to sql server , the question was sql server to uv. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Witney Sent: Wednesday, October 19, 2005 03:58 AM To:

RE: [U2] [UV] Problems with uniobjects and windows 2003 server

2005-10-19 Thread César Riba Cervera
Thanks you for you help, we have, tried this and unfortunately it doesn't work, do you have my other suggestions. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de David Jordan Enviado el: martes, 18 de octubre de 2005 22:53 Para:

RE: [U2] Spell-checker?

2005-10-19 Thread Keith W. Roberts
Many *nixes actually distribute vim and make vi a link to it, running in vi compatibility mode. :) 'which vim' or 'whereis vim' at a unix shell prompt should tell you if that's the case. If so, getting the latest version (6.4) will let you use all the features (short of version 7, which is still

Re: [U2] UV Abort

2005-10-19 Thread karlp
quote who=Clifton Oliver Did the second run also cause the fault? Is there anything in that job or job stream that could be trying to build a huge dynamic array? Such as trying to READ and entire report into a variable? No, it executes a LIST file BY var LPTR style command... I have quite a

RE: [U2] UV Abort

2005-10-19 Thread karlp
quote who=Keith W. Roberts What did the phantom log say? You might DISPLAY something after the RUN cmd to make sure the fault occurs after the program completes. I haven't been able to replicate this behavior. Also, the BRIEF keyword causes the output to PH to be suppressed. I may remove that

Re: [U2] UV Abort

2005-10-19 Thread karlp
quote who=Clifton Oliver Did the second run also cause the fault? [brain cramp]... No, the second run from TCL caused no fault. Is there anything in that job or job stream that could be trying to build a huge dynamic array? Such as trying to READ and entire report into a variable? Oh, and

[U2] UV dead lock daemon questions

2005-10-19 Thread Hennessey, Mark F.
In reviewing my uvdlockd.log, I see that even when the deadlock daemon isn't running, it looks like it's being run. Does executing uvlictool clean_lic -a call the deadlock process? Also, in configuring the daemon's resolution strategy, there are three options; random termination, terminate

RE: [U2] ODBC

2005-10-19 Thread Cooper, Rudy
Bob, thank you for the detailed explanation, but I was looking to go the other way, connect from Sql Server to UV. E.g., being in sql query analyzer and selecting UV files, unless this works from sql server to UV as well. Thx, Rudy Date: Wed, 19 Oct 2005 08:58:26 +0100 From: Bob Witney

RE: [U2] UV Abort

2005-10-19 Thread Keith W. Roberts
A way around the problem of creating mostly unnecessary PH logs which require cleanup is to create a wrapper program that: - takes [bpfile and] progname as argument(s) - sets logname = progname:_:date():_:time() - does a SETPTR with BANNER :logname to create a unique log file - runs progname -

Re: [U2] ODBC

2005-10-19 Thread Rick Ward
--- Cooper, Rudy [EMAIL PROTECTED] wrote: Has anyone been successful in creating an odbc connection from sqlserver to UV running on a W2k platform ? Hi Rudy, At the University of Pennsylvania Veterinary Hospital, we have set up a UniVerse ODBC data source as a Linked Server on SQL Server 7

Re: [U2] ODBC

2005-10-19 Thread Don Kibbey
This type of connection is OK for general query type stuff. When performing large transfers of data from UniVerse to SQL server I've found that it's much faster to use bulk loading from DTS (or a stored procedure). Here's a sample of code (without the DTS part which is just a simple bulk load

Re: [U2] UV Abort

2005-10-19 Thread Clifton Oliver
Sure. Unless it dispatched the report to the spooler system and then was doing something like trying to read it as a record and write it to an archive or something. Was tossing out straws to grasp at. -- Regards, Clif On Oct 19, 2005, at 7:57 AM, [EMAIL PROTECTED] wrote: Is there

[U2] Re: U2 Users Digest V1 #888

2005-10-19 Thread Russ DeWitt
I will be out of the office on business, Wednesday 10/19/2005 thru Friday 10/21/2005. During this time I will not have access to my email. If you need to contact me, please call me on my cell phone. Thanks, Russ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please

RE: [U2] ODBC

2005-10-19 Thread Vance, Kathy
I did the same thing in SQL 2000. I created a linked server in SQL 2000 with IBM ODBC driver. I could run the query with Openquery. But I could not see the tables and views in SQL enterprise manager. When I clicked on the tables, I got error saying something like: Error0: SqlDumpExceptionHandler:

[U2] NETWORK

2005-10-19 Thread Will
Thanks John, Anthony and Stephen. The Lantronics support person, named George, implied that there is a listening port for every physical port on his company's terminal server which has at least 15 physical ports, 13 of which have dumb terminals and 2 with HP printers in

RE: [U2] NETWORKING

2005-10-19 Thread Haas, John
We are using lantronix on HP-UX. The setup is below. The port numbers (300x) correspond to the number of ports on the lanronix. We are using 8 port boxes. # /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz5 -x dcterm -p 3001 -k # /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz4 -x dcterm -p 3002 -k #

Re: [U2] UV dead lock daemon questions

2005-10-19 Thread Ray Wurlod
Yes, uvlictool clean_lic does execute the same clean up code as the deadlock daemon, even unto logging to the same file. I don't believe it actually starts a uvdlockd process, however. There is no documentation on strategy, because none is really to be preferred over the others in all cases.

RE: [U2] [UV] Problems with uniobjects and windows 2003 server

2005-10-19 Thread John Jenkins
David interact with desktop being set cures a number of things you are quite correct, and it is ON by default nowadays for just about everything (though if the software is an older version it may not be set .). There were some specific issues which look like this (maybe) hence my

RE: [U2] UV dead lock daemon questions

2005-10-19 Thread John Jenkins
It's probably running in cleanup mode for individual processes as they terminate.. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: 19 October 2005 16:37 To: u2-users@listserver.u2ug.org Subject: [U2] UV dead lock

Re: [U2] NETWORKING

2005-10-19 Thread Will
John, Thanks. How did you get the printout you sent? Will Haas, John wrote: We are using lantronix on HP-UX. The setup is below. The port numbers (300x) c orrespond to the number of ports on the lanronix. We are using 8 port boxes. # /opt/hpnp/bin/hpnptyd -m /dev/ptym/ptyz5 -x