Active1 year, 4 months ago
- Crystal Reports Odbc Driver Download
- Crystal Report Dsn Connection
- Crystal Reports Db2 Odbc Driver
- Crystal Reports Odbc Connection Setup
I have a current set of code working to load a Crystal Report in c# with a server connection.
Here's the code for loading the report:
Current state: This works when the report is set up to connect to the database direct, but about half of them are set up to use an ODBC connection.
Attempt: I attempted to switch the server name to the name of the ODBC connection, but this still came back with the same
Failed to open the connection. Failed to open the connection.
error.Problem: I can't seem to figure out what I can change in my ConnectionInfo to be able to make it use an ODBC connection successfully. I keep getting a
Failed to open the connection. Failed to open the connection.
1337708 - Crystal Reports support of 64 bit Operating Systems 1217820 - Registry settings to configure ODBC database drivers and SQL Syntax joins 1850017 - Error: 'ORA-12505' when creating a JDBC connection based on Oracle database.
I'm aware of the solution to do a connection separately and set the reportsource, but this isn't feasible since there are many reports.
Thanks in advance!
oppassum
oppassumoppassum
2 Answers
Setting an ODBC connection at runtime is rathertricky, mostly because there are all these additional 'logon properties' and 'connection attributes' that need to be set:
On the other hand, rather than creating a
ConnectionInfo
object from scratch, you might be able to use the existing one, especially if you already designed your report using a similar connection:jjjjjj
Crystal Reports Odbc Driver Download
For legacy reports with SQL Server ODBC, using 'SQL Server Native Driver 11.0' might be needed.
This class should be combined with an implementation similar to this: crystal report failed to get data
NohlNohl
Not the answer you're looking for? Browse other questions tagged c#asp.netcrystal-reports or ask your own question.
I run Office 2016 64-bit, including Access, on Windows 10.
Corel painter free download. Crafting with full composition is an amazing utility.
I have an Access *.accdb database maintained by this MS Access instance.
Crystal Report Dsn Connection
And I have a 32-bit application (Crystal Reports 2008) which should access this db.
Therefore I tried to setup an ODBC DSN with the 32-bit Access driver using the 32-bit variant of the ODBC Administrator. This didn't work as apparently the relevant driver file odbcji32.dll is missing (discussed in http://answers.microsoft.com/en-us/office/forum/office_2016-access/unable-to-load-odbcji32dll/de67abd0-f4d8-40af-8e5f-1922b8393d7e) - and I installed an Access 2013 64-bit runtime.
Now I have the odbcji32.dll (version 10.00.10586.00) on my system and created a system DSN for this database - the ODBC Admin is happy with that.
Crystal Reports Db2 Odbc Driver
But when I try to access the db by Crystal Reports I get an error 'Unrecognized database format ..' and the filename. Then I tried to use this system DSN with other 32-bit applications: the same error. Telugu movie mp4 free download.
Crystal Reports Odbc Connection Setup
The very unfortunate status is now that I have to use 32-bit applications which should access *.accdb Access databases and can't get it working for unknown reasons.