PC Review

Thread Tools Rate Thread

Crystal Report error when using sql native client driver withunderscore in database name

Posts: n/a
      30th Mar 2009
We currently run Crystal Reports programmatically in VS 2008, using C+
+ and connect to a database in the report using odbc. If our database
name has an underscore in it, all works great if we use the standard
Sql Server driver. However, if using the Sql native client driver, an
error occurs while trying to preview the report that says "This field
name is not known.". I am using Crystal Reports XI Release 2. I have
tried the sql native client driver for 2005 and the most recent one
from 2008 with the same results.

If we do not run Crystal programmatically, all works great as well.
The error will actually occur if I log onto the report, then issue a
Verify() to the IDatabasePtr and then call GetSQLQueryString(), a
_com_error is thrown with the above error.

Everything works great if no underscore is present in the database
name. Any ideas? Can't find anything on the Crystal support site
regarding this specific problem.
Reply With Quote
New Member
Join Date: Nov 2011
Posts: 1
      23rd Nov 2011
Use OLEDB and don't sqlnative. regards
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Driver or SQL Native Client for ODBC connections MM Microsoft Access Queries 1 10th Sep 2009 01:57 AM
How to have access to the fields in the crystal report using VB.NET (outside the design of the crystal report) with SQL statements? amiga500@gmail.com Microsoft Dot NET 0 24th Oct 2007 04:38 PM
Crystal Report 10 and crystal report viewer control Harshil Microsoft Dot NET Framework Forms 0 9th Jul 2004 04:50 PM
Change Crystal Report Zoom Level using percentages in Crystal Report Viewer (Dotnet) Alex Stevens Microsoft Dot NET Framework Forms 1 30th Jun 2004 12:34 PM
Change Crystal Report Zoom Level using percentages in Crystal Report Viewer (Dotnet) Alex Stevens Microsoft Dot NET 1 30th Jun 2004 12:34 PM




All times are GMT +1. The time now is 03:41 PM.