[U2] UVODBC conflict
DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Hello usergroup, Just submitted this to IBM support, but I thought I'd see if anyone on here had seen this. One of our customer sites has just had the UVODBC client driver installed and noticed that when this is installed software from another supplier stops working. The removal of the UVODBC driver means the other software works perfectly fine again, without reinstalling it. I have contacted the supplier of the software conflicting with the UVODBC and they have stated that they use the Seagate Crystal Report Writer Version 7 (32 bit) ocx within their class application that's having the problem. They have sent me a list of all the system files installed with their application, which I have listed below, in case there are any conflicts between the UVODBC driver and their system files. ASYCFILT.DLL CO2C40EN.DLL COMCAT.DLL COMCTL32.OCX crpaig32.dll crpe32.dll CRXLAT32.DLL crystl32.ocx DAO2535.TLB DAO350.DLL DBGRID32.OCX DBLIST32.OCX EXPSRV.DLL implode.dll MFC40.DLL MSEXCL35.dll MSFLXGRD.OCX MSJET35.DLL msjint35.dll msjter35.dll MSLTUS35.DLL MSMASK32.OCX MSPDOX35.DLL msrd2x35.dll MSREPL35.DLL MSTEXT35.DLL MSVBVM60.DLL MSVCRT.DLL MSVCRT20.DLL MSVCRT40.DLL MSXBSE35.DLL OLEAUT32.DLL OLEPRO32.DLL p2bdao.dll p2ctdao.dll p2irdao.dll p2sodbc.dll PG32.DLL SCRRUN.DLL STDOLE2.TLB TABCTL32.OCX tdbg5.ocx THREED32.OCX u2ddisk.dll u2dmapi.dll u2fcr.dll u2fdif.dll u2fhtml.dll u2frec.dll u2frtf.dll u2fsepv.dll u2ftext.dll u2fwks.dll u2fwordw.dll u2fxls.dll VB5DB.DLL VB6.OLB Vb6ext.olb VBAJET32.DLL vbar332.dll VSFLEX7D.oca Vsflex7d.ocx Looking at some of the files above, it would seem that their software is written in VB6, but other than that there's nothing obvious to me. (the U2 dll's look suspicious, but not sure) If anyone's able to advise on this I would be grateful. We have installed the UVODBC on many sites and this is the first time we have had a problem of this nature. The Universe version is 10.1.3 and the client driver is the version that's supplied with 10.1.3 Their server is a Windows server. Thanks Andy Moore Selima Software Ltd Tel: 0114 2815000 Fax: 0114 281 email: [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV to Access via ODBC - driver issue
Thanks for your response.This would be a great idea if the Access database wasn't a realtime system.It's counting parts used on reels from our machines on the shop floor and is constantly updated from multiple sources. Unless I'm not fully understanding what you're suggesting... John [EMAIL PROTECTED] 11/7/2004 8:44:55 PM John, You might want to patch it by exporting the Access data to a flat file and push that into a UniVerse Type 19 where you can parse it. There are third party tools [AD] including mine www.MtOlympus.us [/AD] that can help you with the data conversion and parsing. If you need an alternate ODBC driver, you may want to look at Fusionware. I don't recall if they have something MS Access specific, but I suspect they do. - Charles Dicing Up the Data Barouch John Koch-Northrup wrote: I've been struggling through this one the last few days - any help would be GREATLY appreciated. Platform: Dataflo 5.8.4 on Universe 10.0.10 on Win2000 sp 3 (though I don't think Dataflo is an issue here...) Previously working state: Dataflo screen via the Universe BCI module calls ODBC on the server - in Data Sources (ODBC) System DSN tab I have a pointer to a Microsoft Access 2000 file.Screen sends an id to the Access database - a total number of parts on a reel is returned from the Access database and placed into the screen. It's been working nicely for about 6 months. How it was broken: The system that stores data in the Access file was upgraded on Thursday. The Access file is now (I believe) at XP level. The ODBC connection is broken. Attempted fix (that failed): Research on Microsoft's site led me to believe that upgrading to Jet 4.0 sp 8 and MDAC 2.8 would fix the problem. I found an article (which I oddly can't find now...) that stated that Access beyond version 2000 no longer had a specific ODBC driver to connect to it - you now connected through the Oracle driver. Admittedly - I thought that was an odd statement and I'm trying to get back to that article and read it through again. At the moment - I have the server sitting with Jet 4.0 sp 8 and MDAC 2.8 - and cannot connect to the Access file correctly. Anyone run into something similar? Thanks! John Koch-Northrup --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PICK Assembler Language
I'm not familiar with MvBase, but I meant when PICK was the ONLY O/S on the box, and the kernel was a PICK kernel .. I grew up on Ultimate (Tech-Support, actually), so you can understand my model .. I'll make an exception for something like the old IBM VM implementation of Ultimate, where Ult ran NATIVE under it's own virtal machine .. Does MvBase run as the ONLY O/S, or does it run in an emulator environment, kind-of like Virtual-PC or WINE .. Actually, I guess what I really mean is CAN MvBase run as the ONLY O/S, whether or not it's running in a virtual environment .. -Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, November 05, 2004 6:56 PM To: [EMAIL PROTECTED] Subject: RE: [U2] PICK Assembler Language Back when PICK ran native instead of under Unix (or whatever) .. Pick STILL runs native in the MvBase implementation. If you call it that. It uses the same concepts of workspace, modes, and ABS frames and I'm sure it's the same assembler, read pseudo-assembler. Doesn't actually compile to machine language you know. Will --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PICK Assembler Language
Ok, so I'm a geek. What can I say? :) And for all of the rest of the geeks out there, try this links out: http://www.256b.com/ There was another link out there about making the smalles possible LINUX executable - comparing the size of one generated with a C-compiler vs an NASM compiler vs building it by hand to be the smallest, but I can't find it .. 230 simultaneous serial users plus 22 serial printers on a 75Mhz 486. Funny how earlier the effort was borne on the programmer to be as efficient as he could to make up for the deficiencies of the platform. Now-a-days, the processors are so infinitely fast that they clearly cover up less efficient programming. Therefore, it's easy to forget how far we've come. You know, I was about to cheer your efficiency argument - since I *still* try to be as efficient as possible regardless of the platform that I'm on, but then you went and shot yourself in the foot ;) The server I'm working on is IMHO *very* fast, but we run on SB+, which makes it extremely easy to do tons of extra reads than are actually necessary .. I've also got a few programmers who don't quite understand the downside and performance implications of large DYNAMIC arrays .. Ce la vie .. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.2 ?
We upgraded to UV 10.1.2 while on AIX 4.3.3 and a week later upgraded to AIX 5.1 - we did not experience any problems with the AIX 4.3.3/UV 10.1.2 combination, though that's an admittedly short time. Don -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Saturday, November 06, 2004 7:58 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UV 10.1.2 ? quote who=Michael Polak -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Karl, We in the same boat, and looking to upgrade between Christmas and New Year. We are doing the Universe upgrade first, shaking that out for a while, then will upgrade AIX to 5.3. Lesson 1 from school or hard knocks Never do multiple upgrades at the same time unless you have to. Having worked for vars and having done literally hundreds of upgrades of both OS and DBMS, I agree whole heartedly. Let there be at least 2 weeks, after all the bugs are worked out, before doing the second upgrade. There is one major problem with this when one works for an organization that doesn't do regular upgrades: Sometimes one can't be upgraded without doing the other at the same time because of compatibility issues. Karl Mike - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, November 05, 2004 4:58 PM To: [EMAIL PROTECTED] Subject: [U2] UV 10.1.2 ? Our server is running AIX 4.3.3 and I'm upgrading to 10.1.2. Is there any known gotchas with this combination that I should prepare for, or avoid by holding out for 10.1.4 or newer? Thanks, - -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] - --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -BEGIN PGP SIGNATURE- Version: PGP 8.1 iQA/AwUBQY0BM7Ast3KQK8kYEQJuNwCeJPEw5uLXvUsM6Z4LqWKM7oaoa/4AoPCq oqgSJpExy6Pp0qA1yI9cXaio =OcWC -END PGP SIGNATURE- --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ ** Confidentiality: This message and any attachments are for the addressee only and may contain privileged or confidential information. If you have received this in error, please notify me immediately and permanently delete the message and any prints or other copies. Thank you. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PICK Assembler Language
Actually, I guess what I really mean is CAN MvBase run as the ONLY O/S, whether or not it's running in a virtual environment .. No, it's a windows executable. Brian --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Memo: Re: [U2] PICK Assembler Language
Hi Sean, Before there was this new fangled Universe and Unidata, PICK was a platform independent os/database. It used to run on a variety of platforms from big IBM mainframes all the way down to small minicomputers, and then when PC's were invented (8086 based!!) even on them. This was all achieved by having a PICK Virtual Machine, which was ported to each of these platforms. This VM had a very strange structure, with a number of registers and it's own set of instructions. The language used to program this VM at a low level was called the PICK assembler. I believe this is the language being referred to... hth, Sean W Ferguson [EMAIL PROTECTED] on 05 Nov 2004 18:30 Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:[EMAIL PROTECTED] cc: bcc: Subject:Re: [U2] PICK Assembler Language What is Pick Assembler Language? Burwell, Edward wrote: HSBC Bank plc may be solicited in the course of its placement efforts for a new issue, by investment clients of the firm for whom the Bank as a firm already provides other services. It may equally decide to allocate to its own proprietary book or with an associate of HSBC Group. This represents a potential conflict of interest. HSBC Bank plc has internal arrangements designed to ensure that the firm would give unbiased and full advice to the corporate finance client about the valuation and pricing of the offering as well as internal systems, controls and procedures to identify and manage conflicts of interest. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority. _ This transmission has been issued by a member of the HSBC Group HSBC for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniVerse 10.1.2 bug/error
I upgraded to uniVerse 10.1.2 over the weekend (AIX 4.3.3) and now if I do analyze.shm -x the login count shows 1, or at other times different numbers. There are currently 27 users logged in this system. Anyone heard of this? Is there a fix? We have a routine that uses this output to verify license usage. If I run uvlictool report_lic -a, I get this: Server Edition mode of licensing is in effect. No. Pid, Package Device name IP address Device sub-key 1 31070 3 23030 23680 2 license seats being used by this device. 6 26102 29096 2 license seats being used by this device. 11 33262 20928 2 license seats being used by this device. 12 39132 13 22166 1 license seats are in use. 33 license seats are available. Clearly something's broken as we have 42 licenses: UV: config Configuration data for license number : User limit =42 stuff deleted Any ideas? -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] am I back yet ?
Gerry, Welcome back. - Charles Barouch, Moderator gerry wrote: ? [demime 1.01d removed an attachment of type text/x-vcard which had a name of u2ug.vcf] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse 10.1.2 bug/error
[EMAIL PROTECTED] wrote: I upgraded to uniVerse 10.1.2 over the weekend (AIX 4.3.3) and now if I do analyze.shm -x the login count shows 1, or at other times different numbers. There are currently 27 users logged in this system. I haven't heard of that specific issue, but the following bug fix in the 10.1.4 release notes sounds like it could be related: 6861The uvlictool clean_lic -a command clears licenses in shared memory, but prior to this release, the number of available licenses was not reset correctly. This problem has been fixed. -John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC conflict
I think the problem is with the u2*.* programs. I seem to recall there was an issue with SBClient as the licensing DLL started with U2 and conflicted with Crystal as it assumed that all programs that start with U2 belong to Crystal. (Or something silly like that). IBM renamed the DLL that was causing the issue. Hth Colin Alfke Back in LA Current celebrity sighting count: 1 -Original Message- From: Andy Moore [mailto:[EMAIL PROTECTED] snip Hello usergroup, Just submitted this to IBM support, but I thought I'd see if anyone on here had seen this. One of our customer sites has just had the UVODBC client driver installed and noticed that when this is installed software from another supplier stops working. The removal of the UVODBC driver means the other software works perfectly fine again, without reinstalling it. I have contacted the supplier of the software conflicting with the UVODBC and they have stated that they use the Seagate Crystal Report Writer Version 7 (32 bit) ocx within their class application that's having the problem. They have sent me a list of all the system files installed with their application, which I have listed below, in case there are any conflicts between the UVODBC driver and their system files. snip u2ddisk.dll u2dmapi.dll u2fcr.dll u2fdif.dll u2fhtml.dll u2frec.dll u2frtf.dll u2fsepv.dll u2ftext.dll u2fwks.dll u2fwordw.dll u2fxls.dll snip Looking at some of the files above, it would seem that their software is written in VB6, but other than that there's nothing obvious to me. (the U2 dll's look suspicious, but not sure) If anyone's able to advise on this I would be grateful. We have installed the UVODBC on many sites and this is the first time we have had a problem of this nature. The Universe version is 10.1.3 and the client driver is the version that's supplied with 10.1.3 Their server is a Windows server. Thanks Andy Moore --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC conflict
U2licn.dll is/was the name if that helps. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: 08 November 2004 21:05 To: [EMAIL PROTECTED] Subject: RE: [U2] UVODBC conflict I think the problem is with the u2*.* programs. I seem to recall there was an issue with SBClient as the licensing DLL started with U2 and conflicted with Crystal as it assumed that all programs that start with U2 belong to Crystal. (Or something silly like that). IBM renamed the DLL that was causing the issue. Hth Colin Alfke Back in LA Current celebrity sighting count: 1 -Original Message- From: Andy Moore [mailto:[EMAIL PROTECTED] snip Hello usergroup, Just submitted this to IBM support, but I thought I'd see if anyone on here had seen this. One of our customer sites has just had the UVODBC client driver installed and noticed that when this is installed software from another supplier stops working. The removal of the UVODBC driver means the other software works perfectly fine again, without reinstalling it. I have contacted the supplier of the software conflicting with the UVODBC and they have stated that they use the Seagate Crystal Report Writer Version 7 (32 bit) ocx within their class application that's having the problem. They have sent me a list of all the system files installed with their application, which I have listed below, in case there are any conflicts between the UVODBC driver and their system files. snip u2ddisk.dll u2dmapi.dll u2fcr.dll u2fdif.dll u2fhtml.dll u2frec.dll u2frtf.dll u2fsepv.dll u2ftext.dll u2fwks.dll u2fwordw.dll u2fxls.dll snip Looking at some of the files above, it would seem that their software is written in VB6, but other than that there's nothing obvious to me. (the U2 dll's look suspicious, but not sure) If anyone's able to advise on this I would be grateful. We have installed the UVODBC on many sites and this is the first time we have had a problem of this nature. The Universe version is 10.1.3 and the client driver is the version that's supplied with 10.1.3 Their server is a Windows server. Thanks Andy Moore --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Printing an RTF file from Universe
We are trying to use a Word document as a template. As such, we create the document with tags (eg. XXCUSTNAMEXX ) and then save the document as an RTF. In Universe, we read in this RTF file, change the tags to the data and write this new file out as an RTF. This new file can be opened with Word and printed, however, we would like to be able to print it automatically from within a Universe program. Is there a way to this? When we use PRINTER ON and PRINT, the RTF info(eg. {\rtf1\ansi\ansicpg1252\uc1) is printed out. I receive the daily digest, so I may not answer any follow up questions right away. Thanks, Brian Parker WISL while you work! Voice:519-884-2604 FAX: 519-884-0317 Mail: Waterloo Information Systems Limited 33 Dupont Street East Waterloo ON N2J 2G8 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse 10.1.2 bug/error
Hi Karl, we are running 10.1.2 on AIX 4.3.3 and analyze.shm reports the correct licence count. Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PICK Assembler Language
Are anyone's query processor capable of breaking up an ANDed request and not try test #2 if test #1 fails. Just wondering. It's my understanding that the UniVerse query processor works in this way. Not sure if it still does so if the NO.OPTIMIZE keyword is used, however. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/