Solved

Changing Database on Crystal Report

Posted on 2008-10-26
5
939 Views
Last Modified: 2012-05-05
I have received a crystal report for a sql application that we run.  The report database needs to be changed to our database but when I select Select Datasource location, I receive the error

Database Connector Error '42s02:[microsoft]odbc sql server driver][sql server]invalid object name
'ngqa_interface_base.dbo.lab_nor'. [database vendor code 208]'

The only place I see ngqa_interface_base  is in hte properties under the database that I wish to chage.

Any suggestions?

Nancy
0
Comment
Question by:Nancy Villa
  • 3
5 Comments
 
LVL 5

Accepted Solution

by:
Brian Chan earned 250 total points
ID: 22808987
You are on the right track, except you having problem on the odbc connection to the database. Could you please post more detail on how did you set up the odbc?
0
 
LVL 8

Assisted Solution

by:rpkhare
rpkhare earned 250 total points
ID: 22810311
Which version of SQL Server and Crystal Reports?
0
 

Author Comment

by:Nancy Villa
ID: 22812221
SQL 2005 and Crystal XI
0
 

Author Comment

by:Nancy Villa
ID: 22812272
The ODBC connections are pretty standard.
SQL drivers
Server ngdb01
TCP/IP
Change Database to NGTest
Use ANSI quoted identifers
Use ANSI nulls, paddings and warnings
perform translation for character data
0
 

Author Comment

by:Nancy Villa
ID: 22815425
I figured it out.  

I needed to update each table individually then it would take my database

Nancy
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now