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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 sp_sendmail generates odbc error

Author  Topic 

mdelgado
Posting Yak Master

141 Posts

Posted - 2002-04-10 : 13:02:20
Hello.

I have a stored procedure that runs xp_sendmail. It used to work but now it doesnt. I get the following error each time it runs:

Server: Msg 17969, Level 16, State 1, Line 0
xp_sendmail: Unable to login to SQL Server.
ODBC error 14 (08001) Invalid connection.
ODBC error 14 (01000) ConnectionOpen (Invalid Connection()).



Any ideas on how to fix?


Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-04-10 : 13:29:37
Assuming you are running v 6.0 or 6.5, this article may help.

<O>
Go to Top of Page
   

- Advertisement -