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 |
|
geossl
Yak Posting Veteran
85 Posts |
 Posted - 2004-08-31 : 23:23:41
|
| Dear All, Is there any way to use the Windows 2000 fax service in stored procedure to send fax? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-09-01 : 07:25:33
|
| I presume if you can call the fax service in a command box....then you can call xp_cmdshell.search here for examples of using xp_cmdshell....also on the security restrictions/implications of doing so. |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-09-01 : 08:56:41
|
| you can instatiate objects using stored procedures -- i would think that would be the way to go. Read up on sp_OACreate in books on-line.of course, you will need to somehow generate some sort of file with the contents of the fax -- you can't just sent a recordset to the fax service.- Jeff |
|
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2004-09-01 : 23:58:28
|
Is there any sample?quote:
Originally posted by jsmith8858
you can instatiate objects using stored procedures -- i would think that would be the way to go. Read up on sp_OACreate in books on-line.of course, you will need to somehow generate some sort of file with the contents of the fax -- you can't just sent a recordset to the fax service.- Jeff
|
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-09-02 : 00:35:45
|
| Not that I've seen, because it's a pretty bad idea.You would be better off writing an external application that reads from the database and calls the Fax service.Damian |
|
|
|
geossl
Yak Posting Veteran
85 Posts |
Posted - 2004-09-02 : 03:36:55
|
What about if the intention is to have a central place to share the modem and fax all the document one by one? Do you mean to create a service to dispatch the fax instead of calling a stored procedure?quote:
Originally posted by Merkin
Not that I've seen, because it's a pretty bad idea.You would be better off writing an external application that reads from the database and calls the Fax service.Damian
|
|
|
|
|
|
|
Using Windows 2000 fax service