Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2004-07-29 : 06:46:08
|
| hi,when i exex this commandexec master..xp_sendmail 'myemail@myeamil.com', @query='select * from clients'i am getting following error message.ODBC: Msg 0, Level 16, State 1Cannot load the DLL sqlmap70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).tell my why this error msg occuring.bye imughal |
|
|
n/a
deleted
35 Posts |
Posted - 2004-07-29 : 12:39:17
|
| Like many SQL Mail Error messages, this could mean many things. I would try the following and see if it helps1. Make sure you use a domain account as the service startup account for SQL Server and SQL Server Agent, and make sure this account belongs to the local administrators group.2. Logon by using this account, create a mail profile for this account, and make sure you can send/receive email by using Outlook with this profile.3. Specify BOTH SQL Server and SQL Server Agent to use this mail profile:For SQL Server, in the SQL Enterprise Manager, right click the server name, click Properties, click the Server Settings tab, specify a mailprofile for SQL Mail by using the profile created in step 2.For SQL Server Agent, in the SQL Enterprise Manager, drill down toManagement --> SQL Server Agent, right click the SQL Server Agent, andclick Properties, specify the mail profile created in step 2.HTHPaul |
 |
|
|
|
|
|
|
|
Cannot load the DLL sqlmap70.dll