Accessing Notes Databases via VB

I'm having trouble accessing a Notes Database that's on my server, via Visual Basic. I'm sure it's a simple syntax thing, since I have no such problem when the database is in the default directory (Notes/Data) on the Local server. Here's the code:

Dim session As Object, db As Object, view As Object

Set session = CreateObject("Notes.NotesSession")
Set db = session.GETDATABASE("", "Benefit.nsf")
Set view = db.GetView("EmpSS")

This works great since it's the Local server. When I try to go to my server, I get an error trying to set the view, saying the database isn't open. Please let me know what the syntax should be for:

Server = "HUDSON/HudsonGeneral"
Database = "Notes/Data/Apps/Benefit.nsf"

I've tried many variations of the server name & database path, but with no luck.

Thanx
RayboneAsked:
Who is Participating?
 
HemanthaKumarConnect With a Mentor Commented:
Hi

Use
Server = "HUDSON/HudsonGeneral"
Database = "apps\\benefit.nsf"

As in Database you no need to enter the data directory, by default it searches data directory.

Good Luck
~Hemanth
0
 
RayboneAuthor Commented:
Thanks,

I had tried:

Server = "HUDSON/HudsonGeneral"
Database = "apps\Benefits.nsf"

That extra \ did the trick!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.