Solved

connection lost to database

Posted on 2009-07-13
6
1,556 Views
Last Modified: 2013-12-09
I have a file name "information-A.GDB".  when i am trying to add this file to interbase database i get the following error

"Connection lost to database"
0
Comment
Question by:imran_fast
[X]
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
  • 3
  • 3
6 Comments
 
LVL 19

Expert Comment

by:NickUpson
ID: 24852471
please provide lots more detail, most likely "information-A.GDB" is an interbase database, so your description doesn't make sense
0
 
LVL 28

Author Comment

by:imran_fast
ID: 24857259
hi Nickupson!

i got a file informationA.gdb from a client and i wanted to add it to my interbase server.
My server is interbase 9 and client have interbase 6.5 when i am trying to add this to my server i am getting the following error.

"Connection lost to database"
0
 
LVL 19

Expert Comment

by:NickUpson
ID: 24857375
so you got an interbase database file from a customer, this has a good chance of being corrupt if it was provided like this. They would do better giving you a copy of a backup. A file copy of a database that is currently in use is often corrupt and can corrupt the original as well.
If the file is ok, you just need to place it on the same machine as interbase is installed (not a mapped drive or similiar)
if the problem is the very large version difference I would attempt to do a backup and restore.
I still don't understand what "trying to add this to my server " actually means, please give more detail
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 28

Author Comment

by:imran_fast
ID: 24888697
I installed Borland Interbase IBCONSOLE and when i am trying to add this file i am getting this error.

Any how i fixed the problem ..
0
 
LVL 19

Accepted Solution

by:
NickUpson earned 500 total points
ID: 24889665
I think the problem is the enourmous difference in version, get the customer to take a backup and use the newer version to restore it, that may get round the problem
 
can you create a new database, prove that interbase is working ok
0
 
LVL 28

Author Comment

by:imran_fast
ID: 24897779
I can create new database.

I fixed it by installing older version of Borland interbase and adding the database to it.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What's wrong with this T-SQL Foreign Key? 7 59
mysql database, schema and table creation 13 91
SQL replication over high latency link 10 67
.lee file containing data 5 50
This article describes some very basic things about SQL Server filegroups.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

726 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