Solved

Link a ASP.NET application using SQL Server to a Lotus Note Database

Posted on 2008-10-17
3
1,383 Views
Last Modified: 2013-12-18
I made a application in ASP.net for internal use. It asp.net and it use a microsoft SQL server 2005 for the databases.

Almong others table in my database, i have a Client table. But we got a application call saleplaces to deals with those kind of things. I dont really know this application (for now) but i know it run on lotus notes. here a link for that application

http://www.salesplace.com/web/cms.nsf/pages/products_sales.htm

So, i want to replace my "Client table" with some kind of link to that application.
I though of 3 solution, in order of interest.
- The best way whould be if i could have a datatable in my dataset (the .xsd file).
- The second one whould be if i could have a linked server on the MS SQL server to conect to lotus notes.
- The third (and as a last resort) whold be to find a way to update (automaticly please) the SQL "Client table" whith the lotus notes database.

So, What I need to apply one of those solutions?
0
Comment
Question by:David Robitaille
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 20

Expert Comment

by:brwwiggins
ID: 22740651
You can try the NotesSQL driver (http://www.ibm.com/developerworks/lotus/products/notesdomino/notessql/) or LEI  (http://www-01.ibm.com/software/lotus/products/enterpriseintegrator/) which is a higher level solution.

You might even be able to try a web service of some sort but not sure what your app does or needs
0
 
LVL 18

Author Comment

by:David Robitaille
ID: 22742200
I m trying the NotesSQL driver, i download the last version, and i got information on where the nsf file is and everything. but i cant connect correctly.
If i dont set a userid, it detect my user i`m loged with, and ask for the password each time it try to access the database. (that bad for a web server), but i could extract the data.
If i set a user, i get  the following errors, the ****my userid**** is my own user and I extracted the data previously. i extracted it using the toll from my Notes id file.
I made a quick check and it look like a lot of peoples got problem with NotesSQL.
Did you made it work using ASP.net or you just throw that without experienced it?
Anyway, as i was writing that comment. i found info about Nsql_ALM.exe that allow me to "add user" to an autentificated list. im not sure how that will work on the server....
Anyway, that thing is ridiculously slow!!! i think, i i go that way, i will have to use the  third (and as a last resort) way, thats just too slow!
 
 
So, anyone got others ideas?

 

ERROR [S1C00] [Lotus][ODBC Lotus Notes]Driver not capable
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
ERROR [S1000] [Lotus][ODBC Lotus Notes]Unable to validate userid ****my userid****
ERROR [28000] [Lotus][ODBC Lotus Notes]Invalid authorization specification

Open in new window

0
 
LVL 20

Accepted Solution

by:
brwwiggins earned 500 total points
ID: 22742471
you have to have a user ID file and password to create a session to connect in notes. That is one of the security measures. With ASP.NET you can specify a service account to use or even a windows account but that will not translate over to notes.

I'm not a big fan of NotesSQL and we use LEI here. There used to be some commerical products (Proposion N2N ADO.NET driver for notes) but they no longer exist after being bought out from my understanding

Maybe this will help

http://www.ibm.com/developerworks/lotus/library/domino-sharepoint/index.html
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question