Re: What kind of Program?



I'm not trying to give you a hard time, but I still don't get it.
Ralph's solution seems good, but still overkill to me. Tell me what
I'm missing in the following situation:

User opens your program, does stuff, then prints a fax to the fax
server, and IMMEDIATELY issues an update to the SQL Server that says
"Yeah, I sent a fax" -- that whole process of updating the SQL Server
would take about 1/10 of a second most likely. Then the user sends
another fax (in your example she did 15) -- so what? The processes are
tied to each other -- print a fax, update SQL Server.

And I really don't understand why anything has to "listen [to[ the fax
printer" -- are you looking to log into SQL Server that a fax was
successfully sent? If that is the case, then create a program to query
the fax server and see what new faxes have been sent. Setup a job on
that server to run it every minute or 10 minutes or 2 hours or
whatever.

Matt

.



Relevant Pages

  • Re: SQL Server (2005 or other) - Permissions on Views Excel Connection
    ... That's a question you should be asking in a SQL Server newsgroup. ... At the moment, when a user opens the Excel ODBC connection window, it ...
    (microsoft.public.excel.programming)
  • Re: Forms with record source of SQL Server table
    ... In order to be able to update SQL Server tables, ... > I have upsized a backend database into SQL Server. ... > its record source, and it works fine. ... with relatively simple queries as their record source do ...
    (microsoft.public.access.forms)
  • Time zones dates in vb.net 2005
    ... Program I have which determines which way to update SQl server 2005 tables ... based on the lastupdate (datetime field) datetime ...
    (microsoft.public.dotnet.languages.vb)
  • Re: From a WebService Dataset to a local SQL Server
    ... If you are simply trying to update SQL Server, you can create a Data Adapter ... For XML, there are plenty of pages out there on using XML in SQL ... Internal SQL Server, exact data structure, with no modification. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Upgrading SQL Server version in replica environment
    ... I want to update SQL Server version from 7.0 to 2000 but my installation is ... replicated in another 7.0 SQL Server instance. ...
    (microsoft.public.sqlserver.replication)

Loading