Questions tagged [u2netdk]

U2NETDK is the short name for U2 Toolkit for .NET

U2 Toolkit for .NET (U2NETDK) provides an ADO.NET provider, LINQ to Entity 4.0, and the native UniObjects for .NET API for the UniData and UniVerse databases.

40 questions
5
votes
2 answers

Accessing UniData through .net

I'm having trouble with accessing UniData data from the u2.net toolkit. I'm able to connect ok - have tested connections with the "Test Connection Tool" and in code, both connections work fine. My problem is when I try and fill a dataset - using…
user1757494
  • 101
  • 4
4
votes
2 answers

How can I get schema information about a UniData/UniVerse database?

I have some (limited) experience with UniData and UniVerse databases and now wanting to work with them via the .NET framework. It appears that the way to work with them now is via Rocket Software's U2 Toolkit for .NET. Since I will be accessing…
ksigmund
  • 527
  • 1
  • 6
  • 13
4
votes
1 answer

U2 Toolkit for .NET - UniSession vs U2Connection

I'm struggling a bit with some of the base concepts of U2 Toolkit (and I've been quite successful with the previous version!). First, I had to add using U2.Data.Client.UO; in order to reference UniSession or UniFile. This may just be general…
Scott Marshall
  • 169
  • 1
  • 7
3
votes
1 answer

How to do fetch pages when querying universe database using .net sdk and sql

I am connecting to a universe database (from rocket software) using their .net driver. I would like to fetch data on demand on user request per page i.e. do pagination. With other databases we could use (offset fetch) but universe db doesn't seem to…
Bhupendra
  • 1,725
  • 22
  • 30
3
votes
1 answer

How can I prompt for a username and password for a connection string?

I have a C# Winforms app that I'm porting over to ASP.NET. Everything works, but the connection to my Universe database currently uses my personal name and password. Instead, I'd like to get the user's name and password. In web.config added the…
Jeff Brady
  • 1,454
  • 7
  • 35
  • 56
2
votes
0 answers

Unable to update unidata from .NET

I've been attempting for the last couple of days to update unidata using sample code as a basis using .NET without success. I can read the database successfully and view the raw data within visual studio. The error reported back is a out of range…
rfc
  • 21
  • 2
2
votes
2 answers

Unidata UniObjects for .NET - Write amendments back to unidata from modified table

I'm trying to write data back into a file on Unidata, after the contents have been adjusted in a datagridview. I've tried various option based around the code below, but with no luck. Within the foreach section I want to update my file. The file…
2
votes
2 answers

Using UniDynArray on ASP.net MVC view page

Can anyone help me on how to use UniDynArray on ASP.net MVC3 (MS Visual Studio 2010) View Page? I managed to add reference (U2.Data.Client) to the project and I'm able to use it in the Controller, but not in View page. The reason to utilize the…
cwkueh
  • 23
  • 3
2
votes
1 answer

U2 Toolkit for .NET - RPC Failed, An established connection was aborted [errorcode=81009]

I am using the U2 Toolkit for .NET to access our Universe system from MS SSIS. This has been working great while running some investigation tests on several files returning less than 200k rows of data. On my latest run, using a new file where the…
user2121229
  • 21
  • 1
  • 2
2
votes
1 answer

How can I convert U2 Business Logic Subroutine’s multi-value data into .NET Objects such as DataSet/DataTable using U2 Toolkit for .NET?

I have the following subroutine. It takes INPUT as argument 1 and sends multi-value data OUTPUT as argument 2. SUBROUTINE MV_TO_DATASET_SELECT_SUBROUTINE(ARG_INPUT,ARG_OUTPUT) x = ARG_INPUT ARG_OUTPUT =…
Tyler Elma
  • 27
  • 3
1
vote
1 answer

Slow Connect via Open / OpenAsync .Net Provider Unidata

I am consistently seeing a 3+ second delay when opening a connection to a Unidata server via OpenAsync and the ADO.NET provider by Rocket. What can I do to diagnose this delay?
trevster344
  • 491
  • 2
  • 14
1
vote
1 answer

What is the fastest way to GET a list of records from Universe DB file using C#.NET?

I want to perform a SELECT query which would make a hit to the Universe DB once only and get the list of records quickly and efficiently which would then be added to a List. I have tried to use U2DataAdapter as well as U2DataReader but not sure…
usafder
  • 791
  • 5
  • 17
1
vote
1 answer

U2 Toolkit for .Net Provider 2.2.2 Not Displaying in ADO.NET Connection Manager

I've been trying to install the U2 Toolkit for .Net Provider 2.2.2 and wanting to utilise SSIS with it. Initially I installed Visual Studio 2017 with SSDT 2017 but I was unable to view the U2 .Net Provider option when creating a new ADO.net…
James T
  • 58
  • 4
1
vote
2 answers

U2 Universe SQL SSIS issue with returning data for specific columns

I am new to the U2 Universe so I've been researching about it and have been going through the documentation, searching on stackoverflow but still cannot figure out why a select all statement only returns one column - @ID. I've been attempting to do…
James T
  • 58
  • 4
1
vote
1 answer

Universe Entity Framework very slow to select

I am going with the Entity Framework code first approach and am finding that queries to grab just 350 records or so is taking about 8 seconds. How can I speed this up? Is this Universe or Entity Framework that is being slow? Entity Framework…
sourkrause
  • 178
  • 8
1
2 3