IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / I might be smoking rope.
Post #52,579
by mmoffitt
9/21/02 12:27:30 AM
Reply
New I might be smoking rope.
I've said before I thought MS makes 2 decent products, one of the Sql Server. Have you looked at using MSDE (MS Sql Server engine limited to 5 "concurrent" users and FREE). Dunno if it fits your environment, but these little MSDE databases can be Replication databases. Just a thought...

bcnu,
Mikem
Post #52,646
by orion
Picture of orion
9/21/02 6:41:49 PM
Reply
New Uh yeah
Our average client has about 8 to 24 workstations, I assume that the limit of 5 would bite us in the *ss later on. As soon as the 6th one goes to access the data, it will b*tch at them that it violated the server license. This of course, is not good.

Thanks for the info, I might use SQL Server's Smaller Sister in a different project, maybe somewhere else?
[link|http://games.speakeasy.net/data/files/khan.jpg|"Khan!!!" -Kirk]
Post #52,941
by mmoffitt
9/23/02 11:23:49 PM
Reply
New Depends on how you write it.
If you use MTS, then the COM object talking to the server counts as 1 connection. Even if you open/close connections at the client, you might get away with it. My own preference is nobody has base table access, sp's for insert/update/delete/anything else done a lot, views for everything else. COM DB components to interface w/all client UI's. Doing that cuts down significantly on "concurrent connections" unless you use the same system for DSS. I've deployed MSDE in a small shop w/12 workstations (it's an office doing lots of edits) and never exceeded the 5 concurrent limitation.

Just my 2,
Mikem
     Alternatives to SQL Server 2000 - (orion) - (38) - Sept. 19, 2002, 04:08:17 AM EDT
         MySQL has table locking. - (static) - (16) - Sept. 19, 2002, 07:14:57 AM EDT
             Re: MySQL has table locking. - (wharris2) - (4) - Sept. 19, 2002, 10:50:24 PM EDT
                 Thans for the info - (orion) - (3) - Sept. 21, 2002, 06:45:30 PM EDT
                     DB2 - (gdaustin) - (1) - Sept. 23, 2002, 03:44:52 PM EDT
                         More Info... - (gdaustin) - Sept. 23, 2002, 04:04:43 PM EDT
                     Revision - (wharris2) - Sept. 23, 2002, 04:20:26 PM EDT
             Do you know - (orion) - (10) - Sept. 21, 2002, 06:50:07 PM EDT
                 First off... - (folkert) - (9) - Sept. 21, 2002, 07:31:32 PM EDT
                     Re: First off... - (orion) - (6) - Sept. 21, 2002, 08:03:17 PM EDT
                         Okay.... Now comes the tough part... - (folkert) - (5) - Sept. 22, 2002, 06:29:18 PM EDT
                             Excuse me - (orion) - (4) - Sept. 22, 2002, 08:36:35 PM EDT
                                 Pardon... - (folkert) - (3) - Sept. 22, 2002, 11:04:23 PM EDT
                                     Getting better now - (orion) - (2) - Sept. 25, 2002, 08:33:54 PM EDT
                                         Re: Way-Way-Cool - (folkert) - (1) - Sept. 25, 2002, 08:46:33 PM EDT
                                             Wow you figured it out? - (orion) - Sept. 25, 2002, 08:53:01 PM EDT
                     Greg, Greg, Greg...K5 moderation... - (kmself) - (1) - Sept. 22, 2002, 11:23:55 PM EDT
                         Uh... Are ewe crit\ufffdi\ufffdciz\ufffding my Englih? or my wait? - (folkert) - Sept. 23, 2002, 08:59:43 PM EDT
         Idea: - (CRConrad) - (14) - Sept. 19, 2002, 11:20:34 AM EDT
             Thanks for the idea - (orion) - (13) - Sept. 19, 2002, 08:07:19 PM EDT
                 FWIW - (tseliot) - (12) - Sept. 24, 2002, 11:43:37 AM EDT
                     Thank you! - (orion) - (5) - Sept. 21, 2002, 07:01:00 PM EDT
                         Oh, yeah. Great plan. Good luck with that. - (altmann) - (4) - Sept. 21, 2002, 07:17:21 PM EDT
                             Better link for that script... - (folkert) - (3) - Sept. 21, 2002, 07:37:21 PM EDT
                                 Thank you guys - (orion) - (2) - Sept. 21, 2002, 08:07:25 PM EDT
                                     Then do that - (drewk) - (1) - Sept. 23, 2002, 02:25:41 PM EDT
                                         I am doing that - (orion) - Sept. 25, 2002, 08:39:11 PM EDT
                     Please remove the returns in your post - (ben_tilly) - (2) - Sept. 22, 2002, 06:35:46 PM EDT
                         Wish I could. zIWE parser put them in for me. -NT - (tseliot) - (1) - Sept. 23, 2002, 02:05:32 PM EDT
                             You _can_ - (ben_tilly) - Sept. 23, 2002, 08:08:42 PM EDT
                     Table re-done, all purty like... only removed breaks - (folkert) - Sept. 23, 2002, 08:46:37 PM EDT
                     Whoop---Whooop---Whooooop!!! - (folkert) - (1) - Sept. 24, 2002, 05:59:00 PM EDT
                         Ya NUT! - (tseliot) - Sept. 25, 2002, 12:31:22 PM EDT
         Oops, disregard -- double posting! -NT - (CRConrad) - Sept. 19, 2002, 11:23:11 AM EDT
         Re: Alternatives to SQL Server 2000 - (broomberg) - (4) - Sept. 19, 2002, 01:11:34 PM EDT
             Believe me, I do not insist on it - (orion) - (3) - Sept. 19, 2002, 08:35:06 PM EDT
                 I might be smoking rope. - (mmoffitt) - (2) - Sept. 21, 2002, 12:27:30 AM EDT
                     Uh yeah - (orion) - (1) - Sept. 21, 2002, 06:41:49 PM EDT
                         Depends on how you write it. - (mmoffitt) - Sept. 23, 2002, 11:23:49 PM EDT

It’s always projection with these guys.
67 ms