Re: VB.NET/Crystal - How do I change a report's connection "integrated security" to FALSE?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Bernie Yaeger (berniey_at_cherwellinc.com)
Date: 01/29/05 

Date: Fri, 28 Jan 2005 23:43:26 -0500

Hi,

ON Crystal 10 (perhaps 9 as well):
1. go to 'set database location'
2. in the top, open the name of the server and properties until you see the
tables
3. on the bottom, click 'history'
4. select the server name in the bottom
5. you will now see a connection info request
6. fill out the request and enter user id and pwd; uncheck 'use integrated
security'
7. click next
8. click finish
9. now select the table to replace the table above - same name
10. click the 'update' button

You're done. I had to do this to over 150 reports some time ago. It's a
bit buggy, so after you save, reopen the report to verify that the change
'took'.

HTH,

Bernie Yaeger

"Guest" <Guest@aew_nospam.com> wrote in message
news:Opf1P6YBFHA.3472@TK2MSFTNGP14.phx.gbl...
I was able to change "integrated security" to FALSE by pausing my SQL Server
& then, in the report designer, I right click on the
FieldExplorer/DatabaseFields and select 'Verify Database' from the menu.
Since it can't find the database, it prompts for the connection info.
Start-up SQL server again & then fill out the connection info (with
integrated security unchecked). Then save your report.

:>kris

> I am writing a Windows forms VB.Net/MS SQL application via VS 2003 that
> utilizes Crystal Reports. I want to be able to dynamically set the
> report data source at run time.
>
> I'm trying to change the the reports "integrated security" from TRUE to
> FALSE via the "Set Location" dialog in the report designer with no
> success. It is not intuitive (at least not to me.)
>
> I get the following error:
>
> "Error in file....Invalid table number."
>
> The error is being generated at this line of my code:
>
> 'DatabaseName is changing at runtime, specify the table location.
> CrTable.Location = "UpsizeUATSQLBackup.dbo." &
> CrTable.Location.Substring(CrTable.Location.LastIndexOf(".") + 1)
>
> If I change "UpsizeUATSQLBackup.dbo." to the original db location i.e.
> "UpsizeUATSQL.dbo" it works fine.
>
> I've seen other posts on the web that state that the "integrated
> security" for the report connection has to be FALSE, otherwise the
> connection is hard coded into the report.
>
> Article c2011430 on CR support site seems to indicate that you can
> change it in Crystal 9, where previously you could not, due to a bug.
>
> My question is how do I change the report's connection "integrated
> security" to FALSE?
>
> Tks for any guidance/help you can provide.
>
> ....Henry
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
User submitted from AEWNET (http://www.aewnet.com/)

Quantcast