[U2] UniOleDB Configuration
Hello, My conexion with ODBC are working, but the conexion with UniOLEDB don't can working, when I conect from Visual Basic I recived this error: Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [Informix][SQL Client]UCI connections to non Universe databases is not allowed. My uci.config file in my computer is, and the version of Universe is [9.6.1.3]: [ODBC DATA SOURCES] localud DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = localhost vaquer DBMSTYPE = UNIVERSE HOST = 10.0.0.3 MAXFETCHBUFF = 2 MAXFETCHCOLS = 800 NETWORK = TCP/IP SERVICE = uvserver Can anybody help me. Tanks. Cisar Riba Spain. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB With Crystal Reports
- Original Message - From: Brian Leach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 14, 2004 1:07 AM Subject: Re: [U2] UniOleDB With Crystal Reports I'd sure like to see some documentation that would help address performance when selecting large amounts of data. Frankly, you are unlikely to see great performance from UniOleDB when reporting with most applications. As a minimum, I would suggest that you need to look at your data structures and possibly look at creating reporting accounts: UniOleDB does a good job but it is an uphill struggle when it has to handle 'regular' mv files containing multiple associations, lots of fields per record, lack of indexing etc. snip The things you outline had already been done. OLE DB is supposed to be 'newer and better' and ODBC. I guess that newer and better means slower. wry grin The problem is that ODBC drops off around 170K records, but is very fast, and OLE DB doesn't drop of but is very slow to retrieve. I have a customer that is told by IBM that they must use the partner who has the support contract, to whom money has been paid, but that partner will not provide the support that is needed. IBM won't talk to me about this because I'm not the partner, and my customer is again told to use the support partner. (sounds strangely like circular reasoning) Anyone have any thoughts for how to handle this? Thanks, Bryan Haglund Haglund Consulting Inc. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] UniOleDB Configuration
Cesar, If you are entering a path (location) in the connection string, you will likely have problems - leave this field blank, and let it pull the information from what is set up in the UCI Config Editor. Bryan Haglund Haglund Consulting Inc. - Original Message - From: Cesar Riba [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 14, 2004 7:08 AM Subject: [U2] UniOleDB Configuration Hello, My conexion with ODBC are working, but the conexion with UniOLEDB don't can working, when I conect from Visual Basic I recived this error: Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [Informix][SQL Client]UCI connections to non Universe databases is not allowed. My uci.config file in my computer is, and the version of Universe is [9.6.1.3]: [ODBC DATA SOURCES] localud DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = localhost vaquer DBMSTYPE = UNIVERSE HOST = 10.0.0.3 MAXFETCHBUFF = 2 MAXFETCHCOLS = 800 NETWORK = TCP/IP SERVICE = uvserver Can anybody help me. Tanks. Cisar Riba Spain. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniOleDB Configuration
Hello Tanks for your respons. After of have the changes the error is another, this is the change that I have been in uci.config of my computer. vaquer DBMSTYPE = UNIVERSE HOST = 10.0.0.3 ACCOUNT = \\DELL\CUENTAS\COMERCIAL USERNAME = CESAR MAXFETCHBUFF = 2 MAXFETCHCOLS = 800 NETWORK = TCP/IP SERVICE = uvserver And the error that I recibe is: Died in UCI::SQLConnect() with SQLSTATE IM976, Native error:0 [Informix][SQL Client]An illegal configuration option was found. The string connection of Visual Basic is: Provider = Informix.UniOLEDB DataSource = vaquer Location = \\DELL\CUENTAS\COMERCIAL User = CESAR Password = Tanks Cesar --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] [UV] INPUT madness
From: Barry Brevik [EMAIL PROTECTED] Sent: Friday, May 14, 2004 3:10 PM I'm trying to stuff a variable with a string, then use it with INPUT so that the user sees, and has the option to accept (by pressing ENTER at the start of the field) this default string I've put in the variable. For example: A.STRING = 'HELLO WORLD' INPUT @(00,02) A.STRING This works fine, except the '@' form of input sends an escape sequence to my terminal that obliterates any attributes I want for the field, such as inverse or bold. However, if I dump the @(00,02) and use A.STRING = 'HELLO WORLD' PRINT @(00,02): INPUT A.STRING ...my inverse/bold attribute stays, but my 'HELLO WORLD' string does not appear in the input area! It appears that using INPUT without the '@' actually converts A.STRING to an empty string before prompting the user. Is it possible to get both features? Actually, I know it is because we run a 3rd party app that does it, but I can't see inside it. I haven't got a Universe machine here, but off the top of my head: A.STRING = HELLO WORLD DISP.COL = 0; DISP.LINE = 2; BOLD = 1; GOSUB GET.A.STRING: FIRST.VALUE = A.STRING ... A.STRING = GOODBYE WORLD DISP.COL = 0; DISP.LINE = 3; BOLD = 0; GOSUB GET.A.STRING: SECOND.VALUE = A.STRING GET.A.STRING: CRT @(DISP.COL, DISP.LINE): * IF (BOLD) THEN CRT @(-???): ;* Fill in the attribute I can't remember right now END * CRT A.STRING: @(DISP.COL, DISP.LINE): INPUT MIGHT.BE.A.STRING * IF (MIGHT.BE.A.STRING) THEN A.STRING = MIGHT.BE.A.STRING END * RETURN --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] [UV] INPUT madness
you'll need some @(-value) items before after your A.STRING do the following to get a list of values HELP BASIC @ Rich Barry Brevik wrote: I'm trying to stuff a variable with a string, then use it with INPUT so that the user sees, and has the option to accept (by pressing ENTER at the start of the field) this default string I've put in the variable. For example: A.STRING = 'HELLO WORLD' INPUT @(00,02) A.STRING This works fine, except the '@' form of input sends an escape sequence to my terminal that obliterates any attributes I want for the field, such as inverse or bold. However, if I dump the @(00,02) and use A.STRING = 'HELLO WORLD' PRINT @(00,02): INPUT A.STRING ...my inverse/bold attribute stays, but my 'HELLO WORLD' string does not appear in the input area! It appears that using INPUT without the '@' actually converts A.STRING to an empty string before prompting the user. Is it possible to get both features? Actually, I know it is because we run a 3rd party app that does it, but I can't see inside it. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] [UV] Spooler count location
From memory it's not stored anywhere, except implicitly in the usplog file in the UVSPOOL directory (default /var/spool/uv). This file is a record of the usd's memory of the queue. It's definitely not in the root directory. - Original Message - From: John Hester [EMAIL PROTECTED] Date: Fri, 14 May 2004 13:01:56 -0700 To: U2 Users Discussion List [EMAIL PROTECTED] Subject: [U2] [UV] Spooler count location I'm configuring a couple of RedHat servers with UV 10.1 in a failover setup. I'm going to put the UV spooler directory on shared storage so it's available to both machines, but I also need the file that keeps track of the current spooler count to be shared. I looked in the spool/uv directory but can't find the counter there. I'm assuming it's somewhere in the `cat ./uvhome` directory. Anyone know where? Thanks, John --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] My company is complaining about the U2 emails
Miscellaneous suggestions that can be taken one at a time or combined: - Have the mail sent to some non-filtered e-mail server like hotmail and then have people poll that server from their normal e-mail client or a different one. - Get the digest version, zip it, then manually distribute to employees periodically. - Automate that process as a programming exercise. - Pay someone to write up that functionality and send digests. - Have someone post digests to an FTP site. - Write code to pre-filter mail for bad words then resend it to your U2 developers. - Read mail through a web interface. - Educate the company IT staff on how to properly filter mail with combinations of keyword black lists and e-mail address white lists. - Get new mail filter software. - Get a new IT staff. HTH, Tony -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Andra Lozzi Sent: Friday, May 14, 2004 4:14 PM To: [EMAIL PROTECTED] Subject: [U2] My company is complaining about the U2 emails I just thought I would let you know that our UniVerse Programing Team has been asked to quit receiving emails from this list because our company's email filter catches a lot of the emails for curse words. Grant it, some of them are relatively minor curse words but I have no control over what they filter. Nor, do I have control of their choice of filtering programs. One of our operators reviews the quarantined emails and forwards those that are work related. This puts a real workload on them when a cursing email receives a number of responses. We have 10 UniVerse programmers in our company so it can generate a lot of emails to review. I do not want to have to remove myself, or my programmers, from the list so I thought I would let everyone know how this is affecting the people at my company. Thanks for listening, Andra Lozzi UniVerse Programming Manager Software Quality Assurance Manager Mouser Electronics 1000 N Main St Mansfield, TX 76063 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] My company is complaining about the U2 emails
Hey! My first opportunity to complain about something as a private citizen rather than as the Moderator. (Wheee.) A lot of this would be eliminated if people weren't so lazy that they refuse to trim the e-mail. Another example of how quoting the entire quoted quote of quoted quotes hurts innocent list members. (Oo. That felt good :-) -- Regards, Clif On May 14, 2004, at 18:14, Andra Lozzi wrote: One of our operators reviews the quarantined emails and forwards those that are work related. This puts a real workload on them when a cursing email receives a number of responses. We have 10 UniVerse programmers in our company so it can generate a lot of emails to review. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users