Click here to Skip to main content
12,400,556 members (62,960 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB SQL-Server Access VB.NET , +
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

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

1 solution

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

Solution 1


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

Advertise | Privacy | Mobile
Web01 | 2.8.160721.1 | Last Updated 31 Oct 2013
Copyright © CodeProject, 1999-2016
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