• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

How to connect Crystal 8.5 to SQL Server 2005

I have numerous Crystal Reports all created with CR 8.5. They all retrieve data from Access .MDB databases.

I am currently experimenting with upgrading these Access databases to SQL 2005 Express which I have now successfully done. However I cannot find a way to get my Crystal Reports to link to the .MDF database instead of the .MDB database.

Any pointers either to how to do it or some documentation that describes how to do it will be appreciated.
 
0
cdv
Asked:
cdv
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
I use an ODBC connection to connect about a hundred CR 8.5 reports directly to SQL 2000 SP's, no problems.

All reports are executed via a VB reporting tool, sometimes feeding parameters directly from VB to the SQL SP, and picked up by CR.
0
 
cdvAuthor Commented:
When I try to create an ODBC connection I get an unrecognized database error message. Perhaps I am doing something wrong.
0
 
nmcdermaidCommented:
With SQL Server, you do not connect to a file (MDF). You connect to a service.

You need to create a SQL Server ODBC connection and connect to the SQL Server service. You simply specify a server and login details.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now