Connector to SQL server

Any ideas on how to connect to a SQL server database? I don't want to follow the ODBC route. I would like the users to think they are still in Notes while accessing SQL data. I need connector classes for back-end script?
deonvaAsked:
Who is Participating?
 
typerracerConnect With a Mentor Commented:
Not your only option.  Many middleware tools such as Replic-Action, Notrix, and LEI will allow you to perform realtime queries against a back-end SQL database.  However, when it comes down to it, they are just providing a wrapper for ODBC drivers so that you don't have to code all of the looping, error handling, etc. that is associated with proper use of LS:DO and ODBC.
0
 
zvonkoCommented:
In native client or in web?

If in LotusClient: do you have the ODBC drivers on server (do you use LS:DO )?
Are you familar with the NotesAgent.RunOnServer(ParamDocID) method?
0
 
deonvaAuthor Commented:
zvonko
This is in both instances (client and on web). I'm actually looking for some native I/F and not ODBC. Do you know if such an interfase exists?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
zvonkoCommented:
Please explain wath is the database you want to talk to in SQL native.

(for me this is still strange. SQL is only the protocol. This sounds to me like: I want to use HTTP to a server but without a browser... ;-))
0
 
deonvaAuthor Commented:
:-))
Nope, the db is Microsoft SQL database running on NT. Does this answer your question? I need to know if there in an I/F other than ODBC between Notes and this db.
0
 
zvonkoCommented:
OK, now I understand why you ask for "SQL" without SQL ;-)

but, sorry, I have to look for native MicrosoftSQL interfaces to Notes (and do not beleave to find any).

Again is the question why do you not like to use ODBC?
0
 
deonvaAuthor Commented:
:-))
Nope, the db is Microsoft SQL database running on NT. Does this answer your question? I need to know if there in an I/F other than ODBC between Notes and this db.
0
 
deonvaAuthor Commented:
ODBC is my last option as I have to do large bulk transfers of data. Looks like this is my only option though.
0
 
zvonkoCommented:
yeap.
0
 
ZvonkoSystems architectCommented:
deonva,
No comment has been added lately (948 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to typerracer http:#6319738
Please leave any comments here within 4 days.

-- Please DO NOT accept this comment as an answer ! --

Thanks,

Zvonko
EE Cleanup Volunteer
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.