I have maintain connection on, we are running 23 different databases and that has NEVER posed a problem with connections from what I can tell it still sees it as ONE connection otherwise I would never be able to log into enterprise manager.
-----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:49 PM To: CF-Talk Subject: RE: SQL Licensing/User Question Every datasource you define in the CF Administrator will count as a user IF you check the "Maintain Connection" box. In other words if you have Datasources ------------------------------------------- DS1 SQL Server 7 DS2 SQL Server 7 If you checked the "Maintain Connection" box for both of these then there will be two connections open as long as CF is running. *Note* a connection is not established until the first time you hit the DB. After that the connection persists unless you UNCHECK the "Maintain Connection" box and restart the service. +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecomunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:39 PM To: CF-Talk Subject: RE: SQL Licensing/User Question I think yur right :-) not sure though... Im just guessing -----Original Message----- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:40 PM To: CF-Talk Subject: RE: SQL Licensing/User Question could it be cold fusion? -----Original Message----- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:33 PM To: CF-Talk Subject: RE: SQL Licensing/User Question I believe your web server is a user also... Not sure where the other is coming from. -----Original Message----- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:32 PM To: CF-Talk Subject: SQL Licensing/User Question Ok have a question. We have a license that allows 4 people/logins to be connected to the SQL server at one time. Via Enterprise manager or whatever. Well it keeps telling us there are 4 connected yet there are only 2 of us using it. Is there a place I can go to see who the current USERS are that are "connected" to the sql server? Sorry it's something I normally don't deal w/ so just don't know where to look. Kelly ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
