-
Jan 15th, 2019, 09:56 AM
#1
Thread Starter
Member
[RESOLVED] A Tale of two projects
the bain of everyone everywhere, two projects, two reports. One written 6 months ago, works like a champ,
the other one (current project) wants to throw the database login box whenever the report is run, both take parameters (single int parameter for row ID)
SQL 2012, VS 2017 Framework 4.5.1 target, both are set to any cpu prefer 32 bit
both reports run off of stored procs in the database
both databases have the same security group with the same permission set (standard)
I went through each project, one has a few more references to crystal than the other, but they both work on my dev box flawlessly, not so much in production.
Nothing i have tried via all the answers i can find has worked, runtimes on my box same as runtimes on target PC.
at wits end and lack the hair to pull any out.
code is as follows
Code:
string p = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
p += @"\CategoryReport.rpt";
int OrderID = id;
var rd = new ReportDocument();
rd.Load(p);//+@"\rptSeculsionAOD.rpt"
rd.SetParameterValue(0, id);
crvReportViewer.ReportSource = rd;
crvReportViewer.DisplayToolbar = true;
second place is just the first loser...
-
Jan 25th, 2019, 03:22 PM
#2
Thread Starter
Member
Re: A Tale of two projects
Well, 286 views and no answers...
heres the answer...
When using SQL2008 server, you must use the SQLADODB connection type under the OLEDB(ADO) heading in the database connection. I was using SQLCLNI out of habit since the last job i was at had SQL2012 (which has a native client) 08 does not.
Corrected problem report connections and it all works now.
second place is just the first loser...
-
Jan 25th, 2019, 03:22 PM
#3
Thread Starter
Member
Re: A Tale of two projects
dont know why this went twice...
Last edited by dirty_howi; Jan 25th, 2019 at 03:23 PM.
Reason: duplicate
second place is just the first loser...
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|