 |
BOOK: Professional Crystal Reports for VS.NET
 | This is the forum to discuss the Wrox book Professional Crystal Reports for Visual Studio .NET by David McAmis; ISBN: 9780764544033 |
|
Welcome to the p2p.wrox.com Forums.
You are currently viewing the BOOK: Professional Crystal Reports for VS.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
January 31st, 2005, 11:14 AM
|
|
Authorized User
|
|
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Database Connection
I am creating an application using Visual Basic .Net, Crystal Reports 10 and Microsoft Access. How do I set the database connection information at runtime?
During development the database (mdb) is in a particular location, however; the application could install the database (mdb) in a different location.
Thanks
|
|
January 31st, 2005, 03:04 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
|
|
Well, how would you determine where the database is? Are we talking a different path or different server?
Brian
|
|
January 31st, 2005, 03:10 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Hi there,
Look into the LogonInfo object and the ApplyLogonInfo method.
For an example, look here:
http://support.businessobjects.com/l...s/c2010371.asp
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
January 31st, 2005, 10:50 PM
|
|
Authorized User
|
|
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I read in 'Professional Crystal Reports for Visual Studio .Net 2nd Edition' that this behavior is due to a bug the software. Does anyone know of a workaround? As BusinessObjects release an update to correct this?
|
|
February 1st, 2005, 03:09 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
What behavior is a bug? Doesn't this work for you?
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
February 1st, 2005, 09:45 AM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I think he's talking about a "Login Failed" error when setting these parameters. I'm getting the same results when using Crystal Reports for .NET. If anyone has an answer, please share.
Thanks.
Dale
|
|
February 1st, 2005, 02:34 PM
|
|
Authorized User
|
|
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I apologize for not being more clear. Yes, the "Login Failed" error when setting these parameters.
|
|
February 1st, 2005, 05:53 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
For what account do you get the error?
Did you grant the account that the Web server uses (ASPNET or Network Service) the appropriate permissions in the database?
We successfully used the LogonInfo to change the database at run-time in a few apps....
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
|
February 2nd, 2005, 11:16 PM
|
|
Authorized User
|
|
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
This is for a fat client application, not a web application.
I am just using the default account in the Microsoft Access database.
|
|
|
