Home > Odbc Error > Odbc Error With Crystal Reports

Odbc Error With Crystal Reports

Select the "Convert Database NULL Values to Default" check box and the "Convert Other NULL Values to Default" check box.If the report is based off on ODBC driver, enable tracing to Copy the query into a text editor; then use your database server's query tool to run the query.If the option appears in Crystal Reports, click Reset in the Show SQL Query If you are passing any parameters or variables to it and the data types dont convert could be a cause. By creating an account, you're agreeing to our Terms of Use, Privacy Policy and to receive emails from Spiceworks. weblink

Specifically data typing the parameters and variables could resolve the problem. Clear the links it automatically creates and create my own link between Tickets.Assigned_To = Users.ID. Another example of a setup that will cause this error is if your data is an XML source on a remote web server, but your computer doesn't have Internet access. To fix the error, you can create an alias field in the database dictionary to remove the SQL reserved word.

If I only put fields from the Users table on the report, it works. and/or other countries. The Report Viewer -> 32-bit (x86) ODBC Database Driver -> Your databaseSteps to Configure Data Source Connections This helps if you are the person who designs the reports and sets up The ODBC driver version is SQL Server 2000.85.1117.00 IP Logged jkwrpc Senior Member Joined: 19 Jun 2007 Location: United States Online Status: Offline Posts: 432 Posted: 07 Nov

Could it be because it doesn't exist as referenced? Verify and revert.NOTE : If we do not receive your reply within two business days, this post would be marked assumed answered and would be moved to answered questions pool. 0 Some report reference multiple data sources. On the server, the ODBC data source might be pointing to the wrong location for the PostgreSQL ODBC driver.

It does seem to be in the stored proc. As you can see at the picture above 0 Thai Pepper OP DanaR Jan 22, 2013 at 4:49 UTC In Crystal Reports, where are you pasting the SQL Also, ask the person who maintains the database to help out, because database user permissions could cause connection issues. On the Database tab, clear the "Use Indexes or Server for Speed" option.

Ensure that null values are not being passed to subreports. Or, maybe it's not configured to respond to you... Your feedback is appreciated. You may get a better answer to your question by starting a new discussion.

The error Msg is: ODBC error; [Microsoft][ODBC SQL Driver] Invalid character value for cast specification. Add Cancel × Insert code Language Apache AppleScript Awk BASH Batchfile C C++ C# CSS ERB HTML Java JavaScript Lua ObjectiveC PHP Perl Text Powershell Python R Ruby Sass Scala SQL Comments (0) Brazil France Germany Netherlands United States Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Products Digital Experience Platform DigitalFactory Comprehensive solution for crafting and managing sophisticated There is a problem the crystal report and odbc drivers that connected at db?

If the report contains one or more subreports, open it in Crystal Reports and, on the File menu, click Report Options. http://brecnc.org/odbc-error/odbc-error-oracle-odbc-numeric-value-out-of-range.html Just takes a bit of work to setup and configure the connections properly. For example, you can create the alias field cm3rm1.group_alias that is an alias of the original field cm3rm1.group. In this case, data sources are referenced by Data Source Name (DSN).

If so, I believe a straight Join would get you what you need (tickets with comments and who is assigned to them)? 1 Pimiento OP Shelly6898 Feb 14, Please refer to solution P29232 for information on what versions of Crystal Reports are supported by Progress.Business Objects/Crystal Decisions provide the article "How to resolve join syntax errors in Crystal Reports 8.5" that details the manner in which this issue can On UNIX, similar tracing can be enabled in the system information file (.odbc.ini).Once you enable tracing, run the report again from a browser to generate the tracing log. check over here Email Reset Password Cancel Need to recover your Spiceworks IT Desktop password?

By creating an account, you're agreeing to our Terms of Use and our Privacy Policy Not a member? The data source is invalid: '[] '. Does the generated SQL query run in the SQL management studio? 0 Poblano OP Lida763 Jan 21, 2013 at 11:21 UTC The query executed succesfully at the SQL management

Can you show us your Select Expert window?   And I'm curious what you are trying to get with this report?

I am not sure of the need to link with Inner Join? Help Desk » Inventory » Monitor » Community » {{offlineMessage}} Store Store home Devices Microsoft Surface PCs & tablets Xbox Virtual reality Accessories Windows phone Software Office Windows Additional software Apps What should check at odbc connections? 0 Mace OP RealityCheque Jan 21, 2013 at 1:21 UTC Just check that it's pointing to the right DB on the right Thomas Meunier November 22, 2011 at 15:45 PM 0 Likes 18 replies + Show more Share & Follow Privacy Terms of Use Legal Disclosure Copyright Trademark Sitemap Newsletter Veritas.com Support Veritas

All Rights Reserved. Some components may not be visible. When i select one field from each table  it displays, odbc error :near 'tickets1' :syntax error Error detected by database DLL.   For what reason this happened and how to solve it? http://brecnc.org/odbc-error/odbc-error-merant-odbc-sqlbase-driver.html How can i resolve it? 0 Mace OP RealityCheque Jan 21, 2013 at 11:57 UTC Do you have another PC you can test this from?

Related concepts Alias fields HP Service Manager Interactive Installation Guide Explore What's new in Service Manager 9.40Help Center HomeNavigate the documentation Connect HP Live NetworkITSM Blog for HP IT Service Terms of Use Privacy Policy Trademarks License Agreements Careers Offices Home Crystal Report ODBC error syntax error by Lida763 on Jan 21, 2013 at 8:47 UTC | Crystal Reports 0Spice Down Any help... 0 Kudos Reply Re: Crystal Report Connection Error to ODBC Amruta_Purandar Level 6 ‎09-05-2005 04:58 AM Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email Creating your account only takes a few minutes.

Open the report file or RPT file in a full version of Crystal Reports Go to the database wizard inspect the following database properties Type of database diver If ODBC, Case If your web application dynamically changes a report's data source at runtime, ensure that the schema of each database matches the schema of the database that the report was originally designed If you have developed a web application that modifies the SQL statement through code, ensure that only the WHERE clause is changed. Another example is if your ODBC data source has a different name on the computer that created the report, from the computer that is running the report.

After you run the report, disable tracing and review the log file for additional "Error" or "Busy" messages. ResolutionPlease note that Progress does not provide support for Crystal Reports 8.5 or lower. However do the normal reports run fine.