Solved

How to connect Crystal 8.5 to SQL Server 2005

Posted on 2006-10-23
3
247 Views
Last Modified: 2010-07-27
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
Comment
Question by:cdv
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 17789705
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
 

Author Comment

by:cdv
ID: 17791311
When I try to create an ODBC connection I get an unrecognized database error message. Perhaps I am doing something wrong.
0
 
LVL 30

Accepted Solution

by:
nmcdermaid earned 250 total points
ID: 17792700
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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question