Thank you Len,
In answer to your questions...
1) This will be a multiuser database.
2) Server and clients should always be on the same subnet.
3) I think we should definitely give the option of running this app on other
OS's.
So it looks as though you've answered my question about SQLExpress.. :)
But since I have never used PostgreSQL, I am unfamiliar with deployment. Is
this a simple process? I imagine I would have to be able to do a server
install but what (if any) adjustments need to be made after installation.
I've experienced various issues with mySQL as far as priviledges, etc, are
concerned and various .php files need to be edited before a stable/secure
installation is achieved.
Thanks
Nic
----- Original Message -----
From: "Len Morgan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2007 6:01 PM
Subject: RE: Runrev & Microsoft sql server
While I haven't used SQLExpress, I HAVE used SQL Server. If your problem
with mySQL (which I am NOT recommending), is the difficulty of setting up
the server, I don't think you're going to do any better with SQLExpress.
Some things you didn't mention:
1) Will this be a multiuser database?
2) Will you the server and clients be on the same subnet?
3) Is there any (future) possibility of the server running on something
besides an MS OS? If so, forget SQLExpress
If it were me, I'd use PostgreSQL. They have a native Windows port with a
simple installer. It's really FREE to use in any way you want, has
unlimited users and there is a Rev driver for it. With SQLExpress, you're
going to have to use ODBC and that means you'll have to set up DSNs on
every client machine. I'm not sure if this last step can be scripted and
I'm pretty sure you'll need Admin rights on the client machines to set
this up. PostgreSQL doesn't require this (on the clients).
If this is not a multiuser app, you could look into SQLLite but I think
that only runs on the local machine (I could be wrong). In any case, it's
a single user database.
Hope that helps,
Len Morgan
The application will not have huge amounts of data. It is being developed
towards small to medium business.
Does anyone have any experience with sqlExpress? I know that it's free
for distribution and does not require licences. Does anyone have any
suggestions as to what we could use instead?
I could develop in .NET but really like revolution and would like to
stick with it for as long as I can.
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
#####################################################################################
This e-mail message has been scanned for Viruses and Content and cleared
by MailMarshal
#####################################################################################
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
