Click here to Skip to main content
12,894,930 members (55,873 online)
Rate this:
 
Please Sign up or sign in to 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 27-Sep-12 19:56pm
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

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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..

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!
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170424.1 | Last Updated 29 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100