Hmmm...Firebird/Interbase - sounds interesting, I'll have to investigate. Duncan Jack Manager Scottish ColdFusion User Group promoting e-business excellence
www.scottishcfug.com +44 (0) 7973 718303 Important Note: This message contains confidential information which is intended to be passed to the addressee only. Please advise the sender by telephone on the number shown above if this message has been sent in error to the wrong address. We acknowledge that e-mail is not an entirely secure medium of communication and you should be aware of this when replying. Although we believe that any attachments are free from any virus, we can give no guarantee. -----Original Message----- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 16 November 2003 10:28 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFMX and Access 2000 Thanks again, Duncan - I had seen that one. As to alternatives, I'm inclined towards Firebird/Interbase at the moment, rather than MySQL, partly because much of the SQLServer functionality is already built in, whereas we have to wait for MySQL v5 to get a little more than it already has. Cheers Terry ----------Original Message--------- > Terry > > Ben Forta wrote a useful article on the same subject: > > http://www.sys-con.com/coldfusion/article.cfm?id=115 > > Notice Ben's comments on shared file-based DB's (e.g. Access) versus > client-server DB's (e.g. MySQL). > > As an aside, MySQL doesn't currently support stored procedures, yet > apparently this will be changed in MySQL 5. > > Enjoy > > Duncan Jack > Manager > Scottish ColdFusion User Group > promoting e-business excellence > > www.scottishcfug.com > +44 (0) 7973 718303 > > > Important Note: This message contains confidential information which is > intended to be passed to the addressee only. Please advise the sender > by telephone on the number shown above if this message has been sent in > error to the wrong address. We acknowledge that e-mail is not an > entirely secure medium of communication and you should be aware of this > when replying. Although we believe that any attachments are free from > any virus, we can give no guarantee. > > > -----Original Message----- > From: Terry Riley [mailto:[EMAIL PROTECTED] > Sent: 14 November 2003 18:30 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFMX and Access 2000 > > Thanks for the reference, Duncan. > > Cheers > Terry > > ----------Original Message--------- > > > > > Terry > > > > Check out the following article: > > > > http://www.microsoft.com/AccessDev/Articles/QAJET30.HTM > > > > > > Extract below: > > > > "This document is for users and developers who have questions about > the > > MicrosoftR Jet database engine. Microsoft Jet is a powerful, yet often > > misunderstood technology. It lies at the core of the popular Microsoft > > Access database system and also provides powerful capabilities to many > > other applications. The latest version of Microsoft Jet has been > > enhanced to provide greater performance and new features. > > > > Theoretically, Microsoft Jet can support 255 simultaneous connections > to > > one database. The practical limit to the number of users Jet can > handle > > in multiuser applications depends on many factors. Applications whose > > primary task is to perform queries can handle more users than > > applications whose primary task is to update data. The network and > file > > server also play an important role in calculating this limit. In a > > properly configured network setting, Jet can easily support 25-50 > users > > in a transaction-orientated environment. Some multiuser applications > > function well with 80 users." > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
