Link to home
Create AccountLog in
Avatar of yechan
yechanFlag for United States of America

asked on

Opening a 6.5 nsf file in 8.5

Hi Lotus Notes Expert,

I am wondering if it is possible to copy a *.nsf file that was created in 6.5, copy it onto a different machine and open it up in 8.5.

Come to think of it, I really don't care all that much whether it opens up in 8.5 or not, but I do like to grab the data and dump it into Access or Excel.

So far what I have tried is to copy the *.nsf file created in 6.5, created an ODBC Data Source with a Lotus NotesSQL Driver and pointed it to the nsf file.  When I try to connect to it via MS access I get the following error message: "[lotus][odbc_lotus_notes]cannot open specified database".

thank you

thank you
Avatar of MtnChick
MtnChick
Flag of United States of America image

I regularly use databases created in 4.5 in my current version of Notes (8.5) so I don't see any reason why that would be an issue.  The real question would be...does your ID have access to open it?  You can't open a Notes database through MS access or straight through Notes without the correct ACL permissions.
Avatar of yechan

ASKER

Gotcha.  That is great to read that opening 6.5 nsf files in Lotus 8.5 is not an issue.  I do not have an ID to open it.  Will talk to the administrator tomorrow.  Perhaps she can help me out.  

Since this my first day working with Lotus, please excuse this newbie question.  The Lotus Domino, is that a Server where all the *.nsf files are being stored?

Many thanks
ASKER CERTIFIED SOLUTION
Avatar of MtnChick
MtnChick
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Sjef Bosman
I usually grab Access or Excel data and dump it in a Notes database... ;-) Read up on Notes, you'll be astonished how much it can do!

http://www-10.lotus.com/ldd/dominowiki.nsf/
FYI, with few exeptions, the only time your .nsf changes is when you use an element not native to the release your db was created on.  So, if I were to create an XPage, my nsf (db) becomes an Notes 8 db instead of a 6.5 db, since xpages didn't exist with 6.5.

As for the NotesSQL stuff, here's some links that might provide information I surely can't give you. (Not my thing, sorry):
http://www.builderau.com.au/architect/database/soa/Create-an-ODBC-connection-to-a-Lotus-Notes-database/0,339024547,320282240,00.htm
http://www.databasejournal.com/features/mssql/article.php/3462011/Connect-to-Lotus-Domino-using-SQL-Server-Linked-Server.htm

Good Luck.

-TIM

Avatar of yechan

ASKER

Hi all,

sorry for responding so late.  Things here takes a while to push through let alone all the paperwork i had to fill out just to get a login.  

I think I will try IronClads solution as a last resort because I am afraid to muck around with the server (i.e. installing NotesSql) because it's a Windows 2000 box running Domino Server 6.5 and nobody here knows Domino Server in case it breaks down.  =(

Just to be sure.  If I create a database (i.e. nsf file) on the Domino Server 6.5 and copy that nsf file onto my local machine that has Lotus Notes 8.5 installed, I can open it?
Don't copy that directly from the server, as a file. Do it the Notes' way: make a replica of that database to your local Notes environment. It is in fact almost a file-system copy.

A Notes copy of a database creates a new database with all the data from the original database, but it is not a replica. The background replicator task copies documents between true replicas only, so that both sides will contain the same documents (unless specified otherwise).

And programming it in Notes? Not your cup of tea??
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account