Wednesday, March 21, 2012

how to connect in mysql odbc 3.5 using crystal report 9.0

helo!!! Is there anyone know how connect in mysql odbc 3.5 using crystal report 9.0. I have a big problem here. when im making a connection in crystal report using the RDO/ODBC connection, i end up a "test connection succeded" but when i click the the name of the odbc, "no item found"

Is there anyone who can help me pls.
sweet_babylhyn@.yahoo.com

Thankx!!!!Have you tried connecting via OLEDB provider for ODBC?

Are you able to connect to your ODBC from some other application, say, Microsoft Excel?|||Yes, I can create connection using ODBC in SQL SERVER 2005 or in MS-Access but in MYSQL ODBC 3.51 i can't... The connection is succeded but when i click the connection(odbc name), no items found. What should i do?

But when i used the odbc name in visual basic 6.0, it works but in crystal report 9.0, it did not.

Thanx for the reply...|||sorry, SQL SERVER 2000.|||Please apply the latest service pack for CR9.

http://support.businessobjects.com/library/kbase/articles/c2013269.asp

BTW, in most cases, scanning the Crystal knowledge base will get you your answer much sooner than posting to discussion forum.|||Thanx a lot... it works. How about viewing the rpt's in web. I use php in my application. Is their any rpt viewer for php?

Thanx again...|||There are tons of questions like that in Crystal discussion forum at businessobjects.com

To put it briefly, the PHP is multiplatform, but Crystal is not. That means, no direct support for viewing over web via PHP. However, you can use RDC to generate HTML or PDF files and pass them to the client. But only if you run on Windows.
Some people have been experimenting with converting Crystal JSP files to PHP, but I don't know if they have succeeded.

No comments:

Post a Comment