Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reports from VB using MySQL database

Status
Not open for further replies.

mmarino

Programmer
Mar 22, 2002
42
US
I can pull and save data from my VB program without a problem. When I try to use Crystal Reports I can display a report if it has no parameters, and if the "Save Data with Report" option is checked. I need to be able to pass parameters, when I try this, it complains and gives me an error "Cannot open SQL server".
I'm using the OCX method (added a component into my VB form). And I pass the connection information in my code:
Code:
        Me.rptReport.Connect = "DSN=" & servername & ";UID=" & username & ";PWD=" & passwordStr & ";DSQ=" & dbname
How can I get rid of that error so I can pass parameters?
Any help is appreciated. Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top