September 11, 2003 at 7:51 am
Hi! I'm researching any possible way(s) that SQL Server can directly interface with a Novell Groupwise address book. Has anyone ever done anything like this or heard of any tools available to perform this kind of work?
Thanks,
Jim
September 15, 2003 at 8:00 am
This was removed by the editor as SPAM
September 15, 2003 at 10:20 am
Need to do this myself as well. I'm thinking I may have to use SMTP mail rather than a groupwise integration, but researching this now.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 15, 2003 at 10:27 am
According to this http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q263/5/56.asp&NoWebContent=1, isn't supported. I suspect without some extended stored procedure, it will not work.
"Microsoft does not support using SQL Mail to communicate with mail servers such as Lotus Notes, Lotus cc:Mail, or Novell GroupWise unless they are treated as POP3 servers."
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 15, 2003 at 10:33 am
Thanks, Steve.
We've seen a possible solution which involves Novell's eDirectory, but that's a round-a-bout way of doing things. We're still looking and hoping there's a more direct way. Its hard to believe this hasn't been done before...
We can and do use SMTP for some processes, but we're running into issues with users creating their own groups within Groupwise and then wanting to access them through an app developed in-house using ColdFusion with a SQL Server backend.
Thanks again for the response and good luck in your search!
Jim
Edited by - jthornton on 09/15/2003 10:33:25 AM
September 15, 2003 at 11:37 am
I did find that Groupwise has a MAPI interface, but not sure if this will work.
Upgrading a server tomorrow and will try some integration, but since it's send only to a known address, I'm not sure it helps you.
MS doesn't want to see Notes or Groupwise out there, so I'm not surprised there isn't a way. They only support Exchange and SMTP integration. If you need to read the directory, is there an ODBC/OLEDB interface? Perhaps you could query the directory and load it into a table?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 7, 2007 at 6:08 am
You can query eDirectory using the Novell ODBC driver for NDS. It is very slow when pulling data so be very precise to pull only what is needed. You can configure your own tables once you add your own System DSN. I am in the process of setting this up myself. More information is found in the document http://developer.novell.com/documentation/odbcrw/index.html?page=/documentation/odbcrw/odbc_enu/data/bktitle.html, specifically section 2.5. You will also have to set some parameters such as ANSI_NULLS and ANSI_WARNINGS at least. I am sure there is more. MS Access is pretty user friendly and interacts well using the import. SQL server takes a bit more time to configure to get it work (linked server, correct syntax, parameter settings, etc.). Good luck!
December 7, 2007 at 8:41 am
Steve Jones - Editor (9/15/2003)
I did find that Groupwise has a MAPI interface, but not sure if this will work.Upgrading a server tomorrow and will try some integration, but since it's send only to a known address, I'm not sure it helps you.
The MAPI interfaces must be EXTENDED MAPI in order to work. Basic MAPI (like outlook Express, Notes, GroupWise, etc...) are not compatible.
Funny how that works... the only interfaces that qualify as Extended MAPI "happen" to be Outlook and the Exchange client.... Coincidence? I don't think so.....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply