Wrox Programmer Forums
|
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
 
Old January 31st, 2005, 11:14 AM
Authorized User
 
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

 
Old January 31st, 2005, 03:04 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Well, how would you determine where the database is? Are we talking a different path or different server?

Brian
 
Old January 31st, 2005, 03:10 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old January 31st, 2005, 10:50 PM
Authorized User
 
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?

 
Old February 1st, 2005, 03:09 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

What behavior is a bug? Doesn't this work for you?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
 
Old February 1st, 2005, 09:45 AM
Registered User
 
Join Date: Feb 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old February 1st, 2005, 02:34 PM
Authorized User
 
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I apologize for not being more clear. Yes, the "Login Failed" error when setting these parameters.

 
Old February 1st, 2005, 05:53 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old February 2nd, 2005, 11:16 PM
Authorized User
 
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is for a fat client application, not a web application.
I am just using the default account in the Microsoft Access database.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Connection to Access Database reachsevar ASP.NET 2.0 Basics 1 November 28th, 2007 08:56 AM
Database Connection oneillg PHP Databases 1 October 17th, 2007 04:48 PM
Database Connection kapi.goel SQL Language 2 February 14th, 2006 07:01 PM
database connection Nitin_sharma Classic ASP Databases 1 February 8th, 2005 10:23 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.