Rank: Newbie
Groups: Registered
Joined: 1/18/2019(UTC) Posts: 1  Location: NJ
|
I m trying SEAL reports for the first time and not able to connect to Oracle database.
Do SEAL reports support Oracle database connectivity?
If so can someone share here the sample connectivity strings with DSN or how to connect Oracle DB fro SEAL?
Thanks,
Ramkumar
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
You need first to install an configure the Oracle OLEDb Driver on your computer.
So get the one you want (32bit or 64bit) from Oracle site (search Google for 'oracle provider for ole db download')
Then set you connection string (search 'oracle ole db connection string')
Seal Report is a standard .Net application connecting to Oracle....
Good luck.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/22/2019(UTC) Posts: 2 
|
I had the same task today. My solution:
1. Decide if you want to use a x86 or x64 installation - Oracle doesn't allow both versions on one system (must be the same as your application)
1. Get the Oracle InstantClient Basic and ODBC extension from the Oracle website (both are .zip-Files)
2. Unpack both into a new subdirectory - there should be a install_odbc.exe in there afterwards
3. put your tnsnames.ora file into this directory
4. The instantclient needs a specified vc_redist install, in my case for 12.2 it was the vc++ 2013 redist x86 v12.0.40660 - even for a x64 instantclient! Otherwise you can't configure the ODBC connection.
5. Configure your ODBC32 / ODBC64 Connection - I made a system DSN
6. In the Seal Report Designer I make a new connection, click directly on the "..." at the end of "Connection string" and choose "Microsoft OLE DB Provider for ODBC Drivers".
7. Just fill the form with all requested information, like DSN name, user / password
That's it!
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Thank you for the post,
Instead of using Microsoft OLE DB for ODBC, which requires an ODBC connection defined on your computer, I recommend to use the native Oracle Provider for Ole DB.
This comes with the Oracle download: 64-bit ODAC 12.2c Release 1 (12.2.0.1.1) for Windows x64
Once you have configured your TSNNAME, just select the Oracle Provider and set your TSNNAME.
The connection string will be Provider=OraOLEDB.Oracle.1;Data Source=YOUR_TNSNAME
I presume that using native driver will offer better performances and behavior...
Good luck.
|
 1 user thanked epf for this useful post.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/22/2019(UTC) Posts: 2
|
Thank you for clarifying your solution. I will give it a try.
So far I always used ODBC drivers because they are available for the most of our data sources and there are a lot of ODBC libraries for Python which I use the most. I've seen diagrams where OLEDB was an additional layer to ODBC for SQL databases and others where it was using direct access. But the way it works may have changed over the time and database.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
