Click here to Skip to main content
12,945,066 members (48,702 online)
Rate this:
 
Please Sign up or sign in to vote.
i have an application that uses crystal report XI for reporting and now my problem is the application runs both MS Access and SQL Server right now the connection properties of the crystal report is set to MS Access so when i use Access there is no problem with previewing the report but if i want to view now in SQL Server it gives me a login form. My question is how to change the connection properties via code from MS Access Properties to SQL Server Properties.

Please i need your help, i can't manually change the connection properties because the report is being deploy now to the customer. Sorry for my Bad English i hope you understand a little bit

Any help would be appreciated.

Thank you very much

Platforms
-> VB.NET 2005
-> Crystal Reports XI
-> MS Access 2003
-> SQL Server 2005
Posted 8-Aug-12 16:34pm

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 4,651
CHill60 3,055
Maciej Los 2,423
Jochen Arndt 1,910
ppolymorphe 1,765


Advertise | Privacy | Mobile
Web01 | 2.8.170518.1 | Last Updated 31 Oct 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100