Cannot see System DSN in Crystal Reports 2008 on Vista/Windows 2008
I've been making quite a bit of progress in switching migrating our Crystal Reports 8.0 reports and apps to Crystal Reports 2008 on our Windows 2008 server, but am currently stuck on a DSN issue that I hope someone here can help me out with.
When I go to select a new ODBC data source in Crystal Reports 2008, the only ODBC data sources that show up in the list are User DSNs. These reports will be served via our intranet website, so I need to use System DSNs. The same is true on both my development computer running 64-bit Vista and the production server running Windows Server 2008.
I'm using Visual Studio 2008 (C#) for development along with Crystal Reports 2008 (not the Crystal Reports Basic that comes with Visual Studio).
How can I use a System DSN? Any help or advice will be much appreciated!