Yes,
I've worked on various systems that do this. Those that run under Windows
generally use the built-in BCI (ODBC) interface which is fast and effective
- depending of course on what you are calling at the other end! As always
the usual rules apply about calling stored procedures being generally
This is exactly what we have done with no middleware on udt on windows, it
is called the BCI and is easy to use !
However if your u2 box is on *nix, there is no native mssql driver for *nix
so you have to use a bridge. However your code is just the same it is just a
configuration issue.
-Or
We are using SOAP to extract and update and SQL server. Earlier versions (pre
10.3) of UniVerse have a memory leak, but this is working well for us. This
isn't "real-time" but it is near real-time. The requests are queued and a
phantom process pushes/pulls the data.
The nice thing about SO
And just when I thought it was safe to go back in the water...
This issue is NOT resolved. My customer has found that there is ZERO way to
get the IBM UniOLEDB driver working in SQL Server. They had it working
temporarily using the Microsoft ODBC -> OLEDB driver, but that's not working
100%.
Wi
I'm wondering if the problem might be the provider string in setting up the
SQL Server linked server. Looking at the IBM/Rocket documentation I'm not
seeing a single word about what this provider string is supposed to look
like. The client currently has this provider string for the UniOLEDB
drive
Anybody know what permissions a person needs to use all of the UniAdmin
options on a Windows server running UniVerse. Right now I can bring up the
UniAdmin when I rdp to the system but I can't see any of the users except
myself. I can't kill a user because they don't show up on the users window.
Sa
When you say two systems, are saying two different hosts? If so, then
maybe it's the data source definition. Maybe the one that doesn't work
has the wrong IP, or username and password.
>>I'm wondering if the problem might be the provider string in setting up
the
>>SQL Server linked server. L
Jerry,
It may be a problem with the version of UniAdmin that you are using. I
was told by support that I should try downloading the version that ships
with the Unidata version. That was a year ago, I don't know if they
have updated the UV UniAdmin release yet or not.
HTH,
Curt Stewart
TRI-SYS
I have an intermittent problem with my background process. The process
creates 2 sequential files, one is a log file and the other is an error
file, both are keyed by the date in the file name. Most of the time the
process runs with no problems, terminates and then starts a new phantom
job for the
> From:Curt Stewart
> It may be a problem with the version of UniAdmin that
> you are using. I was told by support that I should
> try downloading the version that ships with the
> Unidata version. That was a year ago, I don't know if
> they have updated the UV UniAdmin release yet or not.
M
Thanks for pointing that out. After nearly 15 years of running UV only
on unix or linux, I often forget some sites run it on Windows.
-John
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
Sent: Wednesday
I struggled with it for a long time before finally getting it to work
(turned out I needed a patch for my version). It does work, though, not
very well in my opinion.
I ended up writing an application (UniBasic + .net) that I use to
interact directly with sql server through either sql statement
These SOAP comments raise the question... Is UniVerse REST compliant?
If not, is REST planned for UV 11?
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore
Sent: Thursday, April 15, 2010 8:29 AM
To:
Kevin;
I haven't connect UD to SQL server since version 6.0.12 so - hopefully - my
comments are dated. We had a VB app that connected using UniOLEDB. I had
some trouble with different versions - 1 would work with Access but not
Excel and another was the opposite. Setting up the connection
strings/
I am not sure as i do not use them for real stuff, but i don't think the u2
webservices is restful, however it is easy to write a restfull webservice in
asp.net and use uniobjects to perform the action required.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users
Thank you all for the insights; all information is appreciated.
Going back to the beginning, I have been told all along that the original
SQL Server connection works perfectly for my contact. However, when I RDP
to that server and try to run the exact same query, it fails with this
message:
Msg
By user do you also mean computer? It could be as simple as a wrong version
of UniOLEDB installed on the other PC. Of course, I'm assuming that you
still have to "install" the development kit/dll's to get everything to
work...
Colin
-Original Message-
From: Kevin King
Thank you all for t
Hi,
I'm trying to install the unidata demo on a red hat 64-bit server, but
I'm getting this error.
error while loading shared libraries: libgdbm.so.2: wrong ELF class:
ELFCLASS64
I guess udtinstall is looking at the lib64, but how do you get it to
look at the 32bit library?
Thanks,
-henry
**
Well, no. If this other person RDPs into the box, authenticates into SQL
Server, and runs the query, purportedly it works. If I RDP into the box,
authenticate into SQL Server and run the exact same query against that
linked server, it fails with the message as shown earlier.
_
Permissions?? Do you have access to the uci.config file?
Terminal Server setup so that the UD development kit was installed for the
other user and not yours?
Try creating an empty text file on the desktop called testconnection.udl.
Then run it. You should get a "Data Link Properties" box. Make sur
I do have access to uci.config. Not sure how the IBM/Rocket drivers were
installed but there's been no indication that it would have been installed
only for a single user.
I'll try the testconnection.udl thing. Thanks for that.
-K
___
U2-Users mailing
I am out of the office until 16/04/2010.
I will respond to your message when I return.
Note: This is an automated response to your message "U2-Users Digest, Vol
12, Issue 15" sent on 15/04/2010 20:00:02.
This is the only notification you will receive while this person is away.
__
OK, here's my blog entry about the bridge. There are some definite advantages
to this approach. We originally did this for a customer who wanted to migrate
to Universe but had a dependency on a vendor's SQL connectivity product.
http://www.fwic.net/NewsInfo/FusionWareIntegrationBlogs/tabid/163/
Colin, I got the connection string and while it tests the connection just
fine, when I try to use the connection in SQL Server the error is the same:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "IBM.UniOLEDB" for linked server "KTEST" reported an
error. The provider reported an unexpec
In message <4bc5e280.5070...@advantos.net>, Bill Haskett
writes
Wol:
What do you consider properly normalized and what example would you
give for designing a new mv FILE as a set of nested tables?
Basically, use relational theory. Okay, mv design isn't as clear as for
a RDBMS (they force ev
On Thu, Apr 8, 2010 at 12:16 PM, Baker Hughes wrote:
> Would those of you mind responding that use 3-Tier or N-Tier architecture -
> I'm trying to gather some quick numbers for some decision makers (somewhat
> urgent).
>
> Please respond if your site, or sites who you service have UniData,
> UniVe
26 matches
Mail list logo
