SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Cannot load the DLL sqlmap70.dll
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

imughal
Posting Yak Master

192 Posts

Posted - 07/28/2004 :  07:16:00  Show Profile  Reply with Quote
hi,

i am working on email with sql server 2000. when i tried to access xp_sendmail procedure then i m getting following error message.

ODBC: Msg 0, Level 16, State 1
Cannot load the DLL sqlmap70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.).


can anyone help me out.

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 07/28/2004 :  08:27:38  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
That's probably not good. :) You need to go to this folder and make sure the file exists:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

Type these two statements into Query Analyzer on the master database:

EXEC sp_help 'xp_sendmail'
EXEC sp_helptext 'xp_sendmail'

It should return this:

xp_sendmail dbo extended stored proc 2000-08-06 01:30:42.717
sqlmap70.dll

Let us know how this part goes. Have you had this problem before, or is this the first time you're trying to use xp_sendmail? Also, what account is the SQL Server and SQL Server Agent services running under?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

Rick Barwig
Starting Member

1 Posts

Posted - 02/26/2014 :  14:11:36  Show Profile  Reply with Quote
[quote]Originally posted by derrickleggett

That's probably not good. :) You need to go to this folder and make sure the file exists:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

Type these two statements into Query Analyzer on the master database:

EXEC sp_help 'xp_sendmail'
EXEC sp_helptext 'xp_sendmail'

It should return this:

xp_sendmail dbo extended stored proc 2000-08-06 01:30:42.717
sqlmap70.dll

Let us know how this part goes. Have you had this problem before, or is this the first time you're trying to use xp_sendmail? Also, what account is the SQL Server and SQL Server Agent services running under?

Derrick,
I too am running into this problem for a client I just picked up. I ran the query and it did return the results that you stated. SQL mail has never been setup on this server. I installed Outlook 2003 and now can see a profile in the properties of SQLMail. But if I hit test, I get the original posters' error.

Thoughts?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000