Changing Database on Crystal Report

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
Nancy VillaDirector of ITAsked:
Who is Participating?
 
Brian ChanConnect With a Mentor DBACommented:
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
 
rpkhareConnect With a Mentor Commented:
Which version of SQL Server and Crystal Reports?
0
 
Nancy VillaDirector of ITAuthor Commented:
SQL 2005 and Crystal XI
0
 
Nancy VillaDirector of ITAuthor Commented:
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
 
Nancy VillaDirector of ITAuthor Commented:
I figured it out.  

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

Nancy
0
All Courses

From novice to tech pro — start learning today.