Passing data to Crystal Reports from MySQL with ADODB Connection 1

[GWHicks]

I have created an application front end for a MySQL database where the user can create new quotes. I am opening the connection with an ADODB connection string and want to pass the information to my Crystal Report from the selected quote number. What is the best way to do this? Currently I keep finding information on the web where they use either an OLEDB connection or an SQL connection. Do I want to change the connection method of my whole app to one of these? Or what is the best way to keep the interaction between MySQL, my app, and Crystal Reports open and clean?
TIA
Greg Hicks

 

[zemp]

What I like to do when the database for my app may vary or the connection is not always the same is to feed the cyrstal report directly from VB via a .ttx file. It is similar to setting up a custom databse for each report.

You should be able to find some information on .ttx file use in crystal reports help or at

http://www.support.crystaldecisions.com.

Thanks and Good Luck!

zemp

 

[zemp]

You can also check out the tek-tips crystal reports forums.

Start with forum149. Thanks and Good Luck!

zemp

 

[GWHicks]

Thanks for the info, I will try to dig up some instruction on using ttx files, I have not dealt with them yet. Your link to the support at crystal decisions does not work, I am sure I can figure out where it is, but if you have a newer link feel free to send it my way! And I added the Crystal Reports forum to my list. I will start keeping an eye on it and I should be able to figure this thing out with time!
Greg Greg Hicks
VB.Net (Newbie) Programmer

http://www.ajlb2.com

 

[zemp]

Sorry about the link, try

http://support.crystaldecisions.com/library/kbase.asp

Thanks and Good Luck!

zemp