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
Solved

SQL Not connected from crystal report msg : Unable to connect

Posted on 2011-03-12
3
350 Views
Last Modified: 2012-08-14
Hi

I am using crystal report to design reports with sql 2008 , from last 2 days I am not able to connect SQL from crystal report with specific database , I can design report with other database.

I had created many reports from that database but now its not connecting.
pl. help

Rajesh
0
Comment
Question by:rbs1968
3 Comments
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 500 total points
ID: 35115554
Please check whether the Login details you are provided are correct or not.
if this doesn't solves the problem then check whether driver you used to connect is Native Client or SQL OLE DB Provider. if its Native Client then Change it to SQL OLE DB Provider this may solved the problem.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 35116595
Are the databases on the same SQL Server?
If so did the permissions change for that database or for some of the tables?

mlmcc
0
 

Author Closing Comment

by:rbs1968
ID: 35127366
Pl. let me know how to do this as I am working on server it self as crystal report also installed on server.

Its working with other database and I had not changes any username password or any persmittion as I am working as SA and using same for connection.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help Required 2 39
Need help with a Crystal Report in my C#.Net application 2 26
SQL DATEADD 10 70
SQL Recursion 6 16
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

791 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