Post reply

XP_SQL2EXCHANGE Without Outlook MAPI?

  • April 23, 2008 at 2:59 am

    #189404

    Hello All

    But of a newbie here, we have a SBS 2003 SP2 Premium with SQL 2000 installed.

    We run a hire system that user SQL as it's backend. This has a lot of client information contained in it that i would like to transfer automaticaly once a week to an exchange public folder.

    Now i have come across the XP_SQL2EXCHANGE extended stored procedure which seems ideal, i have installed it, managed to build the SQL query required to get all of my data how i want it but i have come across a small snag.

    It appears that it uses the Outlook MAPI layer to communicate with Exchange. Now as this is a SBS 2003 system i am not supposed to install Outlook on it due to MAPI conflicts with Exchange.

    So my question i guess is, does anyone know a way around this problem, or another solution that will achieve what i want. I have looked at the Exchange API's but they don't seem to allow you to write to exchange.

    Cheers

    Gareth

  • April 25, 2008 at 4:15 pm

    #807432

    Suggest using XPSMTP instead. See

    http://www.sqldev.net/xp/xpsmtp.htm

  • April 26, 2008 at 7:30 am

    #807498

    Thanks for your reply. However unless i am missing something XPSMTP only lets you send mail messages from SQL via SMTP. I am looking at writing contact information to a shared public folder in Exchange.

    Cheers

    Gareth

  • April 27, 2008 at 9:47 pm

    #807584

    In Outlook you can create a distribution list somewhat like group mail where in you will create a group then populate it with email addresses so that you will only need to send the file to the group and not sending it over and over again

    "-=Still Learning=-"

    Lester Policarpio

  • April 28, 2008 at 3:27 pm

    #808062

    I think i haven't described what i am trying to achieve very well as i have given you all the wrong idea. I have a hire system which uses SQL as it's back-end. Due to the fact that all of our invoicing e.t.c is done through this software, all our client information is stored within the software, and therefor within an SQL Database.

    Now not every computer has access to the hire software, and it's actually quite a pain to email from there so i am trying to set things up so that once a week all the contact details stored in the database are transfered into a shared contact folder on the companies exchange public folders.

    Then anyone in the company who has acces to the shared folder and needs to contact a contractor or client can just look them up in outlooks, and send them an email nice and quickly. Without ever having to go into the hire software, or go to a computer that is running the software.

    I found the XP_SQL2EXCHANGE stored procedure and it is absolutely perfect except for the fact that it relies on the MAPI layer installed by outlook to talk to exchange. As this is a SBS 2003 Premium installation SQL and Exchange are on the same machine, therefor i cannot install outlook as it will replace certain shared dll's that exchange uses and Exchange will more than likely fall over in a big ball of fire.

    I hope that explains it a bit more clearly.

    Cheers

    Gareth

  • October 24, 2008 at 12:23 pm

    #889415

    Can you tell me where i can get a copy of xp_sql2exchange?

  • June 18, 2009 at 3:43 am

    #1011569

    Any one knows where i can get the stored procedure that was mentioned?

  • July 9, 2009 at 11:28 pm

    #1022852

    Did anyone ever find out where xp_sql2exchange can be downloaded from?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply