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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian ChanDBACommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rpkhareCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.