Want To Link SQL Server DB To MS Exchange E-Mail-Address Data

Mar 1, 2002

Hi all,
I'd like to link a SQL Server database / table to Microsoft Exchange Server E-Mail-Address data, for an Employee Directory project.

I've read a little about "Web Store", a little about ExOLEDB, but I've come across nothing along practical lines. I.e., I still don't know where to begin!

For example the "Web Store" should be created on the SQL server, but how do you create it? Any insights will be greatly appreciated.

Gallagher

View 1 Replies

Using SQL MAIL Without A MS Exchange Server ?

Oct 28, 2000

I want use SQL MAIL, but I have MDAEMON mail server on my Wndows NT Server!
Can I have any chances for it?

View 1 Replies View Related

XP_sendmail Puts Copy Of Mail In Sent Mail Of Exchange Client.

Jul 9, 2001

I am using nt4.0 sp5 with sql7.0 sp3 and exchange client.
Does anyone know how to keep xp_sendamil form putting a copy of the mail message in the sent mail folder or an automated process for deleting all mail in the sent folder? As it stands now I must manually delete all messages from the sent mail folder on a daily basis.

Thanks,

Ed.

View 6 Replies View Related

Does SQLMail Require A Mail Account On The Exchange Server?

Sep 3, 2006

I just read that if you use an exchange server...the account that youstart SQL with needs a mail on the exchange box.Is this true?I know I didn't need an account when I've set it up before...but Imight have been using a POP3 server.I have Outlook 2003 installed on the server. Windows 2003 Enterprise.Thanks.

View 1 Replies View Related

Configuring Mail For SQL Server Agent - Problem With Exchange And Outlook On Same Machine?

Jul 23, 2005

I would like to configure e-mail alerts on my SQL Server 2000 box.However, we also run Exchange on the same machine. I've been told therecould be conflicts/issues having Outlook on the same machine asExchange; and apparently, one needs Outlook to configure a mail profilefor SQL Server Agent.Is there, in fact, anything to worry about? If so, are there anywork-arounds beside moving Exchange to another server? (we've only gotone server, so this is not an option for us at this time).Thanks.- Dana

View 1 Replies View Related

SQL Mail And Exchange Question?

Jul 9, 2001

Hey All,

Is there any way to run SQL Mail with exchange CLOSED? Keeping Exchange always minimized seems rather unneedy, inexperienced developers might just have the tendency to close it. Is there any way to avoid that?

Also, can SQL Mail be configured with something else besides Exchange?

Thanks a bunch!

Ilya

View 3 Replies View Related

SQL AGENT MAIL Not Using Exchange

Oct 27, 2000

I setup a domain user account and e-mail account for the sql agent. When I want the agent to mail me a message
when something happens it puts it in the out box but does not send until I pull up the outlook express and ping the server to send recieve.
If I don't have outlook express running in the taskbar, it won't send the message at all. The e-mail is configured as an internet mail component.
Any suggestions??

View 2 Replies View Related

Database Mail And MS Exchange

Oct 30, 2007

I have set up database mail in SQL 2005. We have an MS Exchange group that is alerted when SQL jobs fail.
Two things ;
i) I can't seem to be able to use Exchange mail Groups. If I specify the group name SQL returns ;

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2007-10-30T15:40:39). Exception Message: Cannot send mails to mail server. (The specified string is not in the form required for an e-mail address.).
If Exchange cannot be used in the way that Outlook did then how can we alert a group of users about SQL job failures ?

Therefore I tried specifiying an indiviual email address rather than a group ;

- sending a test message (right click database mail) using the full single email address works fine.
- sp_send_dbmail using the full single email address is also fine.

ii) When a job fails the notifications do not seem to work. The Job history log just reports ;
NOTE: Failed to notify 'Operator Name ' via email.
The SQL Error log reports ;
Message
[264] An attempt was made to send an email when no email session has been established

However sysmail_help_status_sp indicates that database mail has started.
The job fails to notify the operator and in this case it is a single email address.

Anybody got any suggestions, (thanks in advance) ?

View 7 Replies View Related

SQL Server 2014 :: Passing Malformed Email Address To Send Mail Task?

Feb 5, 2015

I am implementing a fax solution (Right Fax) and pulling email information from a table and passing into a variable. In order to send out a fax via email, the syntax is in the following example below:

Example:

To send a fax from Outlook to Jane Doe at 555-1212, enter:

[RFAX:Jane Doe@/FN=555-1212]

When the following syntax gets passed into the Send Mail Task, into the "To" line and the package is executed I'm receiving the following.

[Send Mail Task] Error: An error occurred with the following error message: "The specified string is not in the form required for an e-mail address.".

[Send Mail Task] Warning: The address in the "To" line is malformed. It is either missing the "@" symbol or is not valid.

I realize it’s a malformed email address. Is it possible to create a group and instead of the fax syntax pass the group name?

View 8 Replies View Related

Notes Mail: Exchange Profile Not Found!! HELP PLEASE!!

Feb 3, 2000

I saw from SWYNK that you were able to set up SQL Mail using Lotus
Notes. I tried following the post by Edward Alexander but got into some trouble:

We were using MAPI to get to Notes Mail.

1. We know that MAPI works because we were able to send mail by
a. using the exchange client (Windows Messaging client)
b. using VB script to send a message with MAPI.Session

The problem is that SQL server cannot see the Exchange Profile that was defined on the SQL box.

View 2 Replies View Related

Database Mail: Getting Bounce Info From Exchange?

Apr 26, 2007

Database Mail only sends SMTP email messages and logs problemsconnecting to the mail server. However, I also need to log bouncedemails (bad address, etc).Are there any clean ways to do this with Database Mail and Exchange?Or will I have to mix Database Mail with SQL Mail to read bounces outof the inbox? Or, have a .NET windows service that talks to theExchange API?

View 1 Replies View Related

Send Mail Task On Exchange 2007

Jan 25, 2008

I've used send mail tasks on all my etl's without any problem.

Today we are migrating from a exchange 2003 to an exchange 2007 server.

I've filled in the new IP and runned the send mail task box and now it fails, the send mail task won't work anymore.

Anyone else who has experianced simular problems like this ?

I've already tried the checkboxes use windows login verification and ssl but it still won't work.

Someone please help me or i have a major problem.

View 1 Replies View Related

Extracting Data From Exchange Into SQL Server Db

Mar 22, 2002

Has anyone been able to solve the issue with setting up a package in EM, which connects to an Exchange(.edb) database and extracts the data into a SQL Server db. Previous message posts don't offer much insight. So far, all I have is using Access 2000, to connect & move the data, then extract from here.
Thanks in advance for any help.
BV

View 1 Replies View Related

Xp_sendmail. Can I Change From E-mail Address

Aug 21, 2001

Hi,

I'm usning xp_sendmail to send e-mails to customers. In the From filed of e-mail it shows the user id which runs this process. Can I mask or change this like FROM: Customer service

Thanks in advance.

Javed

View 1 Replies View Related

SSRS Subscriptions: The E-mail Address Of One Or More Recipients Is Not Valid.

May 19, 2007

Hi There,

I try to send a report by email using SSRS subscriptions with recipients defined in an outlook email group. if 1 or more emailid are not a valid ones then SSRS does not send the report to any other valid recipients but displays the bellow error message!

"The e-mail address of one or more recipients is not valid."

In corporate companies, it is a common to find in valid/locked emailids in email group lists which can not be corrected.

Expected functionality: SSRS Subscriptions should send report email to other valid recipients in the mail group.

Could you please suggest a work around or fix the issue?

Thank you much in advance!

Regards,

Ramana

View 4 Replies View Related

Subscription Error: The E-mail Address Of One Or More Recipients Is Not Valid.

Sep 20, 2006

I have subscriptions that fail because someone's email is no longer valid,
where is this error information stored so I can fix the problem?
I have a large list and it is hard to do manually.
I will be using data driven solutions, but these are existing subscriptions that need to be ran.

View 26 Replies View Related

Stored Proc Requesting Data Via An Exchange Linked Server

Jan 7, 2004

Hello,
I have created a MS Exchange 2000 link server in my MS SQL Server 2k. I have created a stored procedure (and a view...) using info from that linked server. When I am logged on the server as the Administrator, I can call my stored proc without any problems. When I use another computer (and I am not logged as the admin of the server) and I call the stored procedure, the following error is always raised :
Server: Msg 7302, Level 16, State 1, Procedure test_proc, Line 3
" Impossible de cr�er une instance du fournisseur OLE DB 'exoledb.DataSource.1'. "
<== I know it is a french error but it can be translated as : "Unable to instancied the OLE DB 'exoledb.DataSource.1' provider"

I would like to know if I can make run my stored proc in the admin account or what should I do to make it work

View 1 Replies View Related

How Can I Get Data From MS Exchange Server Using DTS In SQL Server?

May 23, 2001

How can I get data from MS Exchange server using DTS in SQL Server?

View 2 Replies View Related

I Want To Have A Live Link To Data From SQL Server

Jun 27, 2005

This is a bit confusing but here goes: I need to access data in SAP via OLE DB. I can't go direct to the back end database (Oracle), we have to use RFC or BAPI calls to access the SAP data. That's part works, we have a DLL that accesses the SAP data we need.

View 1 Replies View Related

Data Link File To Access SQL SERVER 7 ???????

Mar 22, 2000

Guys,

I want to know how to use Microsoft Data Link File with all the
information of the database,username,password to connect to SQL SERVER 7.

Where is this file stored ?

Any feedback will be appreciated.

Thanks

View 3 Replies View Related

Exchange Data Between Databases On Two Servers??

May 29, 2007

Dear all

I have tow server on the same intranet. One server has a sql server 2000 database and the other one has SQL server 2005 databse.
The sql 2000 database has a table called employee. When ever a new employee is inserted in the database i would like the same values to be sent to the sql 2005 database. But this cant be done on the application level. It has to be done in the database. The application level can not be changed.
I was thinking a trigger but how to achieve the writing from one database to another. If they were on the same server then it would be easier but because they are on different servers i dont know how to do it.
Has anyone had similar issue before?
Any help is apreciated.

Sincerely
Dan

View 2 Replies View Related

Extract Exchange 2003 Data

Aug 14, 2006

I have searched everywhere for an answer and seems I am either blind or there is no simple solution. Basically I have a need to report on data stored in an Exchange 2003 data store. There is mention of a OLE DB for Exchange 2000 but nothing for Exchange 2003. For example, A company report on time spent on various categories in a staff's calendar, etc. I would like to use SQl 2005 SSIS to extract and reporting services to report. Why is this so difficult? I come from a Lotus Notes / Domino background and there are numerous articles and ways to do this? Please can some MS guru please give me some direction on where to look?

Cheers

Damien

View 3 Replies View Related

Unable To See Data From Oracle Client Through SQL Link Server

Feb 5, 2007

Hello,

I was hoping someone had this problem and has a solution... :)

Some background info:

SQL 2005 Enterprise x64

Windows 2003 R2 x64 Enterprise (clustered)

Oracle client 10.2.0.3 (latest as of 2/2/07)

The issue I'm having is I have a link server setup within SQL 2005 connecting to a Oracle 8 database server. The Oracle client I'm using is 10.2.0.3 (latest version from Oracle). From the SQL 2005 server I'm able to query the remote oracle server through the link server I had setup if I query the table directly. If I perform a query to a view on the Oracle server I'm able to see the colum names, but not the data. This only happens when I'm using the Oracle client, if I use the MS client for Oracle it works fine OR if I use SQL Plus.

Now, you're probally asking, why not just use MS's driver... Well, I would If I could, but Microsoft hasn't provided a 64 bit driver for Oracle which I need to create the link server in SQL.

Any help would be appreciated.

View 4 Replies View Related

Transact SQL :: Error To Insert Data From Link Server

Jul 30, 2015

Msg 7314, Level 16, State 1, Line 42

The OLE DB provider "SQLNCLI10" for linked server "192.168.0.40" does not contain the table ""CP_DW"."dbo"."StgDimSalesTargetSetup"". The table either does not exist or the current user does not have
permissions on that table.

Insert into [192.168.0.40].CP_DW.dbo.StgDimSalesTargetSetup

Select t.SalesTargetCode,t.SalesTargetId,t.TargetDefination,
--LEFT(DATENAME(MM, t.PeriodFrom), 3) + '-' + CONVERT(VARCHAR(4),DATEPART(YY, t.PeriodFrom)) AS MonthYear
--CONVERT (char(8),PeriodFrom,112) [Datkey],
Left(CONVERT (char(8),PeriodFrom,112),6) [Monthkey],t.PeriodFrom,t.PeriodTo,t.TargetAmount
FROM [SO_SalesTargetSetup] t

View 5 Replies View Related

SQL Server 2012 :: Unable To Link Data After Import From XML Into Tables

Aug 13, 2015

I'm pulling data from XML into tables, but I'm unsure how to link the data after it's imported. This example has names and tasks, and I can pull the data into two tables, but I can't find any way to link the task to the appropriate person. My person and task tables populate without issue, but there's nothing I can find to link the rows together. So in this example Test 1 would go to the first two Tasks and Test 2 would go to the second two work items.

DECLARE @XML TABLE (XMLData XML);
DECLARE @Person Table (Name NVARCHAR(50), Addresss NVARCHAR(50));
DECLARE @Task Table (Name NVARCHAR(50), Details NVARCHAR(50));
INSERT INTO @XML SELECT '
<process>
<header>
<Person><Name>Test1</Name><Address>123 main street</Address></Person>

[Code] .....

View 9 Replies View Related

Cannot Import/link Data From DBase With SQL Server DTS Nor Access Anymore..

Jul 20, 2005

Hi,SQL Server 2000 SP3Windos 2000 Server SP4I have a DTS package that imports data from a dBase IV databse withfiles located in two folders (dBF1 and dBF2). I use a transform datatask to transform the data.They were running properly, but last week we installed W2K SP4, andnow the transform task for files from dBF2 are not working properly.I have two tranform tasks to extract data from files in dBF2 folder.If I double click to open the transform data task of either of them,Enterprise Manager crashes with the errrormmc.exe applicatio ErrorThe instruction "xxxx" referenced memory at "xxx". The memory couldnot be read.Althoug the transform task for one of the files will run, the otherwill not run giving the messageError Source: DTS packageCatastrophic failureAlso, I have an Access database that has links to the same dBasefiles. For files from dBF2 folder, I'm able to see the data from oneof the files, but if I double click to see the data from the other,access crashes with no specific error message. Nothing has changed ondBase related files (permission wise).The transform tasks to extract data from the other dBase folder (dBF1)files are working fine, and data is accesible from Access.Any advice how to tackle this one?

View 2 Replies View Related

How To Restrict Editing Of SQL Server 2005 Data Via ODBC Link?

Apr 25, 2007

I have a sql server 2005 database with Delphi 2006 in the front end and for querrying and reporting we use MS Access 2003 by connecting to this database via ODBC connection. I recently found out that the SQL Server 2005 data connected thus can be edited (updated) from MS Access. I do not want end users to modify/update the SQL Server 2005 data from MS Access while I also want them to have the ability to insert/update/delete rights using the appropriate application interface. For now, I am handling this by creating a user id that is not permitted to update, insert and delete and using the same account in the ODBC. Is there a way in SQL Server 2005 you can control insert/update/delete rights for all users that will be applicable only in the ODBC mode?

Any help will be greatly appreciated.

thulo

View 3 Replies View Related

T-SQL (SS2K8) :: Import Data From XML Feed To Get Daily Exchange Rates

Aug 26, 2015

I'm trying to find a way to import data from this data xml feed to get daily exchange rate. I' tried:

select *
from
openrowset(bulk 'http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml',single_blob) as x

Which is a feeble attempt at a start; however, am getting this error message:

Cannot bulk load because the file "http://www.bankofcanada.ca/stats/assets/xml/fx-noon.xml" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).

How to parse this file using SQL.

View 1 Replies View Related

SQL Server And Exchange

Nov 15, 1999

How do I get my Exchange address from my exchange server stored in my SQL Server 7.0 database? Or, how do I query that list from SQL Server 7.0...?

Thanks!

Dean

View 1 Replies View Related

SQL Server Without Exchange

Jun 2, 1999

Hello,
I'm having difficulties to figure out how to set up Sql Server / Windows NT / MAPI in order to send e-mails.

Is it possible to manage emails from Sql Server without exchange ?

Thanks in advance

Sam

View 1 Replies View Related

MS Exchange Server

Jun 8, 2000

Hi there,

I have just installed Exchange Server.
Can any one help me for what I have to do in Exchange Server so that I can send Email
from SQL Server 7.0

Thanx in advance,
zak

View 2 Replies View Related

Sql Mail And Sql Server Agent Mail With Lotus Notes Domino Server

Jul 7, 2003

Hello Everyone,
I am trying to configure SQL MAIL and SQL SERVER AGENT MAIL feature of SQL SERVER 2000 with Lotus Domino server (Not Microsoft Exchange). Every thing goes fine and it works also. Problem starts when I try to restart SQL Agent Service. It hangs and the status of service remain 'starting'...
Also the size of the sqlagent service process goes upto 12MB. I don't understand why? Can any one help me in solving this problem.
I am using Windows 2000 Advanced Server and SQL Server 2000 with SP3. Domino client is R5.0.5 and Outlook 2000.

View 14 Replies View Related

Import Exchange Into SQL Server With DTS?

Oct 4, 2000

Import Exchange into SQL Server with DTS?

Our users enter data into the MS Exchange database using custom Outlook forms. We want to import that data in SQL Server using SQL Server Data Transformation Services (DTS). We do not see Exchange in the Data Source list in the DTS wizard. Is there an easy way to do this? Maybe an OLEDB provider for Exchange?

Thanks,
Bob

View 1 Replies View Related