On the same topic, we are trying to return 5 million rows, but the select fails
at about 2 million rows.
Is there a limitation on how many rows can be returned through UniOleDB or
through the UniRPC service?
Uniiverse 10.2.4
AIX Unix 5.3
We have been using UniODBC to run our DTS jobs (to our
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
Sorry to bother everyone, it was a 32 vs 64 bit issue. If I run
%windir%\SysWOW64\cscript.exe connect.vbs from the command line it runs
fine and gets my recordset with IBM.UniOLEDB.1 as the Provider.
I know how to switch between wscript and cscript but if anyone knows how to
default to the
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
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
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
Analyst
Ohio Dominican University
1-614-251-4799
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Monday, November 27, 2006 3:13 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Cody:
See if the following thread
Sent: 28 November 2006 12:40
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Hi Bill,
I am little confused about how to create another data source.
Can you give me more detail about it? Do we create another
data source by using MS data source application or uni.config
Programmer Analyst
Ohio Dominican University
1-614-251-4799
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: Tuesday, November 28, 2006 10:13 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOLEDB hangs
Hi
You might want to look
Cody:
See if the following thread helps.
http://www.nabble.com/OLEDB-connection-string-tf1838501.html#a5019034
Bill
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wang, Cody
Sent: Monday, November 27, 2006 10:43 AM
To: u2-users@listserver.u2ug.org
See this posting I recently made to CDP on the topic. Then look down two
posts to where I provide more detail about the issues and solution.
http://tinyurl.com/av4jj
When OLEDB does work, I can't tell you how it works with ADO.NET - I'm
curious to hear more about this as well.
mv.NET uses a
Stuart Boydell wrote, I'm wondering what peoples experience of using
UniOLEDB is.. Here is our experience.
Our environment experience has been on version 6 of UniData on Windows
2003.
1) Our engineer's had a heck of a time getting the right connection
string to work. It has been such a long
Claus,
If you have set up your config file correctly (looks ok, did you use the
horrible UCI Config editor to make sure it is saved in the right place ?)
your connection string should just read:
Provider=IBM.UniOLEDB.1;Persist Security Info=False;Data
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
Up here, in the Great White North, we have to watch the regional
settings. Sometimes using a different date format causes problems -
whether it's the order or the delimiter.
It seems to be a problem with your dates - so this is where I would
start...
Colin Alfke
Calgary, AB
-Original
.
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
PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Bryan Haglund
Enviado el: viernes, 21 de mayo de 2004 5:30
Para: [EMAIL PROTECTED]
Asunto: Re: [U2] UniOleDB Configuration
Cesar,
Ok, let's try this from another angle. Go back to the original OLE DB
configuration under localuv:
DBMSTYPEUNIVERSE
To: [EMAIL PROTECTED]
Subject: Re: [U2] UniOleDB Configuration
Cisar,
Can you test your OLE DB connection using Excel, Access or
Crystal Reports?
You should not have a problem with the default configuration.
It sounds
like something else is going on here. If it still doesn't work after
building
Enviado el: viernes, 14 de mayo de 2004 19:05
Para: [EMAIL PROTECTED]
Asunto: Re: [U2] UniOleDB Configuration
Cesar,
The account name format is incorrect. It needs to be the actual UniVerse
account name as defined in UV.ACCOUNTS.
Bryan Haglund
Haglund Consulting Inc.
- Original Message
Clutching at straws here. What happens if you use OLEDB rather than prueba as
the data source name?
- Original Message -
From: Cesar Riba [EMAIL PROTECTED]
Date: Mon, 17 May 2004 18:01:23 +0200
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniOleDB Configuration
Hello
After
PROTECTED]
Subject: Re: [U2] UniOleDB With Crystal Reports
Well, that would certainly tend to slow things down. I wonder why they
would have set it to operate like that?
Bryan
- Original Message -
From: Nick Southwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 14, 2004 2:47
- Original Message -
From: Brian Leach [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 14, 2004 1:07 AM
Subject: Re: [U2] UniOleDB With Crystal Reports
I'd sure like to see some documentation that would help
address performance
when selecting large amounts of data
Cesar,
If you are entering a path (location) in the connection string, you will
likely have problems - leave this field blank, and let it pull the
information from what is set up in the UCI Config Editor.
Bryan Haglund
Haglund Consulting Inc.
- Original Message -
From: Cesar Riba
Hello
Tanks for your respons.
After of have the changes the error is another, this is the change that I
have been in uci.config of my computer.
vaquer
DBMSTYPE = UNIVERSE
HOST = 10.0.0.3
ACCOUNT = \\DELL\CUENTAS\COMERCIAL
USERNAME = CESAR
MAXFETCHBUFF = 2
MAXFETCHCOLS = 800
24 matches
Mail list logo