Can I create either an ODBC connection or a connection string in VBA to get into a lotus notes database to pull data out of it?
views:
83answers:
4
+1
A:
I haven't had a need to work with Lotus Notes in a while, but ConnectionStrings.com usually is a good resource for things like this.
Tim Lentine
2009-10-22 21:19:24
Infinitely useful website!
Mohgeroth
2010-07-12 14:17:42
A:
I don't know about Access, but I used to connect to Notes in a DTS package. We had a special ODBC Notes driver that worked fairly well.
I think if you have the ODBC driver you can probably do it.
A word of warning, unless things have changed, Notes will throw you some curves. The form value data types can change from one release to another and this can really confuse the driver so that it returns nulls when there is actually data.
Good luck :)
wcm
2009-10-22 21:19:32
Good to know, thanks! The data I an pulling it nowhere near me so I would think I am in the dark confirming the data on that case... the option to do this in ODBC is being debated currently but we may wind up just doing a manual export through a query... work in progress
Mohgeroth
2009-10-26 15:06:58
It's been 9 years since I've mucked around with Notes. As I recall, the problem we were having was that a field in the document held a date that was originally saved as a string. Then, at some later point, they stopped saving it as a string and made it an actual date. So... all the values that were stored as strings came through as NULLs. There were other issues like that but my brain seems to have developed a leak.
wcm
2009-10-26 15:40:53
+3
A:
Yes you can. You need to install the "NotesSQL" ODBC driver for Notes (and you will need the Notes client on the machine running your VB code).
You can download the driver here.
And there is some more info here.
Ed Schembor
2009-10-22 21:21:32
+3
A:
Yes, there is an ODBC connector for Lotus Notes called NotesSQL. I used it years ago and you can find it on-line http://www.ibm.com/developerworks/lotus/products/notesdomino/notessql/
meme
2009-10-22 21:21:46