Click here to Skip to main content
15,903,175 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I got the error in crystal report
Unable to connect: incorrect log on parameters
i am trying to write the dataset through xml and than i got success in writing in xml but i can't see in the crystal report file.
That gives the error Unable to Connect : incorrect log on parameters
Posted
Updated 27-Sep-12 23:32pm
v3
Comments
OriginalGriff 28-Sep-12 3:08am    
This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

1 solution

I believe that you have set up your dataset / database with password. For some reasons when crystal report have to connect with the dataset / database you also have to supply the password for your database in order for it to connect..

VB
Dim rpt As New prreport2() 'prreport2 is the crystal report file
dim rec as Adodb.Recordset
rec = gSQL("select * from table1") ' this would be the query to connect
rpt.SetDataSource(rec)
rpt.SetDatabaseLogon("", "cpgc2012") 'this is to set the password on runtime


That was my code in VB i'm not sure how to do it in XML.. but that was the idea that i have..

hope this helps!
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900