28 Nopember 2010 16:02
I want to use my database on SQL Azure in Crystal Report. So I want to link my reports with data contained not in a local db, but in a SQL Azure one.
Insiede Crystal Report I have created a new ADO connection to my SQL Azure, providing server, db, user, password, and Crystal Report have recognized the database. But when I go to the Database Expert and I try to set this ADO connection inside my report, I recieve this error:
L'operazione richiesta non è supportata dall'oggetto o dal provider (operation not supported by the object or by the provider)"
Why? How can i use my SQL Azure data in my Crystal Report reports?
30 Nopember 2010 1:47Moderator
Please create a UDL file to test the connection, ensure the connection is fine and then use the same connection string in your Crystal Report.
For UDL file, you can refer to:
Hope this helps,
Raymond Li - MSFT
- Ditandai sebagai Jawaban oleh Allen Chen - MSFTMicrosoft Employee, Moderator 07 Desember 2010 2:59
20 April 2012 14:36
I have the same problem. I tried the UDL file but it didn't change the problem.
I'm using the Crystal Reports 2008 runtime connecting to the SQL Azure database with ADO. The problem seems to be in SetTableLocation.
The error message makes it seem like the period in the database name is causing a problem.