CODEWITHSUNDEEP
lotus-notes
naresh mesineni
naresh mesineni

Reputation: 115

access Lotus notes database using ODBC and C#

Please provide some sample code how to access Lotus notes database using ODBC and C#. Now I am able to accessing database suing NotesSession() class.but I want how to do via ODBC

Thanks and Regards Naresh Mesineni

Thanks for your replay.Still I am facing some problem.I downloaded the NotesSQL 8.5 and installed. I am trying to get the Notes data using ODBC still It is throwing some error.Here I am attaching connection string.

string sConnString = "Driver={Lotus NotesSQL 8.5 (32-bit) ODBC DRIVER (*.nsf)};" + "Server=serverXXXX;" + "database="DBName;" "Uid=userxxx;" + "Pwd=pwdxxx";

OdbcConnection odbccon = new OdbcConnection(sConnString); odbccon.Open(); while opening connection it is throwing error ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" Please provide some solution.it is help full if any one provide sample code with getting data from Notes.

Thanks and Regards Naresh Mesienni

Upvotes: 1

Views: 5496

Answers (2)

sebastianf182
sebastianf182

Reputation: 9978

How about LEI? (Lotus Enterprise Integrator)

I think is free with Domino and it lets you create ODBC connections and schedules jobs, etc.

You should look into it.

Upvotes: 0

Ken Pespisa
Ken Pespisa

Reputation: 22266

You'll need to use the NotesSQL driver, and the help file is here.

You can setup a DSN, or use the connection strings found on connectionstrings.com

Driver={Lotus NotesSQL 8.51 (32-bit) ODBC DRIVER (*.nsf)};Server=myServerAddress; Database=dbPath\myDb.nsf;Uid=myUsername;Pwd=myPassword;

Upvotes: 1

Related Questions