Link a Crystal Report report with an SQL Azure database

Question

Hi,

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:

"Not Implemented

Source ADODB.Connection

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?

Thanks

 

Answer 1

Hi Delfins,

 

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:

http://msdn.microsoft.com/en-us/library/e38h511e(VS.71).aspx

 

Hope this helps,

Raymond

---

Raymond Li - MSFT

Answer 2

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.

Jim Mahan