Recent content by nigelrivett

>> You cannot expect to properly develop if you don't what you're working with. Don't really have the option here. It's not meant to be an IT department. I did try to go for a reinstall of notes but there would be a 10 day lead time for it. Think I should go for a rebuild of the machine but...

I managed to get a database list using Set dir = session.GetDbDirectory("") Set db = dir.GetFirstDatabase(1247) Do While Not (db Is Nothing) Debug.Print db.Title, , db.FilePath Set db = dir.GetNextDatabase Loop Favorites favorite.nsf Journal...

Looking at the registration for lotus notes automation classes it is pointing at the notes folder rather than the notes65 folder. Might try changing that on Monday. ====================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not...

I'm using late binding so that should be the same thing - not sure why you don't have to initialize the session. If I don't it gives an error that it's not initialized (hate the z). I think that I may be using a different object library as I'm on a client. Think you have the lotus notes...

Still can't get anywhere Here's the code Dim session As Object Dim MailServer As String Dim db As Object Set session = CreateObject("lotus.NotesSession") Call session.Initialize MailServer = session.GetEnvironmentString("MailServer", True) Set db =...

Think I've answered the server one. I was getting the mail server name but the database resides on XXNDMail01/place/company name. ====================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.

Dang. Sounds like this shouild be feasible then. I did try it with various combinations of database name and server name and got no result for any. I'll try restarting my machine just in case something has got screwed. Do you know what the server name should be? When I look at the environment...

Can't get an isopen = true. The said they had made me admin of my mail database but when I look at the effective access for me in notes everything is checked except Full Access Administrator, my access is designer. Is this the problem? The other thing I am not sure abot is the server name and...

I'm just testing this before going further We have a document folder of which I am manager. I'm guessing this isn't enough to enable me to open the database and I need to have Full Access Administrator? When I try to open the database (I assume that is the .nsf file?) the isopen gives false...

Thanks - looks like I'm in the right place. The problem is that the server maintanance is outsourced and takes a long time to get anything done. If we were to request changes we would ask them to deliver the attachments to a directory which looks like it is pretty simple from the server. The...

I have a requirement to get attachments from a mail account into a disk folder. I suspect the obvious way to do this would be to write an agent? But we don't have easy access to server development. I seem to be able to connect to the server (I think) but not to the mail database. In vb Set...

You can call the com object from an SP which means that you can already do (3). Can you re-code the com object functionality in t-sql and put it in an SP? This would probably be simplest but you might be losing re-use. It's usually better to import data without processing then process from a...

http://www.mindsdoor.net/SQLAdmin/TransactionLogFileGrows_1.html You can't delete the log you need to shrink it. Before you can shrink it you have to release entries. In a dev environment this usually means setting the recovery model to simple. ====================================== Cursors...

http://www.mindsdoor.net/SQLAdmin/TransactionLogFileGrows_1.html ====================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.

Your log file was full. It couldn't release entries because it couldn't log the checkpoint. Allowing it to expand cured this and allowed entries in the log to be re-used. You now have a very large log file which sounds like it is flling up the disk. Now you have added some more data and have a...