Database Engine Error: Index does not exist.

Hi
I am facing an issue while running a dBase applicaton it throws following error:
Database Engine Error:  Index does not exist.
The reason what I believe is that I have moved all the database to one single server where we have hosted both the database that exist on 2005 and 2000.
Kindly please help me to resolve this issue.

Thanks in advance
desaiviveksAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

desaiviveksAuthor Commented:
Require urgent attention
0
pcelbaCommented:
If your application is really dBase then it seems you did not move all necessary files. Databases have DBF extension, indexes should have MDX, NDX, or eventually IDX and CDX if you are using FoxPro.

If you are using SQL Server then indexes are inside the database and your problem is somewhere else. Yo should check database integrity by DBCC CHACKDB command.

So, you should say what database engine are you using and the check if all files were moved properly.
0
pcelbaCommented:
The SQL command to check the database integrity is

DBCC CHECKDB (DatabaseName)

You should also post more info about the error. I don't believe it is so short without details.
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

desaiviveksAuthor Commented:
04/22/2010 05:47:21.07
R:\RLEB\RLEB.exe
R:\RLEB\zcontrol.cc
ZTEXT::INIT
1299
239
Database Engine Error:  Index does not exist.
--
Here is the error message
0
desaiviveksAuthor Commented:
Please see the result after running the
DBCC CHECKDB (DatabaseName)

CHECKDB found 0 allocation errors and 0 consistency errors in database <DatabaseName>
0
pcelbaCommented:
The problem is definitely not on SQL Server but in your dBase application.

It means you did not copy all necessary files or the files are in different folder or this application (RLEB.EXE) does not support data folder change.

If you have source code available then you may look into file zcontrol.cc (probably line no. 1299) what index is necessary. The object is called ZTEXT and the error is in its Init method most probably.

If you have no source code available then you have to ask the application vendor what is the right scenario to move data to another server and what configuration changes it requires.
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
desaiviveksAuthor Commented:
Appreciate your quick reply. Let me check out with my Vendor.
0
desaiviveksAuthor Commented:
Got the solution with the clue provided.
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
Microsoft Applications

From novice to tech pro — start learning today.