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
Source=TESTFAMIS;Password={your_password_her
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
Sub
Datatel Programmer 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 followi
ehalf Of Wang, Cody
> 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
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
Make sure your connection string is using the correct case for the Data
Source as it has to match the uci.config exactly. Also make sure that the
location is a proper account or full path.
Here is a file I have on my desktop called myconnection.udl that will test
the connection:
[oledb]
; Everyth
Cesar,
I encountered the same error - I dont think the interface likes the use
of 'localhost' (as Bryan Haglund pointed out previously) - Try
specifying your actual IP address instead (please find below a copy of
my uci.config that works)
Cheers
Eric
[ODBC DATA SOURCES]
DBMSTYPE = UNIVERSE
n
Cisar
You need to add the line:
ACCOUNT = yourpath
to your file.
Brian
My conexion with ODBC are working, but the conexion with
UniOLEDB don't can
working, when I conect from Visual Basic I recived this
error:
DBMSTYPE = UNIVERSE
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" <[EM
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.
DBMSTYPE = UNIVERSE
HOST = 10.0.0.3
ACCOUNT = \\DELL\CUENTAS\COMERCIAL
USERNAME = CESAR
MAXFETCHBUFF = 2
MAXFETCHCOLS = 800
NETWORK
, 2004 9:39 AM
Subject: RE: [U2] UniOleDB Configuration
> Hello
> Tanks for your respons.
>
> After of have the changes the error is another, this is the change that I
> have been in uci.config of my computer.
>
>
> DBMSTYPE = UNIVERSE
> HOST = 10.0.0.3
> A
e de Bryan Haglund
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.
- Origin
Cesar,
Here is my configuration for a test account. this works
ok.
You did take the Location out of your connection string as
well, yes?
DBMSTYPE = UNIVERSE
NETWORK = TCP/IP
SERVICE = uvserver
HOST = shark
ACCOUNT = c:\Accounts\oledb
USERNAME = Administrator
MAXFETCHBUFF = 8192
MAXFETCHCOLS =
Cisar
-Mensaje original-
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de Brian Leach
Enviado el: lunes, 17 de mayo de 2004 14:27
Para: [EMAIL PROTECTED]
Asunto: Re: [U2] UniOleDB Configuration
Cesar,
Here is my configuration for a test account. this works
ok.
You did
Clutching at straws here. What happens if you use "" rather than "" 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] UniOle
ROTECTED]
Asunto: RE: [U2] UniOleDB Configuration
Clutching at straws here. What happens if you use "" rather than
"" as the data source name?
- Original Message -
From: "Cesar Riba" <[EMAIL PROTECTED]>
Date: Mon, 17 May 2004 18:01:23 +0200
To: <
at change.
Gary Hines
Date: Tue, 18 May 2004 08:29:30 +0200
From: "Cesar Riba" <[EMAIL PROTECTED]>
Subject: RE: [U2] UniOleDB Configuration
Hello
After change the data source name the "" to "" the
error is the same.
Very thanks for your help.
Cis
t;
> Tanks.
>
> -Mensaje original-
> De: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] nombre de Bryan Haglund
> Enviado el: viernes, 14 de mayo de 2004 19:05
> Para: [EMAIL PROTECTED]
> Asunto: Re: [U2] UniOleDB Configuration
>
>
> Cesar,
>
> The accoun
ombre de Gary Hines
Enviado el: martes, 18 de mayo de 2004 14:55
Para: [EMAIL PROTECTED]
Asunto: RE: [U2] UniOleDB Configuration
Hi Cisar,
In:
Set cnUniConnect = New ADODB.Connection cnUniConnect.Provider =
"Informix.UniOLEDB.1" cnUniConnect.Open "prueba"
om: Bryan Haglund [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, May 18, 2004 8:36 AM
>To: [EMAIL PROTECTED]
>Subject: Re: [U2] UniOleDB Configuration
>
>
>Cesar,
>
>Is the account name 'COMERCIAL' ? If so, that's what it needs
>to be in the
>UCI Config Editor,
e mayo de 2004 16:36
Para: [EMAIL PROTECTED]
Asunto: Re: [U2] UniOleDB Configuration
Cesar,
Is the account name 'COMERCIAL' ? If so, that's what it needs to be in the
UCI Config Editor, and not the explicit pathname for the account.
Bryan
- Original Message -
From: "Ces
---
jd
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cesar Riba
Sent: Friday, May 14, 2004 12:39 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniOleDB Configuration
Hello
Tanks for your respons.
After of have the changes the error is anothe
nt to break it.
:)
Bryan
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 18, 2004 9:19 AM
Subject: RE: [U2] UniOleDB Configuration
> I use the full path all of the time - so I don't have to worry about
> creating the e
OLEDB
configuration(s).
Bryan
- Original Message -
From: "Cesar Riba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 18, 2004 9:25 AM
Subject: RE: [U2] UniOleDB Configuration
> Hello Bryan
>
> I changed de name of Account in the u
EMAIL 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:
DBMSTYPE
uired, then
there's a problem here that's a little deeper than the specific connection
string being used.
Bryan Haglund
Haglund Consulting Inc.
- Original Message -
From: "Cesar Riba" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 20, 200
IL PROTECTED]
>Sent: Friday, May 21, 2004 7:44 AM
>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 configurati
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 SysWOW
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
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 fetch
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 fro
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 Messa
#x27;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 conne
I setup the uci.config file with this
Set the name of the definition to be the same as the account name.
DBMSTYPEUNIDATA
NETWORK TCP/IP
SERVICE udserver
HOSTenter your server name in all caps
ACCOUNT enter your account name in all caps
MAXFETCHBUFF8192
MAXFETCHCOLS400
Eric,
The first thing you need to do is to add your specific OLE connection using
the UCI Config Editor. The minimum requirements are:
DBMSTYPEUNIVERSE
NETWORKTCP/IP
SERVICEservice name (uvserver)
HOST ip address used.
Note that for the host, there are certain config
Haglund
Haglund Consulting Inc.
- Original Message -
From: "Lettau, Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 13, 2004 10:00 AM
Subject: RE: [U2] UniOleDB With Crystal Reports
> I setup the uci.config file with this
>
> Set the name o
CTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bryan Haglund
Sent: Thursday, May 13, 2004 1:21 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] UniOleDB With Crystal Reports
I have had no problems with the 'test' button - with it returning and
answer
within 2-3 seconds. However, I too have run int
I'd sure like to see some documentation that would help
address performance
when selecting large amounts of data.
Frankly, you are unlikely to see great performance from
UniOleDB when reporting with most applications. As a
minimum, I would suggest that you need to look at your
data structures a
From: Bryan Haglund [mailto:[EMAIL PROTECTED]
Sent: 13 May 2004 18:07
To: [EMAIL PROTECTED]
Subject: Re: [U2] UniOleDB With Crystal Reports
Eric,
The first thing you need to do is to add your specific OLE connection
using the UCI Config Editor. The minimum requirements are:
DBMSTYPEUNI
achieving open database connectivity with UniVerse without the use of
third party tools such as MVQuery?
Cheers
Eric
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell
Sent: 14 May 2004 10:47
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniOleDB With
PROTECTED]
Subject: RE: [U2] UniOleDB With Crystal Reports
Worth mentioning that we have implemented
an OLEDB solution, driver version 1.4.3
against Unidata 5.2 and have discovered that the driver
is not
capable of concurrent execution, more specifically it's
the
unirpc service which serialis
over my head
for a good few years so I am prepared to be optimistic :)
Cheers
Eric
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach
Sent: 14 May 2004 14:20
To: [EMAIL PROTECTED]
Subject: Re: [U2] UniOleDB With Crystal Reports
Eric,
Think
- 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 perform
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 AM
Subject: RE: [U2]
To: [EMAIL 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
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 SQ
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 err
au
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 play
No, I've run the -g as high as 512 without any effect.
Noah
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff
Sent: Friday, July 27, 2007 8:41 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] UniOledb error "out of memory"
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 b
51 matches
Mail list logo