Solved

How do I use Crystal Reports with Unidata

Posted on 2010-09-19
12
740 Views
Last Modified: 2012-05-10
I have been using Crystal Reports for years with Oracle, but now I am doing some work for a sister company that runs on Unidata and I would like to use Crystal Reports.  It seems like it should be possible, but when I try to set the location of the database in CR to the ODBC data connection, it shows "no items found" under the ODBC connection.  It doesn't show any tables or views, but it does look like the connection has been made.  I was able to produce data through a connection in MS Excel, so I know the ODBC connection is correct.  The IT at the sister company doesn't know much about this, so I am just trying to figure this out myself.  Any help would be greatly appreciated.  Am I missing something here?  
0
Comment
Question by:juliemckenzie
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 33713469
You need to get a Crystal compatible ODBC connection.

You probably need to contact the database company to see if they can provide one.

mlmcc
0
 
LVL 13

Expert Comment

by:George K.
ID: 33713948
Regarding ODBC drivers check this link: http://www.download32.com/informix-unidata-odbc-software.html
0
 
LVL 13

Expert Comment

by:George K.
ID: 33713963
0
 

Author Comment

by:juliemckenzie
ID: 33717288
I have downloaded the IBM UniData ODBC Driver and am using it successfully to retrieve some test data with Excel and Visual Studio.  But when I try to connect in Crystal Reports, it makes the connection, but no tables or views show underneath it, so I can't select 'Add'.
CRconnection.docx
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33717597
Okay, it has been a while since I had to analyze data from our PICK/Universe system ; however, just to chime in and ensure you have tried this:

From my recollection, we had to install the UniVerse ODBC Driver (I have the UniDK also installed -- I recall having to set somethings up in the UCI editor, but that may be unrelated).  However, what I have had to do in the past is to setup ODBC connection in the UVODBC Config and then using the UV/ODBC Configuration Name we had to create a normal Windows DSN using the IBM UniVerse ODBC Driver whose configuration we simply made the configuration name for both the ODBC Data Source Name and UV/ODBC Configuration Name entries.

On my SQL Server where I connected frequently to our UniData system from a linked server (possibly I removed the other installs and just don't recall), but we only have the UniDK installed and not the ODBC driver.  What we do there is connect using IBM.UniOLEDB which connects to ODBC data sources configured in UCI Editor if I am not mistaken.

Hope that helps some.

Kevin
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33717666
Since I recalled there being some setup on UniVerse side I referred to the manual which I remembered after posting I saved for such an occasion where I no longer remembered the information fresh in my mind. *smile*

"UniVerse tables and views are always accessible to ODBC applications, but UniVerse files that are not tables are not. To make UniVerse files accessible to ODBC applications, you must run the ODBC file access utility in the account."

So depending on what you are trying to access, you may need to update you configuration first.  Look for your uvodbc.pdf file of the Universe Online Library and you will get a good bit of information on connecting via ODBC.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:juliemckenzie
ID: 33726675
Would this "file access utility" be the same for a unidata database?
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33726877
That is my understanding -- why are you accessing files here and not tables / views ?  
My PICK system shows UniData / Universe interchangeably, so believe the UniDK/OBDC and documentation applies to both -- at least we have been able to use on both, but we are also on an old version as this system has been upgraded in at least 6 years.
0
 

Author Comment

by:juliemckenzie
ID: 33726912
No tables were showing up, and only a few views in other tools like Excel, VS.Net, but nothing shows up under the connection in CR.  The DBA there says they call their tables files.  I would like to use tables and views, so I could just grab what data I need.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33727085
Think it just depends on the mode the U2 system was setup under.  The administrator can choose to install as an RDMS or flat file style and then allow or disallow SQL / ODBC access on top of that.  Since you can get to some things from Excel / VS.NET, I suspect that you have access but maybe it is a function of which driver -- as I mentioned, for some things I had to use the OLEDB driver which came with the UniDK whereas in other cases I could just use plain old ODBC Driver.

I wish I had Crystal locally to test as I have my Universe server sitting and available that I could have tested for you -- was just hoping that my limited input might help jog something in the minds of the Crystal Experts about.

The person who installed the system we use here made the later choice in both cases and so I inherited an NT system that had files for each table that didn't quite support querying from Excel and other tools they users were trying to use -- at that time I had to enable ODBC support -- I had to figure this out on my own and all I had handy was the UOL, so I am pretty confident I found all the details there.  If you don't have a copy, I can try to go back through all the steps for the DBA, but they should be familiar once you start talking about things like ODBC.ACCESS, HS.SCRUB, etc. << TCL commands that come to mind
0
 

Accepted Solution

by:
juliemckenzie earned 0 total points
ID: 34072856
It turns out I needed to use OleDB instead of ODBC.
0
 

Author Closing Comment

by:juliemckenzie
ID: 34100311
Connected to database using OleDB.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now