• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

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
0
Raybone
Asked:
Raybone
1 Solution
 
HemanthaKumarCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now