PC Review


Reply
Thread Tools Rate Thread

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

 
 
sarah.lawrence@gmail.com
Guest
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
Reply

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
Anyway to print crystal report direct to printer at client side? =?Utf-8?B?VGFuaw==?= Microsoft ASP .NET 0 19th Aug 2006 03:24 PM
Crystal Report 8.5 and Microsoft Shared Fax Driver =?Utf-8?B?UGV0ZXI=?= Windows XP Print / Fax 0 4th Mar 2005 10:41 PM
Crystal report Images not displayed remotely on client =?Utf-8?B?U21pdGg=?= Microsoft Dot NET 0 26th Oct 2004 01:05 AM
Unleash XML support from native Oracle Database driver Daisy Microsoft ADO .NET 1 17th Dec 2003 02:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:39 AM.