Re: msmq to sql?

Tech-Archive recommends: Speed Up your PC by fixing your registry

that's what I thought. I guess I'm going to recommend what you guys
suggested: Straight ADO db connection with SQL Srever mirroring. But what to
hec to do with that connections string... is there any way to secure it
enough whitin the application on user machine to convince them? Or maybe
retrieve connection string with web service?

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OifLlSQHIHA.4112@xxxxxxxxxxxxxxxxxxxxxxx
All these for 1) asynchronous access and 2) for security.

Well that depends on what you are doing. Asynchronous access to a database
is not very useful for most user applications. If you are only talking
about SQL Server as a back end to an app that just needs to load data such
as a logging process this may be fine. But if it is a user interface app
and the user expects to see data back these techniques don't work well.
Don't get me wrong things like Service Broker have a definite place and
work great for what they were designed to do. But you can't front end a
database server with these tools and expect them to work like a database
server. I just got off a large project where we had to completely rewrite
an app that made extensive use of web services because it couldn't scale
as written and simply was the wrong tool for the job in this case.
Management needs to define what their goals are first and then decide what
the best tools for the job are, not the other way around.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Andy" <kc2ine@xxxxxxxxx> wrote in message
news:%23y6juKOHIHA.4880@xxxxxxxxxxxxxxxxxxxxxxx
I have 2005 version. I was thinking about mirroring also,
but management wants to have some kind of user separation from SQL server
like web service (I don't want to do this) or messaging services like
MSMQ or SQL 2005 server Broker Agent. All these for 1) asynchronous
access and 2) for security.
So I'm a little confused what to use. What would you guys suggested?
thanks


"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:O9IdyLJHIHA.6044@xxxxxxxxxxxxxxxxxxxxxxx
What happens then when the server that is running msmq goes down? Why
would you think that would be more reliable than SQL Server? MSMQ can't
even begin to duplicate the functionality of SQL Server and should never
be thought of as a backup to or replacement for it. You are better off
looking at valid HA or DR means for SQL Server such as Clustering,
Database Mirroring, (possibly replication), Log shipping etc. But your
goals and business needs will dictate the actual methods used.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Andy" <kc2ine@xxxxxxxxx> wrote in message
news:u%23%23CdMEHIHA.1316@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
If I'd like to ensure that in case sql server is down user still can
access and write the the data what option do I have? Since writing is
more important I thought about MSMQ tu put between the server and the
application, but what about reading? Any other techiniques?
In case of MSMQ, can you suggest any example how to use it with SQL
server?
thanks







.

Relevant Pages

  • Re: provider: Named Pipes Provider, error: 40 - Could not open a c
    ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
    (microsoft.public.sqlserver.connect)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • .Net framework error
    ... Unfortunately the information is very limited and usually the report just ... The application is a front end for a SQL Server 2005 Express database, ... connection string in the app config file. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: connect to named instance w/ non-default port
    ... SQL Native Client Configuration. ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ...
    (microsoft.public.sqlserver.connect)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I moved every table I was able to move to the SQL ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... communication between ODBC (OLEDB and Native Client, ...
    (microsoft.public.sqlserver.connect)