Hi
this Problem arises in Crystal reports when you forget to pass the required
parameters please take care of Following things
1. check your User name and password which you are providing to the RPT file
it shuld be same what you are providing in Set database option in Crystal
Reports
in Set databse option of Crysdtal reports please make shure that proper
database is selwected for that report.
then Do Verify database some times this also works
2 if you have any subreport in that reports then you need to provide that
login info for that sub report also for all tables in that report send your
crystal object this function
Private Sub SetReportLogonParam(ByRef crt As ReportDocument)
Dim i As Integer
crConnectionInfo.ServerName = ConfigurationSettings.AppSettings("SERVER")
crConnectionInfo.DatabaseName = ConfigurationSettings.AppSettings("DATABASE")
crConnectionInfo.UserID = ConfigurationSettings.AppSettings("USER")
crConnectionInfo.Password = ConfigurationSettings.AppSettings("PASSWORD")
crDatabase = crt.Database
crTables = crDatabase.Tables
For i = 1 To crTables.Count
crTable = crTables(0)
crTableLogOnInfo = crTable.LogOnInfo
crTableLogOnInfo.ConnectionInfo = crConnectionInfo
crTable.ApplyLogOnInfo(crTableLogOnInfo)
Next
End Sub
bdnrao <[EMAIL PROTECTED]> wrote:
Dear all,
I have a problem to be solved. I am using VB.Net and crystal
reports v. 10.
When I am using the DSN in the vb code, it is generating error of
incorrect parameters - log on failed error, more fully described as
follows:
Logon failed. Details: IM002:[Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified Error in File
C:\WINDOWS\TEMP\{A55E05B8-7374-4C39-A101-A6FD31FEE142}.rpt: Unable
to connect: incorrect log on parameters
Source Error:
Line 82: crTableLogOnInfo = crTable.LogOnInfo
Line 83: crTableLogOnInfo.ConnectionInfo =
crConnectionInfo
Line 84: crTable.ApplyLogOnInfo(crTableLogOnInfo)
Line 85: Next
Line 86:
Source File: c:\inetpub\wwwroot\EPIC-05
\Dist_Week_Repo_Call.aspx.vb Line: 84
The connection information is as follows:
crConnectionInfo.ServerName = "xyz"
crConnectionInfo.UserID = "abc"
crConnectionInfo.Password = "abc"
Similar parameters are adopted in the crystal report also and the
connection is opening up there and I have used the fields of the
view generated through the code on the concerned page. Of course,
for the page to work, initially I created view in the oracle back
end, which will get change at run time depending on the parameters
passed on the page.
I am not able to fix the problem.
Any help will be appreciated.
Thanks,
BDN RAO
SPONSORED LINKS
Basic programming language Computer programming languages
Programming languages Java programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Arvind P. Chavan
Mob: +91-9820716814
---------------------------------
Yahoo! Music Unlimited - Access over 1 million songs. Try it free.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
