Error Accessing database split into many files
girish.joshi
Member Posts: 407
Hi,
I working with a proprietary Navision database that is 15gb in size and split over 8 files. Prior to performing an upgrade to Navision 4.0, the database was copied, using hotcopy, to another location on the drive but with the same file names. The original database was upgraded to 4.0 from 3.01.
4.0 clients can connect to the new database files without any problem.
However, when I try to connect with 3.01 client to the old database files (in a new location, with a new zup file), i point it at the first db file, and I receive an error message telling me that the second database file is already in use. One problem though, the second database file is the wrong one! it's looking in the original location of files!
Is there anything I can do about this? I'm guessing that somewhere in the header of the first file the path information is encoded, and after the files were copied and moved, this path information became invalid, but since we had new files there, with the same name, it thinks it the right stuff.
Does anyone have any ideas?
I working with a proprietary Navision database that is 15gb in size and split over 8 files. Prior to performing an upgrade to Navision 4.0, the database was copied, using hotcopy, to another location on the drive but with the same file names. The original database was upgraded to 4.0 from 3.01.
4.0 clients can connect to the new database files without any problem.
However, when I try to connect with 3.01 client to the old database files (in a new location, with a new zup file), i point it at the first db file, and I receive an error message telling me that the second database file is already in use. One problem though, the second database file is the wrong one! it's looking in the original location of files!
Is there anything I can do about this? I'm guessing that somewhere in the header of the first file the path information is encoded, and after the files were copied and moved, this path information became invalid, but since we had new files there, with the same name, it thinks it the right stuff.
Does anyone have any ideas?
0
Answers
-
How do you open the database?
Last time I opened a split database from a client you had to put all filenames in the open database window separated by a '+'
Like
database1.fdb+database2.fbd
Have you done this?0 -
No, I didn't, but I just did and it worked. Thank you.0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
