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
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
-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
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
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
-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
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
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
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
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
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
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:
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
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?
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:
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
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
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
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
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
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
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
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
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!
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
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]
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:
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
?
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
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
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
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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
: [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
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:
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 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
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
53 matches
Mail list logo