Hi all. I have a very basic question about ADO connections and how they
apply to database connections. I have an application which connects to a
SQL Server database using a global connection object. The connection is
established at application start and disconnects with the process.
My question is this. If I open two Recordsets using server-side cursors
and they both share the same connection object, does the database register
this as two connections? If I use client-side cursors, will that make any
difference?
Re: How can I open an SQL database and be the only one who has access to it? ... you can determine how SS permits access to your server.... SINGLE_USER allows one user at a time to connect to the database.... controlled by the termination clause of the ALTER DATABASE statement.... To allow multiple connections, the database must be changed to ... (microsoft.public.data.ado)
Re: ORA-12518, 04030 errors after 9i-10G upgrade. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... out of process memory errors.... (comp.databases.oracle.server)
Re: ORA-12518, 04030 errors after 9i-10G upgrade. ... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... out of process memory errors.... that Oracle is having issues with OS resources. ... (comp.databases.oracle.server)
Re: ORA-12518, 04030 errors after 9i-10G upgrade. ... New server has 6GB ram.... All went ok until users started connecting in 100+ numbers, database is ... set up for dedicated server connections, this was never a problem in 9i. ... This did not solve problems so bounced database and decreased SGA to ... (comp.databases.oracle.server)
Re: Proper Database Connection Cleanup ... but I think two of them have a database query in them. ... Public Sub ConnectToDB2(byref XCmd, byref YRS, byRef Conn) ...Set ObjRS = ObjCmd.Execute ... from DB connections in my code or from something else? ... (microsoft.public.scripting.vbscript)
