Re: [U2] Installing UniObjects on Windows 2008 64 bit
Is the Windows 7 SDK a 64 bit version of the software? If so I would think it would not be able to see the 32bit Unidk to use it. As 64bit versions of software can only interact with the 64bit versions of drivers even if the 32bit drivers are installed properly. Is there some way to make the Windows 7 sdk run as a 32bit environment? I would think that could solve your problem unless your trying to write something to run on windows 7 64bit. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jim.sto...@esc.edu Sent: Tuesday, June 14, 2011 5:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Installing UniObjects on Windows 2008 64 bit Hi, Thanks for the suggestions, folks. So far, I haven't made any progress. I did install the UniData client by right clicking on the installer and using Run As Administrator, while also logged in as an Administrator, with the same results. After David's email mentioned a missing dll and registering them manually, I tried to investigate that possibility. I'm not very familiar with that aspect of Windows systems administration, though, so I don't really know exactly what dlls are required. I looked in the C:\IBM\UniDK\redist\i386\register subdirectory, and made sure that all of those files were present in my C:\Windows\SysWOW64 directory (they were). And then I opened the command prompt (with Run as Administrator), and tried using the REGSVR32 command to register each of those 8 files, including uniobjects.dll. In each case, I got the message DllRegisterServer in c:\windows\syswow64\uniobjects.dll succeeded. However, I still don't see the UnioaifCtrl class in the OLE/COM viewer that comes with the Windows 7 SDK, and I still get the error when I try to call the object in my Domino agent. The one new piece of info that I have is this: When I run (as administrator) the UniData client installer, and then choose the UniDeveloper Kit option, it installs without any visible error as I've mentioned. However, I also tried going into the installer's UNIDK subdirectory, and running (as administrator) the actual setup.exe application for the UniDeveloper Kit. When I do it this way, I do see an error message: * The following files did not self-register or unregister: * 1. C:\Windows\SysWOW64\oc30.dll Error: 0x80040200 * 2. C:\Windows\SysWOW64\oleaut32.dll Access is denied. I do not get that error message when I run the full UniData client installer, though, so I am not sure if that error is because some underlying element that is normally handled by the main installer isn't in available, or if that error is actually occurring all the time and the main installer just isn't reporting it. Since my install isn't working, I'm guessing the error happens all the time, and the main installer is interfering with the error alert. A google search on the error number hasn't helped much. If I try to set the UDK setup program to run in Windows 2003 compatibility mode, it no longer reports an error, but the object still doesn't work or show up in the object viewer. I'll keep looking, but if anyone has any more suggestions, I'd love to hear them! :-) Thanks for the help so far! Jim Stoner ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniOLEDB and Windows 2008/SQL 2008
Yeah! Someone else with the same problem! If your SQL install is the 64bit version there are 3rd party bridge software pieces you can buy to bridge from the 64bit environment to the 32bit driver. I have no real suggestions on what works so I won't mention any names. I think all are going to be fairly expensive. Rocket is working on a 64bit driver but has no ETA yet. If you install the 32bit driver and install a 32bit version of SQL they should work even though you are running a 64bit OS. I say should because we have not yet confirmed it does. We should find out this week if we get time to test it. I suggest calling or emailing rocket software and get on their beta program so you get the 64bit driver as soon as they think they got it working. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Louise Yang Sent: Tuesday, June 07, 2011 5:25 PM To: 'U2 Users List' Subject: [U2] UniOLEDB and Windows 2008/SQL 2008 I'm trying to migrate SSIS packages from Windows 2003/SQL 2005 to Windows 2008/SQL 2008 and all the packages use UniOLEDB provider which doesn't' work with 64-bit Windows 2008. Any suggestions? -Louise Yang ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 64 bit odbc/oledb drivers
I need a Unidata odbc /oledb driver to be installed on a 64 bit SQL server so the the SQL server can connect to Unidata 7.2 The alternative is to setup a linked server on another box that is not 64bit and pull the data through the 3rd system. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: Monday, May 23, 2011 4:36 PM To: 'U2 Users List' Subject: Re: [U2] 64 bit odbc/oledb drivers Hey Jeff, I'm not sure what you mean and don't remember what platform you're on. Are you just looking for a 64-bit Windows ODBC driver for SQL2008? If so they are available from Microsoft and DataDirect. Regards, Glen Batchelor IT Director/CIO/CTO All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Monday, May 23, 2011 4:13 PM To: U2 Users List Subject: [U2] 64 bit odbc/oledb drivers Has anyone got ODBC / OLEDB drivers to help link SQL2008 running on 64 bit to Unidata? Jeffrey Lettau ERP Systems Manager polkaudio Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] 64 bit odbc/oledb drivers
Has anyone got ODBC / OLEDB drivers to help link SQL2008 running on 64 bit to Unidata? Jeffrey Lettau ERP Systems Manager polkaudio Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Trigger questions
Does anyone have EDA working to SQL yet? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, March 30, 2011 12:21 PM To: U2 Users List Subject: Re: [U2] Trigger questions This is what EDA is for isnt it? On Wed, Mar 30, 2011 at 12:10 PM, Kevin King precisonl...@gmail.com wrote: Unidata or Universe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 soap server on startup
Sorry, Windows I saw the commands in the manual for runsoapserver and stopsoapserver. This does allow for starting and stopping without using the tools. The link does help explain where things are operating from, thanks. I guess the question is, can I make the runsoapserver a service? Or would it be starting the instance of javaw as a service? Or am I stuck having to login and manually start the soapserver? If I have to just run it manually to insure it is up, then it's not a big issue, there are other things I need to do this with. Thanks for the feedback and info. Every little bit helps. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, February 24, 2011 2:41 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] U2 soap server on startup See the Webservices.pdf in the U2 Documentation. Specifically Deploying Web Services...If in Windows create your own scheduled task or UNIX - a crontab job. Also, from the archivesthis may help if you like to know what's going on behind the scenes (this pre-dates the above chapter being published in that PDF guide): http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24130.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Thursday, 24 February 2011 8:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 soap server on startup I just noticed a potentially bad thing. The soap service will only run if you run it manually after logging into the server. If I log off of the server the soap service stops running. I'm guessing the problem is that it is not actually running as a service, but I don't see how to make it run as a service. Does anyone have any suggestions on how to enable a soap server to run on startup? Jeffrey Lettau ERP Systems Manager polkaudio ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 soap server on startup
That looks great, thanks. I think I got more then I need at this point. Windows 2008 scheduler has a trigger on startup option , so once I get the JRE_home system variable established I should be able to get the command lines to run and everything set. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Thursday, February 24, 2011 10:30 AM To: U2 Users List Subject: Re: [U2] U2 soap server on startup Look at this source-forge project: http://sourceforge.net/project/shownotes.php?release_id=60527 It allows you to wrap any java server provided the server does not try to get interactive (the usual caveats). Also, be aware that this will then run in the context of the machine user, so you don't have mapped drives (unless you set them up) and you may have permissions issues (integrated security to SQL Server won't work). HTH, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Thursday, February 24, 2011 6:08 AM To: U2 Users List Subject: Re: [U2] U2 soap server on startup Sorry, Windows I saw the commands in the manual for runsoapserver and stopsoapserver. This does allow for starting and stopping without using the tools. The link does help explain where things are operating from, thanks. I guess the question is, can I make the runsoapserver a service? Or would it be starting the instance of javaw as a service? Or am I stuck having to login and manually start the soapserver? If I have to just run it manually to insure it is up, then it's not a big issue, there are other things I need to do this with. Thanks for the feedback and info. Every little bit helps. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, February 24, 2011 2:41 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] U2 soap server on startup See the Webservices.pdf in the U2 Documentation. Specifically Deploying Web Services...If in Windows create your own scheduled task or UNIX - a crontab job. Also, from the archivesthis may help if you like to know what's going on behind the scenes (this pre-dates the above chapter being published in that PDF guide): http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24130.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Thursday, 24 February 2011 8:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 soap server on startup I just noticed a potentially bad thing. The soap service will only run if you run it manually after logging into the server. If I log off of the server the soap service stops running. I'm guessing the problem is that it is not actually running as a service, but I don't see how to make it run as a service. Does anyone have any suggestions on how to enable a soap server to run on startup? Jeffrey Lettau ERP Systems Manager polkaudio ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 soap server on startup
I just noticed a potentially bad thing. The soap service will only run if you run it manually after logging into the server. If I log off of the server the soap service stops running. I'm guessing the problem is that it is not actually running as a service, but I don't see how to make it run as a service. Does anyone have any suggestions on how to enable a soap server to run on startup? Jeffrey Lettau ERP Systems Manager polkaudio Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
I had to redo the FTP scripts when we moved to 7.2 on a 64bit box due to the security of Windows. I had to go from a batch file that called a txt file for the commands to a single batch file that executed all of the commands. I enter this text in a .bat file and just call it from the paragraph. Nothing fancy. The trick is that the batch file is making the DAT file so there are no windows security issues. @echo off echo user YOURUSERNAME ftpcmd.dat echo YOUPASSWORD ftpcmd.dat echo bin ftpcmd.dat echo put E:\tmp\FILETOSEND.txt FILENAMEATSITE.txt ftpcmd.dat echo cl ftpcmd.dat echo qui ftpcmd.dat ftp -n -s:ftpcmd.dat www.WEBSITE.com del ftpcmd.dat Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, February 17, 2011 7:48 PM To: U2 Users List Subject: [U2] Frustrated with Rocket / Unidata 7.2 About a week ago I upgraded Unidata 7.1 on Windows XP/32 to Unidata 7.2 on Windows 7/64. Everything I need in Unidata seems to work fine on this release with one notable exception: Unidata 7.2 on Windows will no longer properly execute the Windows ftp program. Rocket support has basically said that in this version they changed the telnet server so that it can only run fully stdin/stdout compliant programs in the shell. Because the Windows ftp program isn't exactly stdin/stdout compliant, it is no longer a functional PCPERFORM program. Even if the ftp program is scripted to connect, transfer, and exit with no additional inputs or outputs, the ftp program will still fail. Of course, in this case if there's a put in the commands it'll fail after writing a zero byte file, potentially overwriting something. I could be frustrated with Microsoft because, after all, it's their program that's failing, I'm more frustrated with Rocket. While it's frustrating to have a past ability removed it's more frustrating to have received absolutely zero warning from Rocket that this could happen. I've searched the docs for 7.2... can't find a word about this change. (Hey, and I could be missing something; that's certainly a possibility.) It's fortunate that this install isn't a big production system, but what if it was? There are several production systems running Unidata on Windows, so if any of y'all are using ftp or any OS commands that may not meet Rocket's muster, please be aware of this change in 7.2. BTW, for me the fix was to use WinSCP (in command line mode) instead of Microsoft's FTP program. So far it seems to work just fine though the scripting is a bit different from Microsoft's ftp client. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
Yes, it appears to me that the issue I experienced was related to updated security in win2008, not in unidata. I've also noticed that every upgrade breaks something. Sometimes you get lucky and things run for 10 years, then one day, BAM! A program stops working after you upgrade the database. It's the nature of the job. Things change. Things break. Things need to be fixed. That is what testing is for. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, February 18, 2011 10:46 AM To: U2 Users List Subject: Re: [U2] Frustrated with Rocket / Unidata 7.2 Jeff, so you're saying that if the ftp script was created by the batch file instead of being created by something else, this works? Gee, that could be the entire issue right there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Is the UCI.config file setup on the 2nd server? Does the SQL server recognize the driver as a valid provider under linked servers? Under the linked server in properties there should be a security tab that you need to fill in with the login and password to connect to remote systems. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, April 03, 2010 7:31 PM To: U2 Users List Subject: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB I have a customer who is trying to configure a couple of SQL Server instances to access Unidata 7.1 on AIX via OLEDB by setting up Unidata as a linked server in SQL Server. The exact same OLEDB (and ODBC) driver is installed on both systems and is configured identically between the two. One system can access the Unidata information in a table (that has been configured via VSG) but the other cannot. The root question is why can one server access Unidata and the other cannot, especially when the two are configured identically?. One thing I've noticed is that the linked server configuration doesn't include any authentication information for OLEDB, but clearly there has to be some authentication somewhere, right? And with the presence of ODBC in the SQL Server provider string for the linked server, does that mean that OLEDB uses the ODBC connector to access Unidata? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I'm looking for theoretically ?
Reminded me of one of my favorite quotes. When I am working on a problem, I never think about beauty but when I have finished, if the solution is not beautiful, I know it is wrong. R. Buckminster Fuller Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Garry Smith Sent: Thursday, March 18, 2010 4:08 PM To: U2 Users List Subject: Re: [U2] I'm looking for theoretically ? Reality is the murder of a beautiful theory by a gang of ugly facts. -- RobertGlass http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Visual Schema Generator Options
http://www.rocketsoftware.com/u2/pubs/library/ Most manuals you can get online. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Tuesday, February 16, 2010 3:46 PM To: 'U2 Users List' Subject: Re: [U2] Visual Schema Generator Options Not sure if there are many ways from the command line to update all of the schema info - though there are likely some. I do have a pdf document Using VSG and the Schema API (vsg Schm.pdf) that IBM sent me. It documents all the subroutines that have been setup to do the same things as VSG does (likely/hopefully VSG simply calls these routines). It looks like it's under the Accessing UniData from the Client section of the documentation. Hth Colin Alfke Calgary, Canada -Original Message- From: Kevin King Are there any command line verbs that update the same things as the VSG? For example, if I have a file that was previously setup in the VSG and someone adds a new field and I just want to add that new field to the base table, subtable, or view, can this be done using command line tools? I know about CONVERT.SQL for building the base table but ... what about views, subtables, and incremental changes to the schema? -Kevin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad]
You may not want to do this due to volume of data your trying to pull, but... Have you tried setting up your UD5.2 server as a linked server in SQL, then creating views to your linked server. Then use SSIS to pull from the views, that way it doesn't know it isn't a SQL data source? Performance isn't bad if your limiting your I-desc and keep the data to single files in UD. Also use indexes in your UD views to limit your data. You can't pass variables for data selection this way. You can limit data by day using @date-99 type i-descriptors or just write a quick program to pull your data to a temp file, then pull the file for updating things incrementally for Cognos. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, January 14, 2010 3:31 AM To: U2 Users List Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS [ad] Thanks Tony, but I think I will just wait until I've convinced management to approve the upgrade to 7.2 I know that release can talk to SSIS. We are talking hundreds of files here for that conversion and maybe thousands of Oracle tables, and I don't think I'm going to create classes for every attribute in every UniData file and SQL statements to extract the data, translate and load it into Oracle tables. With SSIS it's nearly all just drag and drop - no code writing required - a proper ETL tool! Unfortunately it doesn't seem to be able to connect to UD 5.2 because the OLEDB versions from Informix and Microsoft don't want to talk to each other. I had hoped somebody here could tell me what string literals are supposed to be and why I can't get them. In the meantime they can carry on working with their spreadsheets :-) And maybe I can convince them to send me to school again, so I can understand all the buzz-words you throw around. Mecki Tony Gravagno wrote: From: Mecki Foerthmann Thanks Tony and Peter, but I don't think yet another piece of software is what I need. Your product might be useful for some of your clients, but I don't think it will help solve my problem. That's funny. I don't have an application and there is no real way to categorize our clients, except that they're mostly MV developers who had a problem to solve. Many of our clients have come from this forum. I think you're missing the point of the blog. It wasn't to sell a product (that one isn't ready yet anyway) but to explain how I'm able to create a wide range of solutions based on the way I approach problems. If you continue to think of each problem you present here as a nail, the only solutions you're going to consider are the ones that look like a hammer. Think differently and you won't need to buy other people's solutions, you can probably come up with your own. (That said, the tools I've chosen help me to do what I do, and because I'm happy with those tools I've chosen to sell them too.) I don't want to update any MV files, just load some data into a relational database every night, preferably as cubes. Setting the MV files up as SQL tables is not a problem in UD either. I've already done that and have a reasonably easy to use tool for that in Avante. The point of my blogs is that you don't need to do that, and FWIW, this forum is frequented by people who have had problems doing that. So I discourage the approach. I've even written Basic code to flatten a file with large multivalues because DTS UniSQL in UD 5.2 can't handle them properly. And you don't need to flatten files either. :) This is all trivial stuff. All I want is a cheap ETL tool that works with UD 5.2, so I can build a datawarehouse in Oracle and write reports using Cognos. mv.NET Solution Objects (one of the libraries in the package and not currently used in the solution described in the blog) allows you to create strongly typed classes for any application. You can use these with other applications that can make use of business rules via an Object Relational Model (ORM). So the external environment doesn't see Accounts or Files or Dicts, it seems a Customer class and properties that you've chosen to share with specific environments, like Name and City. My approach would be to create an SDK for Avante (ManFact, Dataflo, CUBS, Datatel, SHIMS, or any MV application), then create an interface for your external database of choice, then create a bridge between them. Again (refer to my blog) note that the approach here isn't to connect X to Y but to get interfaces for X and Y and then connect them in the middle. Then you can use your X and Y interfaces with any other project. If you connect X directly to Y now, you'll be here next month asking about W and Z. I have to use Oracle and Cognos, I don't have any say in that matter. That's fine, so ETL your data to Oracle as I've
Re: [U2] Cubes
http://www.mits.com/index.htm for U2 http://www.microsoft.com/sqlserver/2005/en/us/Analysis-Services.aspx for MS SQL http://www-01.ibm.com/software/data/cognos/ for everything else Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Thursday, January 14, 2010 10:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] Cubes I wasn't familiar with the term cube and I did some research. I found this. The ideal structure for such storage is a star schema, realized as a multidimensional cube. In such a structure, tables are related not in the relational manner of an RDBMS, but by a central key table that defines the dimensions along which data will be gathered from logically-related tables. For this to work, data must be denormalized. That sounds a lot like an MV database. Wouldn't MV databases be the natural platform for data mining? Maybe I am oversimplifying. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you do EDI?
Flat files out of and into Unidata using software vendors formats for this. But for the EDI portion we use TIE commerce eVision. It's a bit expensive, but works great with notifying you if anything goes wrong and uses Lexicom by Cleo for the communications piece to send and receive AS2 or sFTP. The top of the line product for Tie will actually monitor directories and trigger actions real time when items hit your system. They offer consulting and tech support is top notch. Heck of a lot better the writing your own programs. Although that does work and is the least expensive solution. But when a lot of money is riding on those orders, it's worth spending a bit to insure things run smooth. Jeffrey Lettau ERP Systems Manager polkaudio From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman Bauer Sent: Friday, June 12, 2009 9:25 AM To: U2 Users List Subject: [U2] How do you do EDI? We have a very painful, labor intensive way that we do EDI. From the way we create the X12 documents to our users inputing information to be sent in an EDI message. I would like to start evaluating alternative methods to our current practices. All suggestions welcome. Norm Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Strange happening...
Can You SELECT File TO 1 To assign the selection to a list number, as the default list number is 0 it would cut down on the chances of the list being used by something else? Just make sure at the end you PERFORM DELETE.LIST 1 so it's not hanging around. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Friday, February 27, 2009 12:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Strange happening... In the example of code you have, the loop will exit if your key (variable ID) is equal to an empty string or a string that can be evaluated to zero for example values like these: 0E1,0E10, 0E100 (on Universe) (empty string) Will make the loop end: SELECT FILENAME LOOP READNEXT ID ELSE EXIT WHILE ID DO CODE CODE with GOSUB CODE CODE REPEAT Try: SELECT FILENAME LOOP WHILE READNEXT ID CODE... REPEAT - Original Message From: George Gallen ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Friday, February 27, 2009 10:21:19 AM Subject: RE: [U2] Strange happening... that wasn't the case. The id was combination of 13 letters and numbers. The strange part was where the while/do seemed to kick in. The item was read from the file without a problem 3-4 lines of code execute as expected it then executed a gosub, but when it returned, it dropped out of the loop the id variable was never modified. Strange. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Friday, February 27, 2009 9:39 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Strange happening... If the ID equates to false it will exit - i.e. a record with ID 00 Edward -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 27 February 2009 14:26 To: Ardent Subject: [U2] Strange happening... ok...I found this code snipit (REALITY FLAVOR) SELECT FILENAME LOOP READNEXT ID ELSE EXIT WHILE ID DO CODE CODE with GOSUB CODE CODE REPEAT What was happening was the loop was exiting early, but it was exiting after the CODE with GOSUB line was executed. What struck me was why there was a While DO as well as an EXIT in the loop? while nothing in the CODE or GOSUBs modified the ID, would having both the WHILE/DO and EXIT cause some kind of problem? After I removed (commented out) the WHILE/DO line, the program ran as expected and processed the 100,000 records, (whereas before it stopped after 6). George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. --- --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all
RE: [U2] UniData Keys
if all your looking for is a unique ID then can't you generate a GUID as the ID? this is more of a question then an answer. not that you would be able to use this to sort or order the entries. Jeffrey Lettau ERP Systems Manager polkaudio From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) [EMAIL PROTECTED] Sent: Thursday, August 28, 2008 7:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData Keys -snip- - in this instance we use unique ids generated using date, system time in milleseconds (system(12) in udt) and pid combined together Symeon. Not a bad idea, however you may encounter problems of losing data in these 2 areas: 1. As processors get faster, the difference in execution time shortens and it can be possible to generate the same key during the same millisecond. Adding a NAP 1 in my simulated testing eliminated the duplicates. On one implementation of Pick (Altos?) I recall the resolution of the system(12) function was only a second. 2. At least one time a year (in my timezone) the clock is turned back one hour and it would be possible to overwrite existing keys during that hour. -Troy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: UNIDATA 7.1 performance measures
All the /3gig switch does for you is allow more memory to be available. You would still need to make settings in Unidata to take advantage of the additional memory. Unless I'm getting the /3gig switch confused with the SQL settings. I'd also start with turning off hyper threading on the processors if you're using that just to see if it helps. Although I'm not sure if 7.1 has these kinds of problems or not. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Smith, Robert Sent: Friday, March 28, 2008 11:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIDATA 7.1 performance measures From: Smith, Robert Sent: Thursday, March 27, 2008 11:37 AM To: u2-users@listserver.u2ug.org Subject: UNIDATA 7.1 performance measures Good Morning, We are a UNIDATA shop and presently we are struggling with identifying the best way to increase the performance level of our environment. We presently are running UD on a Windows Enterprise server (SP2) with 16gig of ram and 8 - 3gig processors. We have read through some MS Knowledge Base articles that suggest a possible performance increase if we use the /PAE and /3GB boot.ini switches. We were wondering whether anyone has deployed these settings before and if there were any problems that resulted...with either the OS or database. Does anyone have any suggestions regarding ways to increase UD performance levels in a Win2k3 environment? Thanks in advance, Rob Smith Philadelphia University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] OCONV DATE ISSUE.
The question is when I do OCONV(@DATE, 'DM') I get 02 but when I do OCONV(@DATE, 'DM')-1 I get 1 not 01. Why? And how do I get these to match? The reason for this is I'm trying to do this as a i-desc But my dates don't equal because of the weird oconv issue. IF OCONV(@DATE, 'DM') - 1 '1' THEN OCONV(@DATE, 'DY') - 1 : '12' ELSE OCONV(@DATE, 'DY') : OCONV(@DATE, 'DM') - 1; (OCONV(Inv_So_Date,'DY'):OCONV(Inv_So_Date,'DM')); IF B$Record_Type = 'BK' THEN IF @1 = @2 THEN QTY ELSE '0' ELSE '0' I'll take a better solution if someone has it since I have to do this for 36 months making 36 i-desc to put it in columns for my output that will need to be grouped and summed. Jeffrey Lettau ERP Systems Manager polkaudio Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV DATE ISSUE.
Thanks, I did OCONV(@DATE, 'DM')-0 to make the other date the same or I should answer that they are now both numeric. Rather than formatting. Data types changing behind the scenes are not always obvious when your working on something. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: Friday, February 08, 2008 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV DATE ISSUE. Hi Jeff, The question is when I do OCONV(@DATE, 'DM') I get 02 but when I do OCONV(@DATE, 'DM')-1 I get 1 not 01. Why? And how do I get these to match? OCONV returns a character string result. Using it in an arithmetic expression converts it to a number. Hence 02 minus 1 is 1, not 01. There are various ways to get what you want. One would be FMT(OCONV(@DATE, 'DM')-1, 'R%2') Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV DATE ISSUE.
THAT IS WHAT I WAS LOOKING FOR! Rather than doing this... IF OCONV(@DATE, 'DM') - 1 '1' THEN OCONV(@DATE, 'DY') - 1 : OCONV(@DATE, 'DM') - 1 ELSE OCONV(@DATE, 'DY') - 1 : OCONV(@DATE, 'DM') - 1; (OCONV(Inv_So_Date, 'DY') : OCONV(Inv_So_Date, 'DM')-0); IF B$Record_Type = 'BK' THEN IF @1 = @2 THEN Qty ELSE '0' ELSE '0' I can do IF B$Record_Type = 'BK' THEN IF OCONV(ADD_MONTHS(@DATE,-13),'DYM') = OCONV(Inv_So_Date,'DYM') THEN Qty ELSE '0' ELSE '0' That is s much smaller. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Alfke Sent: Friday, February 08, 2008 1:07 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OCONV DATE ISSUE. In UD you can look at @MONTH and ADD_MONTHS(date,nbr) which should help having to do the gymnastics Martin and Bryan brought up hth Colin Alfke Calgary Canada -Original Message- From: Lettau, Jeff The question is when I do OCONV(@DATE, 'DM') I get 02 but when I do OCONV(@DATE, 'DM')-1 I get 1 not 01. Why? And how do I get these to match? The reason for this is I'm trying to do this as a i-desc But my dates don't equal because of the weird oconv issue. IF OCONV(@DATE, 'DM') - 1 '1' THEN OCONV(@DATE, 'DY') - 1 : '12' ELSE OCONV(@DATE, 'DY') : OCONV(@DATE, 'DM') - 1; (OCONV(Inv_So_Date,'DY'):OCONV(Inv_So_Date,'DM')); IF B$Record_Type = 'BK' THEN IF @1 = @2 THEN QTY ELSE '0' ELSE '0' I'll take a better solution if someone has it since I have to do this for 36 months making 36 i-desc to put it in columns for my output that will need to be grouped and summed. Jeffrey Lettau --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IBM web site
I'll throw out a guess that they are making some changes to the layout and everything is just out of wack. I tried to get to www.ibm.com and got nothing with it trying to access http://www.ibm.com/sandbox/homepage/version-a/ Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: Thursday, December 20, 2007 11:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] IBM web site Hopefully nothing sinister here but has anyone else noticed that the U2 products appear to have vanished from IBM's product list on their web site. Support and training are still available but I cannot find any reference in the areas one would visit as a prospective purchaser. Added to the absence of IBM from the latest published list of exhibitors at the 2008 Spectrum conference, this gives what is hopefully the wrong impression. Meanwhile, to answer the question I was trying to resolve, does anyone have an up to date end user price for UniVerse? Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- 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] Time Travel
Maybe the US government isn't allowing the messages to process faster because they need to make sure they are safe for us to read. Because violating our freedoms is necessary to protect our freedom. I won't say anything else for fear of this ending up in my government file. 10:33am EST go! Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, November 27, 2007 8:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I've got absolutely nothing against Australians as a matter of fact I admire them. If the way they are presented to us back here is correct, they remind me of the way people were in this country fifth years ago but with some added technology. People that believe in life, liberty, and the pursuit of happiness, are willing to die to defend it, and to defend their country. Not a bunch of complainers that can find nothing better to do than to complain about their email coming in an hour instead of minutes when it could have come from the other side of the world. Let the flames begin. Jerry -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 4:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel C'mmon Jerry ... what have you got against Australians and besides, if it WAS located on this side of the Pacific Ditch, based on current performance, you would see DAYS between posts, because it typically takes an hour or two before I see posts too Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, 27 November 2007 6:33 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's something different happening that's causing the lags. We often see as many as 200 emails a second going out of our server, which is an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and running fedora core 4 (old...). Our group members get their emails back within seconds, literally. I send an email to this group, and it sometimes takes an hour or so before I see it come back to me. I send an email to one of my groups at home, and I get it back within seconds. Now then, with that said, I've also added bulk_mailer to my email group server so maybe that speeds things up a great deal. I don't know. I did it so I would quit getting the annoying 'too many email connections from your server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero, juno, gmail, . . . ad infinitum of the 'big' email hosts. My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server... I don't know why, they just aren't the same. Karl quote who=Symeon Breen Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd have to redesign the methods under which the internet manages and routes mail. - Charles Barouch, Moderator --- 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/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe
RE: [U2] Need detailed instrutions for querying from SQL Server 2005 Management Studio
If you have the linked server setup then use the openquery command. SELECT * FROM OPENQUERY (UniDataServer, SELECT * FROM vsgOrderView WHERE OrderID =''2921479''') I've found that when doing the setup if you click test it kind of hoses up the connection. Try doing it without checking it and just see if it works. But the openquery is usually the fastest and easiest way to get data. I just make a view containing the select I want. But don't ask about writing things back. I don't do that. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victoria G. Carson Sent: Thursday, November 08, 2007 9:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Need detailed instrutions for querying from SQL Server 2005 Management Studio Looking for help with connecting via OLE DB to query a U2 database from SQL Server 2005 as the tool for sql queries and inserting data into a sql database. If anyone can point me to somewhere that I can obtain detailed instructions for how to troubleshoot a connection, I will really appreciate it! Have attempted to connect using the Import/Export and via Linked server. I have the Universe ODBC client installed on the SQL server along with UniOLEDB. Two problems: Problem #1) Import Wizard: Choose UniOLEDB Provider, test connection succeeds on Data Link Properties Window, but get the following error message when I click Next after choosing UniOLEDB as the data source: TITLE: SQL Server Import and Export Wizard -- Cannot get string literals from the database connection Provider=IBM.UniOLEDB.1;Password=;Persist Security Info=True;User ID=lmsodbc;Data Source=LMSODBC. -- ADDITIONAL INFORMATION: Object reference not set to an instance of an object. (DTSWizard) -- BUTTONS: OK -- Problem #2) Would like to set up access to a Universe database via Linked Server (I have never set up a non-sql linked server before). I don't see UniOLEDB on the list of providers. Need help with filling in the Other Data source information in the Linked Server Properties window: Provider, Product Name, Data Source, Provider string, Location, Catalog, and any Security or Server Options. Thanks! --- 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] I *was* Going to the New York U2U Class...
That's how I'm reading it. You would have to work for 30 days within a year period for it to apply. So a convention for 7 days wouldn't apply. But 5 Conventions for 7 days each would. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Wyatt Sent: Friday, October 12, 2007 11:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] I *was* Going to the New York U2U Class... This is incorrect, per my research... If the convention or conference had a duration of 30 days or more, yes... Please refer to http://www.wcb.state.ny.us/content/main/Small_Business/outOfStateEmp_com pLaw .jsp Regards, Bob Wyatt Ashwood Computer, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Friday, October 12, 2007 10:05 To: u2-users@listserver.u2ug.org Subject: [U2] I *was* Going to the New York U2U Class... But I just found out that if any Employee is 'working' in New York, you have to have a New York Workers Comp policy. This is a new ruling, and I just called Albany compliance (866-298-7830) to find out if attending a conference 'counts' as employment duties/working. And they said yes. So - I for one will not be able to be attending since I'm not going to add New York Workers Comp to attend a conference! And I thought it should be 'known' that if you are attending as an 'employee' or sending an 'employee', you may want to find out if you need to have a New York Workers Comp policy in place. Hope I can make the California show now!! David W. --- 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/ This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Query Optimizer Documentation
I would like to put a vote in for better documentation on this. I've struggled with this in the past and continue to be frustrated with the trial and error method of getting the best performance out of the systems. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Sunday, September 09, 2007 9:30 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata Query Optimizer Documentation Kevin, Is there an enhancement request for better documentation on UD's query optimizer erupting here? cds From: Kevin King On 9/8/07, Dave Davis [EMAIL PROTECTED] wrote: Testing with the actual data appears to be the best way of figuring this stuff out. With all due respect, I don't have the time nor desire to figure out something that should be documented somewhere. Even if I did have the time, the best possible answer via this method would inevitably be supposition rather than fact, possibly leading to dangerous errors in assumption. --- 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] UniOledb error out of memory
I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error out of memory I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider IBM.UniOLEDB for linked server The provider ran out of memory Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- 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] UniOledb error out of memory
No I haven't. But without the -g setting, it should reserve 256 megs and I can't imagine that the oledb driver needs more then this to run. If you happen to have a system that isn't in production to play with the settings, then this may be something to try. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Friday, July 27, 2007 10:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error out of memory Have you had any success playing with the '-g' startup parameter? Regards, Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Friday, July 27, 2007 6:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniOledb error out of memory I've had this exact problem. The only solution is to stop and start SQL to clear the memory. It appears to be a problem with SQL2005 wanting to hold onto the memory on the server because it feels it needs it and then the unioledb simply doesn't have enough memory available to it to run because SQL refuses to let it go. I've talked with Microsoft about this and they claim that it's not their problem because SQL is doing what it was designed to do and IBM says it's not their fault that SQL won't play nice and share some memory. If I'm wrong about any of this please feel free to correct me. And if anyone knows the answer to this problem I would love to know it. As a side note on this. We usually have this problem when testing out a new query and it isn't running as efficiently as we would like. Once it runs fast enough and is in production we haven't had any problems. Limiting the memory to SQL just appears to cause the problem faster as in using the linked server I'm guessing it's trying to load the unioledb driver into the memory space available to SQL? Or SQL just runs out of memory faster? I'm not sure what is happening, but also increasing the memory to 3 gigs also doesn't solve the problem or give more time before the error occurs. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, July 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniOledb error out of memory I am using unioledb (dll version 1.4.7.7137) as a linked server from SQL Server 2005. Most of the time it works just time. From time to time when there is a long running query, the select errors out with the message OLE DB provider IBM.UniOLEDB for linked server The provider ran out of memory Has anyone ever seen this before? Are there any solutions? Thanks for your help in advance, Noah Hart Sr. IT Analyst Lipman Insurance Administrators, Inc. CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. --- 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/ --- 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] Garbage Characters
I think you could use ctl-H to backspace. Don't ask me why my brain is returning that result, I have auditing turned off. I remember having that problem on an old HP system at one point and I think that worked in place of backspace until you logged in. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Bell Sent: Wednesday, April 18, 2007 1:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Garbage Characters It could be that U2 Device licensing turned on and are not using an Enterprise version of U2. Accuterm will send a handshake to negotiate the device licensing issues that will appear as several characters on your screen if you are not using a device licensed equipped version of U2. This also happens if you have disconnected an reconnected because U2 only recognizes the handshake when you first connect. To check for the device licensing option click on the Accuterm menu bar, Tools, Select settings from the drop down menu, then the Connection tab of the multi-tabbed screen. Click on the Advanced button and see if U2 Device Licensing is checked. Note: You must have a session open to get to this option screen. Joseph Ruiz wrote: Sometimes when I open an Accuterm 2k2 session and start A program and I need to back space I get garbage characters. Does anyone have any idea how to solve this problem? Thanks, Joe --- 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/ This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Gigabit Broadcom cards.
I know there is some issue with using Gigabit Broadcom cards with Unidata. Is anyone running their Unidata Server Windows 2000 on a Gigabit network without issues? What card do you use? Are there settings to eliminate what ever the issues are? Running from an IBM net server. There was a discussion a while ago on the usug site but I can't pull that up now to check. Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ibm.unioledb not releasing memory on server.
I've gotten SQL 2005 to connect to Unidata 6.0 as a linked server. I then setup a view using openquery to access a view. Next I have the view being used to create a SQL2000 cube in analysis services. Once the cube is built the system doesn't release the memory being used. Is there a setting I need to do or something with the driver that is causing this?Is this a known issue with this version on Unidata and the ibm.unioledb driver? (IBM UniData ODBC Driver 3.01.04.7036) Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Linked server fails when using Analysis services
Got it figured out. I found a similar issue with Oracle and the solution was to check the Allow inprocess box on the Provider options under Linked Servers, Providers in SQL. Make sure you reboot and then it appears to be working. Now I don't have to store my data in SQL to use the Analysis services to build cubes. Thanks for the suggestions. That all checked out ok and the views were working, just not the Analysis services part. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vance, Kathy Sent: Thursday, May 11, 2006 1:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Linked server fails when using Analysis services I run into the similar situation while using linking Universe server in SQL. Eventually I got it fixed is: 1) check the User account and make sure it has right to read the UniVerse tables. 2) make sure the column name used in UniVerse view is not uniVerse reserved word. If you could view the data from Excel via ODBC, most of time it should work in SQL server. Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, May 11, 2006 10:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Linked server fails when using Analysis services I'm trying to build a cube in Analysis services in MS SQL. I've setup my data source to the local database and I'm choosing a view that uses an openquery to Unidata. The view works without issues, I can browse my data inside the analysis services, but when I try to actually process the cube I get this error. Data source provider error: Cannot get the column information from OLE DB provider IBM.UniOLEDB for linked server M2K.;42000;The OLE DB provider IBM.UniOLEDB for linked server M2K reported an error. Access denied.;42000; Time:5/11/2006 10:34:05 AM I'm guessing that there is a setting I can add to the linked server to allow the column information being read? I don't want to take the time to pull the data into a table in SQL since it is a load of data and isn't necessary to archive in SQL. Can't I just use the linked server with a view and build my cube? For my test I'm only pulling the top 9 rows so it's not like it's timing out or anything. Jeffrey Lettau ERP Systems Manager polkaudio --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Linked server fails when using Analysis services
I'm trying to build a cube in Analysis services in MS SQL. I've setup my data source to the local database and I'm choosing a view that uses an openquery to Unidata. The view works without issues, I can browse my data inside the analysis services, but when I try to actually process the cube I get this error. Data source provider error: Cannot get the column information from OLE DB provider IBM.UniOLEDB for linked server M2K.;42000;The OLE DB provider IBM.UniOLEDB for linked server M2K reported an error. Access denied.;42000; Time:5/11/2006 10:34:05 AM I'm guessing that there is a setting I can add to the linked server to allow the column information being read? I don't want to take the time to pull the data into a table in SQL since it is a load of data and isn't necessary to archive in SQL. Can't I just use the linked server with a view and build my cube? For my test I'm only pulling the top 9 rows so it's not like it's timing out or anything. Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] image collection for storage...
You may want to consider a security camera. Sounds a bit odd, but some do run on Linux and can be remotely controlled, plus have the ability to take snapshots on demand. I was looking at them for my sisters house so I can't remember the exact name or models I've looked at. The only draw back may be price. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 9:46 AM To: Lettau, Jeff; u2-users@listserver.u2ug.org Subject: RE: [U2] image collection for storage... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Lettau, Jeff Sent: Thursday, March 02, 2006 9:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] image collection for storage... Don't most digital cameras come with software that you can just click on the screen utility and have the camera take a picture? I was thinking of just something very simple. An inexpensive camera with the software. I have a Kodak Easyshare camera at home, which does not have that ability :( As soon as you hook up the USB, it goes into PC mode. This is now going to be a little project of mine for home devlopment I'd like to run this from Linux, so using the windows software will be a problem. I like the idea of just pulling the file off of the memory card once the camera takes the picture, then rig up some sort of actuator that can be controlled to push the button to take the picture. Put the camera on a tripod pointing down at a white desk and you just place the paper or document under it. Set the camera as a web cam and click on to capture a still image. This is very similar to the old hardware that banks would use to store documents to microfiche. I'd like to setup some sort of copybox that would contain a barebones PC as well as the camera with either a wired or wireless lan and be used as a standalone piece of equipment. Jeffrey Lettau ERP Systems Manager polkaudio George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Simple OT question
SQUARE D is a manufacturer of electrical components like transformers. http://www.networkcable.com/cables/powercords.cfm?ToggleId=1 I think you are looking for IEC-320-C13? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: Monday, February 06, 2006 10:31 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: Re: [U2] Simple OT question Mark, I asked our PC techs here and they tell me it's referred to as a Square-D (pronounced Square Dee) connector. HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/05/2006 08:40:45 AM: With every computer (and other) connector having a 'name', ie cat-5,db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- 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] Fast file transfers
This may sound silly but the fastest way we have found is to back it up onto tape and then load the data from the tape to the new machine. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Monday, December 26, 2005 8:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] Fast file transfers Greetings, Anyone come up with a really clever way to move a great deal of data from one machine to another (completely different Multivalue Platforms; jbase - Universe) all within the space of a weekend? We've tried some of the telnet programs that have multivalue specific file transfers ... take too long. Writing something on our own now -- but thought I'd check to see if one of you other smart guys or gals have solved this problem. Cheers and TIA, Susan --- 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] Upgrading from Unidata 3 to Unidata 7
MKS tool kit works great for this. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darren Macdonald Sent: Thursday, December 22, 2005 4:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] Upgrading from Unidata 3 to Unidata 7 We have been running (in the dark ages) on Unidata 3.3 and 5.2 (on SGI Irix) for a number of years, and are considering moving up to Unidata 7 - ideally on a Windows machine. I would appreciate any advice from people who have performed similar upgrades of the problems they came across. I know that we have some PCPERFORM unix commands in our software, and am wondering how best to get these working on a Windows system. Many Thanks in advance for any help/advice received. Darren Macdonald --- 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][UV] UPS rate calculator
Flag every shipment as Residential and then when the shipment is a Business you get a rebate and avoid any fines. It's much better getting a check back then having to pay extra fee's plus fines. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marilyn Hilb Sent: Thursday, October 27, 2005 3:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UPS rate calculator Ditto. This is the same way we do it (other than we do the export after each shipment). I have worked with UPS now for two different companies to get an interface with their software. They worked very well with me and helped me accomplish my goals. Only side note I have to add, is I ended up learning a lot more about WorldShip than I thought I would have to know. This is, in part, due to I am very particular and really wanted all the bells and whistles working, so I kept on asking questions and getting further details, both from UPS and my warehouses. My warehouses don't know what to do with themselves now! Basic sends everything World ship needs to it (via odbc)! The only thing the warehouses have to watch out for is on collect shipments, where the freight is taxable, they need to add the tax amount for freight charges accordingly. As well as the residential/commercial factor. While that is stored in Basic.. it is something they seem to struggle with keeping accurate and we still get hit with the charges for sending commercial.. when it really is residential. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, October 27, 2005 12:14 PM To: u2-users@listserver.u2ug.org Subject:RE: [U2][UV] UPS rate calculator I have found UPS tech support quite knowledgable in their software and integrating it with other software. We interface with World Ship using csv import/export tables and let the software do all the work, it imports the name and address and then exports the tracking numbers and amounts. We are not using it however, for real-time rates, we batch export at the end of the day. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill Sent: Thursday, October 27, 2005 12:45 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2][UV] UPS rate calculator Consider contacting UPS tech support. I expect that there is a SQL/ODBC web thing with up-to-date rates etc. --Bill --- 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/ --- 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] PICK 101
Who eat dinner later then 3:00pm and stay up later then 8:00 to complete projects on time? Who don't carry an AARP card? Or maybe they like watching the young people learn skills and then go get better paying jobs? Just to cover myself. I consider more experienced assets to a company. They don't make the same old mistakes that a younger person will. Damn I said old. Sorry. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Wednesday, October 05, 2005 12:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] PICK 101 Who work cheaply. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, October 05, 2005 6:16 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] PICK 101 I suspect that, like many companies, this company prefers to hire young people. --B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Tuesday, October 04, 2005 8:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] PICK 101 the bigger question is why, when there are so many PICK people scrambling for spots especially in the Northeast was a non-PICK person hired? Especially when many Pickies are multi-lingual...and multi-host -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thomas Derwin Sent: Tuesday, October 04, 2005 2:30 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] PICK 101 Matt Stern at Comprehensive Computer Services does Pick training. He's on Long Island. Comprehensive Computer Services Inc 560 Broadhollow Road Melville, NY 11747 631-755-2250 [EMAIL PROTECTED] 10/04/05 11:50 AM Hey all, We've got a new employee at my company with no PICK experience at all .. Does anyone know of anywhere local to get a PICK 101 course in the NYC area? Thanks .. -Chuck --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- 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/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
First off. Thanks for the response. Next. We figured it out. We used an updated driver from our version 6.03??? Unidata disk instead of the 5.2??? Version that was on the old server. I think the numbers of the actual driver are not that different. But to make a long post shorter I'll just say the answer to the question is formatting. The date needs to be 2005-06-27 not 06-27-05 Why? I don't know. And do I care? Not all that much now that it works. So the secret word of the day is International date format. So It's 3 words. So sue me. I'll return to lurking again. Thanks. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, August 25, 2005 2:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] unioledb connection from SQL2000 What version Unidata and Client tools (especially ODBC driver) are you using? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, August 25, 2005 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] unioledb connection from SQL2000 We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date = 06-27-05 AND Inv_So_Date = 09-25-05; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work. Jeffrey Lettau ERP Systems Manager polkaudio --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT Wumpus!
http://www.taylor.org/~patrick/wumpus/ Just play online! Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Tuesday, May 31, 2005 12:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT Wumpus! Marilyn Hilb wrote: WUMPUS!! Me please! That sounds sooo familiar! I am sure I played it long ago. If it is an .exe etc please rename it so the email goes through the filter. Doesn't matter if you rename it. The list filter strips ALL attachments not just those with potentially dangerous extensions. Larry Hiscock Moderator --- 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] Uniobjects hack
There were a few times that I've seen people exploit the fact that they knew how to cause the program to error out to get them to the prompt level. Then it was open season for them since we were just working off a menu based security. They were just trying to be more efficient in how they worked. Using the program took too long. It was faster just to edit the records. Was the reasoning. They couldn't get to the payroll account but they could have if they knew how to make a pointer to the files in that account. Things could have been worse. A few bill of materials and some pricing needed to be fixed but nothing major. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin Sent: Tuesday, May 31, 2005 9:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack Can we have a quick show of hands of those who have had there U2 system hacked? I am not saying that it's not an issue, I am just curious. I do not know of it happening. Les -Original Message- From: Ian Renfrew [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 13:33 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Uniobjects hack Even scarrier, if a person has telnet (almost definitely since its a OS supported application), a valid user id, password and knows how U2 works then they may be able to access data. No need to install UniObjects or purchase Excel. Depending on the version of UniData or network access, the user may be able to go as far as utilizing Windows Explorer to access / view UniData data. The user could use a file browser to view report information contained within the HOLD (_PH_ / PH) file. ... Ian - Original Message - From: Les Hewkin [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 31, 2005 6:09 AM Subject: RE: [U2] Uniobjects hack I have been following this thread with great intrest. The issues seems to be that if someone has Excel, UniObjects and knows how U2 works that they can gain access to the data. Where are these people? Are they working for the IT department? Is this a real life scenario? or an exercise in theory of what might happen? Les -Original Message- From: Piers Angliss [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 10:07 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack JayJay, Reading between the lines I think you're saying a firewall could be a good idea I'm not sure that the other methods will work though. As I understand the problem, it is that you can have a secure VB App using UniObjects on a secure PC but if I have access to Excel on that PC, together with a valid server login id and password (with update rights) and basic knowledge of the directory structure on the server then techniques 2, 5, 6 7 won't trouble me at all. Ok, I need to understand UniObjects and U2. I'm not even sure that a firewall would help because the PC I'm trying to hack the database from has a valid IP address to run the VB App As somebody looking to implement UniObjects alongside traditional server-based applications that's a big hole. I can plug it by taking David Jordan's advice and using AUTHORIZE, but that's a lot of work for me at this stage. It sounds like UOLOGIN is a step in the right direction, but it is only available on UniData and if Ian's experience is any guide may have some implementation issues. I've been impressed with how easy it is to use UniObjects, I'm less impressed now. The functionality is great but in too many cases it's just a hugely inviting route to hack the database, it needs better server-side authentication Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Jenkins Sent: 30 May 2005 01:56 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack Other techniques posted on the group will work as well - but to list a few: 1. firewall with nominated IP address interconnectivity ONLY 2. Restricted accounts with purged VOCs 3. O.S level permissions (or Tivoli Access Manager) 4. Triggers 5. Account level controls (remote verbs etc) 6. UO application-level authentication (suggest public key and one-time-pad for the serious - stops network sniffing) 7. Restrict access to Windows client PCs - stop anyone from doing anything untoward as they don't have permission to load or use that sort of software. 8. firewall 9. firewall --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the
RE: [U2] Performance tuning UniVerse on Windows Server 2003
If the server is running hyper threading then turn it off. That would be turn off the hyper threading, not the server. It can make a noticeable difference in performance. I don't know if this suggesting would be reversed if your running a large number of connections or not. But under a hundred clients it does make a noticeable difference. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Hamrick Sent: Wednesday, May 18, 2005 11:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] Performance tuning UniVerse on Windows Server 2003 Are there any tips to tuning UniVerse on Windows Server 2003, or tuning Windows Server 2003 for UniVerse? Paul Hamrick Access Software 2610 SE Willoughby Blvd. Willoughby Business Park Stuart, FL 34994 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 772-463-4588 Ext. 15 http://www.airpax.com/ www.airpax.com --- 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] uvo.net UvBasic .Net
From what we have experienced here, the addition of .NET applications on top of Unidata that replace existing green screen functions is not a benefit. Depending on how they are written. The users who have been using they older green screens, want them back. Clicking around .NET screens is not more productive or faster. The learning curve for new users is much lower and for the occasional user the interface is better, but when your dealing with how many orders a single person can process in one day, and how many phone calls one person can field in a day, the green screen is the fastest interface. The problem is that no one wants to buy a product that looks old. So software companies need to update to the latest technology to keep selling the product. For new installs I can say that there is a big advantage to having something that looks new and is easy to learn. I guess there is always a trade off when using new technology. But just because it's new doesn't mean it's better. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Thursday, April 28, 2005 5:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uvo.net UvBasic .Net I whole heartedly agree. The green screen is the crusher for our environment. As far as .Net and Visual Studio go, I don't think it takes even that much effort as having Pick Basic as .Net assemblies to modernize or help perception, although that would be terrific. What would be great is simply the ability to use U2 components in the .Net environment as easily as you can those of other databases. The biggest headache/difference is that of data awareness. The current Visual Studio and much more so in VS 2005 allow you to establish tables/procedures as predefined datasources that can be linked to controls. If we did that, our U2 environments could be used by the dotnet world same as any other database.That puts us on an equal or closer footing with the SQL guys. Then the other features of U2 (flexible dictionaries, variable lengths, etc.) are enhancements to be pitched as selling points. Seems like a couple of vendors started down that road (most notably RD's PDP). Maybe it one day it happens. Mike However my perception is to make PICK more acceptable to younger people and look more mainstream. U2 is hung more for the green screen than for anything else, it is perceived as archaic even though that is far from the fact. If a Blue Chip company was looking at U2, and the basic code was a .Net assembly and we could create tables, etc from the Microsoft Visual Studio it could be the difference between a sale win or loss. It could minimise management wanting to throw U2 out of sites for something more modern as the even older RDBMS. It is the perceptions, not the technicalities that have dropped U2 from mainstream. Regards David Jordan --- 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]: Epicor
What if I make a change to the code in the system according to what the CFO wants and then I get implicated as being an accomplice to fraud. Can I pull my college credits where I failed accounting as being my defense? Is it getting to the point where every change to the system requires a call to a lawyer to check to see if it is ok? Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Thursday, March 17, 2005 12:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor We have seen a couple of cases where the CFO has gone to jail for carrying out an illegal action. The CFO gained no financial advantage, whilst the CEO who gained the financial advantage actually never went to jail. In the UK a programmer got into serious trouble when programming who got university places. After exhausting a variety of priority issues such as marks to decide who would get a position, he then made a decision based on skin colour. Programmers are regarded as professional/educated people by the courts and the courts view is that a programmer should no better when programming improper code. (Ignorance is no excuse) If a programmer modifies the code so the CFO does not pay the correct tax, then the court regards the programmer as an accomplice to the crime. The court's view is that a threat of sacking is not an excuse to commit a crime. Bill is right some IT people will be in for a horrific shock as they could be caught up in fraud, privacy issues, spam and other areas and most have not considered their legal implications. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Thursday, 17 March 2005 5:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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/ --- 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]: Epicor
So maybe Advante, Dataflo, infoflo, M2K and the like are not tier 1 multi-million dollar installs. But for ease of use and the ability to tweak the system to meet your needs. I'll take the tier 2 any day. Not intending to start an argument, but what can SAP or JD Edwards do that the smaller Epicor products can't do? What makes them worth the added cost? I don't' buy into that they can handle more users. That is mostly a matter of database management, hardware and infrastructure. You also have to consider who is buying what system and what their intensions are. What do you really get out of a standard SAP or JD Edwards install that you can't get from any system provided by Epicor or similar smaller priced package? I'm not being rhetorical.(again spell checker saves the day, I didn't know a word could start with rh.) P.s. you can get the Monitor Series at a Circuit city store or other high end audio stores near you! You can't seriously expect me to send you something for free! I can't get stuff for free. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Debster Sent: Tuesday, March 15, 2005 12:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Yes...and I was privy to M2K back when it went through ADP doors and was sold back out again -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Monday, March 14, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor I believe that Jeff was speaking about Manage-2000. Polk audio, in addition to making great speakers, is a Manage-2000 user. Now if I could just get them to send a couple of studio monitors my way for the plug. ;-) When I was working for M2k under ROI Systems, there were several companies that choose it over JD, SAP as well as Epicor. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, March 14, 2005 12:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor X-Squeeze me But comparing Avante to JD Edwards Sap is like putting a 2.5 foot T-ball player up against Derek Jeter..its not in the same league Avante is not a tier 1 no matter how much you would like to think that its playing with the big boys... -- Debster -- Original message -- There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it will take them years to make it work. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, March 13, 2005 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will Johnson --- 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/ --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit
RE: [U2]: Epicor
There are a few Epicor people that do read this list. They just tend to lay low unless the discussion effects them directly. I can say a that there are a few people still in the Manage-2000 group that are very good with the interfaces to U2. From my past experience with Epicor, they are a very good company for support, and regardless of how many developers you have, there will always be bugs in the software that require patches. Many times these bugs are not evident due to the fact that everyone will use the software slightly different. I think their long term plan is to take the many packages they have and migrate them all into one package that is all inclusive and database independent. Although making it database independent may be counter productive to their plan on consolidating the software packages. If you look at who the other choices are for software, I'd say Epicor is still one of the top choices. Especially when you consider the flexibility needed in dealing in a manufacturing environment. What are your other choices? JD Edwards? SAP? They are also trying to focus on integrating all of their other packages together into a complete solution. Kind of like cross selling. If you run ERP and want CRM then they want to integrate the 2. They have many initiatives that are good ideas, in my humble opinion, but it will take them years to make it work. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, March 13, 2005 12:58 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Another interesting consideration is seeing no response from anyone within Epicor to this thread. That tells me they have little to no interest in U2 which is a red flag in my book. Certainly implies that they don't have knowledgeable or extensive support for how Epicor interfaces or doesn't with U2 in general. Will Johnson --- 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] Sessions getting logged out in bulk.
Arc Serve Redback, Vsifax, Iconnect(disabled), Norton antivirus(turned off), mks toolkit(disabled all services for this) We did get a memory error for UDT.EXE a couple of times but were unable to trace it back to anything. I've see that error before when we had the memory leak, but that doesn't appear to be happening. UDT settings have all been increased. We need to test with the new settings this morning. CPU's did get hit by 4 sessions each at 24-25%. I'm assuming that they were just trying to finish what ever they started when the connections got dropped. We turned off Threading and the processors didn't get over 1% in the minimal testing. We reset the directory structure to everyone full control. need to test that change this morning aswell. Jeffrey Lettau ERP Systems Manager polkaudio From: [EMAIL PROTECTED] on behalf of Marc Harbeson Sent: Tue 2/15/2005 11:38 PM To: u2-users@listserver.u2ug.org; u2-users@listserver.u2ug.org Subject: RE: [U2] Sessions getting logged out in bulk. Jeff, Are you running backup exec? Anything else funky on your server? Virus software? Are there any messages at the server, popup boxes, errors, warnings, event log entries that look funky? Have you upsized or bumped your udt parms in confprod.exe? CPU / RAM do anything funky when the mass logout occurs? poking in the dark here Anythink funky in your log / error log files in the ud6 bin directory? -Original Message- From: [EMAIL PROTECTED] on behalf of Lettau, Jeff Sent: Tue 2/15/2005 8:44 PM To: u2-users@listserver.u2ug.org Cc: Subject: [U2] Sessions getting logged out in bulk. We are having an issue with users getting logged off the system. It appears to only happen when more then one person is entering a sales order or similar transaction. I'm unable to re-produce it as a single user. When one of the people ends out of the order to save it, the system will logoff multiple people. Up to 15. Even if they are just at a menu. The users do have to be in that database account. Alternate accounts don't appear to be effected. It is not with every order and we can not figure out if there is anything consistent when they are getting logged off. We have eliminated the possibility that it is a network issue or that the nic card is bad. We replaced it and updated drivers. It's not a memory leak with the database. That we have found at least. odbc and oledb both work without a problem. We eliminated the broadcom network card so that is no longer a potential issue. Anyone have anything remotely close to this happen before? I'm looking for anything at this point so feel free to suggest bizarre answers. At the very least it may put me in a better mood. We are suspecting that it is something weird with the software and not the database directly but can't be sure. Even if it is something with the programs, maybe someone has seen something like this before in other applications and can give a starting point to look for something. We are running windows2k UD6.0 Jeffrey Lettau ERP Systems Manager polkaudio --- 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/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sessions getting logged out in bulk.
Thanks, I'll look into these possibilities. The work file problem sounds plausible. I don't think we have a file buildup problem. The memory stays very low and the processors are also not getting hit hard. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Tuesday, February 15, 2005 10:23 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sessions getting logged out in bulk. It could be something silly like record locks not being released. Check LIST.READU The other area could be a temporary workfile that is set up and only one person can use it at a time creating a fatal. In debugging some people set a como file on and don't remove it going live and you have a massive file building up. --- 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] spammed
www.mailinator.com can also be used for a quick temp account to signup for stuff that may just be junk. You don't need a password so security is non-existent, but you don't have to setup an address ahead of time. I don't remember how long it keeps the information and you can't send stuff out from the site. It just receives stuff in and you don't have to worry about someone using the address you provided to spam you. But it is a valid email address for receipts. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony Gravagno Sent: Tuesday, September 21, 2004 3:05 AM To: [EMAIL PROTECTED] Subject: RE: [U2] spammed gerry wrote: imo - the solution to this problem is simple - the posters email address should not be included in the distributed postings. i know the list address , the list address knows my address and nobody else knows anything. From: Glen B Something else to consider, is the presence of your e-mail in cross-posting on lists/newsgroups and web forums. Spiders can pull e-mail addresses from just about anything now-a-days. Part of the problem is when you post to a forum and then someone replies to your note, and their e-mail client puts in: From: persons name [EMAIL PROTECTED] wrote: You can't stop someone else from inserting your live mail like this, which then gets put into the web archive and becomes visible to the world. (BTW, Glen's comment about using a dynamically generated image to challenge people on a web site can be applied to the forum archive to help with this problem.) People should be dilligent about not posting other people's e-mail addresses, but in the real world people don't think about this until They get spam or a virus. The only way to stop your e-mail addresses from getting published is simply to not use your real e-mail addresses for anything except direct correspondence. With the exception of this list, which was simply an error on my part, I use http://sneakemail.com for creating disposable e-mail addresses for forums and other untrustworthy sources, and I strongly encourage others to use this service as well. Basic service is absolutely free. Extended service is only $2/month. Please feel free to send me mail to ask about this service if you have any questions. Regards, Tony [EMAIL PROTECTED] (And please don't publish my addresses in your responses!) --- 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] Anyone have experience mirroring a HDD over a WAN
From what I've read about the replication, in UD, it can replicate across servers and when one goes down the remaining one will assume it is now the master and continue processing transactions. When the downed server is restored it will be updated with the missed transactions or rebuild the database depending on how bad the failure was. The problem with this idea is that over a wan you can have a connection failure and both or multiple servers will think they are the master server and begin processing the transactions. They keep log files but I don't see any way to reconcile the differences. It also looks like there should only be one master server at a time. I don't think you can have 20 offices with their own server. I would still look for some 3rd party solution to keep the data in sync and have a recovery plan that would allow a merge and audit of the logs to keep your integrity. Program triggers that keep all the databases updated virtually in real time sounds like the best real world solution to me. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, September 02, 2004 2:09 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Anyone have experience mirroring a HDD over a WAN Have you looked into data replication? - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 02, 2004 8:19 AM Subject: [U2] Anyone have experience mirroring a HDD over a WAN Anyone have experience mirroring a HDD over a WAN? We have a scenario where triggers were going to be the data collection and a distribution program to blow extracted data to various end of the earth. All this was an attempt to maintain a 24/7 access to a working system. = All log on to the main server and work as at present. = When comms break at any branch, they log into their own server and continue to work (the data being an exact copy of that on the HO server up until the night before = synchronization to take place at night, when network traffic is lowest) We've now had to abandon triggers, moving to a scenario where we get to modify source code (not a preferred route). This has caused us to stop and think... if this can go wrong, how much more the distribution of data onto every server at every branch (20 branches, plus HO). An alternative solution is to set up a hardware mirror to handle the movement of data. A google produces an overwhelming array of choices... What does the collective authority of the list say? PRE - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp/PRE --- 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/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata 6.0 oledb connection to Crystal reports
I'm having a problem moving my Crystal reports from Unidata 5.2 to 6.0. When I re-point the report to the new data source and put it on the web server, The report prompts for a login and password in a loop. Running it in the application works fine and doesn't prompt for a password. The knowledge base for this problem, on the crystal support sight, isn't helping. It references having it setup using ODBC and showing this issue and not OLEDB that shouldn't be asking for a login and password. Is there some database setting that is causing this or some other setting that I'm unaware of? Jeffrey Lettau ERP Systems Manager polkaudio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/