|
If I set my pool size is to 10,then 10 client connect to my database , what happend if 11th client request to connect to SQLSrever? Should it wait so one of 10th disconnect from databse or new pool create with size 10?
Mazy
"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope
|
|
|
|
|
It will just create a new connection and add it to the pool. The 11th client will take the full overhead for connection creation.
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
Sorry, I can't get it. New pool create or it will wait?
Mazy
"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope
|
|
|
|
|
This[^] explains it better than I can.
brief summary: the 11th client in a 10 connection pool will wait for a connection to become free. If the wait exceeds the ConnectionTimeout property, an exception will be thrown.
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
Thanks.
Mazy
"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope
|
|
|
|
|
i
is there someone who know a database with the extension ".DTA" ,and which tools
can i open it ????
|
|
|
|
|
I hope this[^] helps
Josef
|
|
|
|
|
Has anyone ever used the .Data Provider Library[^] by ByteFX[^]? What are your opinions of it?
Thanks,
Josef
|
|
|
|
|
I tried using it. It only has partial support for VS so don't expect to be able to drag and drop it onto your form, you will be creating the objects by hand in your own code. If you need to support more than 5 connections then I guess that it is a good alternative if the end user does not want to ponyup the money for a decent backend.
The database that I ended up being more interested in was the MaxDB from the MySql folks that supports triggers and stored procedures. I don't beleive that this .Data Provider supports MaxDB as MaxDB is *not* MySql but rather a open source database developed by the SAP people. MaxDB may be distributed free of charge *if* your application is being distrubuted as open source. Otherwise, it has a healty price tag.
|
|
|
|
|
Thanks for the reply mate.
Also has anyone ever used MySQLDriverCS[^]?
Thanks
Josef
|
|
|
|
|
does anyone have any links or comments on how to choose a database server product?
i have fairly large database in mysql on linux (os could cange) currently, but it is being bogged down, on some pretty serious hardware, and i think doing some optimized stored procedures,perhaps a full text index, etc would help... i have used a lot of the various databases, but haven't done much performance analysis... any thoughts?
it does a lot of transactions, updates, inserts and selects...
but the biggest slowdown is the relatively low percentage of searches.
|
|
|
|
|
Could you give us an example of one slow search, and what indexes you have in place.
|
|
|
|
|
I imported data in VC 6.0 using DTSPackage from SQL to Access but importing larger data made the proccess slower. Is there anyway that this could be made faster.
I aslo tried Queries, SELECT and INSERT... SELECT was good but INSERT could not paste the data in bulk... can someone help me plzzzzz
Thnx in Advance
AD
|
|
|
|
|
Y DONT U PEOPLE HELP ME
PLZZZZZZZZZZZZZZZZZZZZ
HELPPPPPPPPPPPPPPPPPPP
MEEEEEEEEEEEEEEEEEEEEE
AD
|
|
|
|
|
I am trying to limit the number of items returned from a SQL Server (SQL Server 2000). However when I do something like this ASP.NET gets mad at me:
SELECT * FROM SomeWhere WHERE Something = 'SomeCondition' LIMIT 5
Basically I only want the first 5 results returned. This worked in my experience in MySQL. Could anyone show me how to do it in SQL Server 2000?
Matt Newman
|
|
|
|
|
SELECT TOP 5 * FROM SomeWhere WHERE Something = 'SomeCondition'
MSSQL doesn't support "LIMIT x, y" but it can be emulated through a somewhat... icky... nested subselection.
--
Henrik Stuart (http://www.unprompted.com/hstuart/)
|
|
|
|
|
Thanks, thats exactly what I needed.
Matt Newman
|
|
|
|
|
Also consider set rowcount n to stop processing of the result set after n rows (and set rowcount 0 to reset). The set rowcount is especially useful in a stored proc where you want to pass n (the # of rows) as a variable from your components/application.
Cheers,
Lee.
Lee H Fuller
lee@fullerdata.com
|
|
|
|
|
Hi,
can anyone explain the difference between finalize and dispose methods?Like which is used to release resources and when is best used?. Why are these methods declared as protected?
Any furthur reading suggestions,comments are welcome
|
|
|
|
|
Asking on the .NET Framework or C# forum would be better.
Finalization is built into the CLR. When the garbage collector collects an object, if it has a finalizer, the object is added to the finalization queue (and the memory containing the object is pushed up into the older generation - it isn't actually collected). A separate thread, the finalization thread, is used to actually call the finalizers. Once the finalizer for the object has run, the object's memory can be collected (unless the object has resurrected itself, but we'll forget that for the moment). The Finalize method is a special hint to the CLR - if you override Finalize, the above takes place.
Dispose is a design pattern (also, with the support of the IDisposable interface). By convention, it allows the programmer to release scarce resources once the object is finished with. You should implement this if you hold a resource that is limited (such as a drawing object, or a database connection) or that could cause contention with other parts of the program (such as files). In these cases, you would normally also have a finalizer to act as a backstop in case the user doesn't call Dispose. You can call GC.SuppressFinalize in your Dispose method to tell the CLR that you've done all the necessary cleanup and it no longer needs to call your finalizer.
The IDisposable interface allows programs and environments to detect whether a Dispose method is implemented without using Reflection (which is a lot more costly). C#'s using block automatically calls IDisposable.Dispose on the controlled object at the end of the block.
See MSDN: Implementing a Dispose Method[^].
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
can someone share me a sample code on how to open a connection in case my database is in the server. I am using MS Access 2000 for my database, and ADO, Visual C++ in my application.
your help is greatly needed...
i've seen some codes about it and im wondering if the user id and password parameters of the open function refers to the database password you set after you created your database. and how dsn string looks like..
please help me..
this is a new thing for me...
|
|
|
|
|
Try looking here[^]
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
what if the the server requires a username and password? can i use the same username and password i have set in my workgroup information file?
how should the code look like? please help me...
|
|
|
|
|
Microsof Access is not a client/server db, but a file database. To open it on a server from a client workstation, the user account running the application must be able to mount the database as a file share. If the drive on theserver where the database is located is not always mapped to the same drive letter on the client, you will need to specify the datasource in the connection string as a UNC path (\\servername\sharename\path\filename.mdb). Password and username in the connection string must be what the access db (system.mdb) expect, not a server username/password.
Access in not a very robust "client/server" db. SQL server or MSDE would be a better soulution if you need true client/server performance.
Power corrupts and PowerPoint corrupts absolutely. - Vint Cerf
|
|
|
|
|
I have an Access database named Data and has set a password for it. When I tried to convert it to prior access database version (because I have to, otherwise, it will cause error in my Visual C++ application durion connection opening) the set database password option is disabled. so, my problem is how can i set a database password if my database has been converted...
please help me...
|
|
|
|