ODBC connection with Universe 9.6

Question

We have a legacy system running on Universe DBMS 9.6 . We are trying to export data from it and we have enable rpc daemon so that we can connect via odbc.

Now we are able to connect to the server but we are not able to run any queries. We are getting following error

query - SELECT * FROM DEBTOR

exception - UniVerse/SQL: syntax error. Unexpected symbol. Token was ";". Scanned command was SELECT

There are two types of database in universe ie Table and File based. But we are able to query the table based database but we cannot query File based and there are some configurations that will enable querying the File based ones. We are stuck at this place.

Using u2Client library in c# to access the db. Any help is appreciated

Code used to connect Universe

 U2ConnectionStringBuilder conn_str = new U2ConnectionStringBuilder();
 conn_str.UserID = "id";
 conn_str.Password = "pwd";
 conn_str.Server = "serverIP";
 conn_str.Database = "DBNAME";
 conn_str.ServerType = "UNIVERSE";
 conn_str.Pooling =false;
 conn_str.AccessMode = "Uci";
 conn_str.RpcServiceType = "uvserver";
 string s = conn_str.ToString();
 U2Connection con = new U2Connection();
 con.ConnectionString = s;
 con.Open();
 Console.WriteLine("Connected.........................");
 U2Command xmd = new U2Command("SELECT * FROM TABLE_NAME", con);
 var op = xmd.ExecuteReader();

Exception catches while executing the last statement

Are you receiving an error when querying Universe with ODBC from Microsoft Excel? — webthaumaturge, Jun 24 '13 at 20:18
wow, 9.6 is between 11 to 12 years old! Any reason why it hasn't been upgraded to the latest and greatest? If you were on support/maintenance, the U2 support team *might* be able to help you out. — Dan McGrath, Jun 24 '13 at 23:51
@DanMcGrath we are using a software that is built over the universe 9.6 and we have customized it so much that we cant even upgrade to new version. But we are working on updating the software — Sabareesh Kkanan, Jun 25 '13 at 15:00

score 1 · Accepted Answer · answered Aug 07 '13 at 15:56

We tried a driver from Rocket software Universe side is working and it is sending the data to the client but client cant understand the protocol or some error that causes exception . We confirmed that the server responded to the query with data by checking the TCP packets. But we are out of luck.

So we decided to create our own software which is developed in Universe Pick Basic which will be connected to external system via ssh and created a new protocol that both client and server understands it. And we succeeded ,now we can export and import data to universe.

webthaumaturge · Answer 2 · 2013-11-05T16:56:56.283

0

Officially Universe 9.6 isn't supported for use with the U2 Toolkit for .NET. Per the documentation (page 6):

Supported versions of UniData and UniVerse

UniData 7.1 or later
UniVerse 10.3 or later

You can still use straight ODBC or UniObjects to extract data from your database. If you're planning to use ODBC, in addition to enabling RPC, make sure you have configured your Universe account for ODBC per Rocket's ODBC documentation. Before writing C# code, I have often verified my ODBC setup using Excel's external data access tools.

edited Nov 05 '13 at 16:56

answered Jun 25 '13 at 18:17

webthaumaturge

1,198
1
11
23

well there are two types database in Universe, File based and Table Based. I can actually query the table based but there is some configuration that needs to be done to enable querying on file based DB. We are stuck at this place. – Sabareesh Kkanan Jun 25 '13 at 22:10

ODBC connection with Universe 9.6

2 Answers2