Unanswered: More Than 10 Users while connection MS Access through ODBC
I m developing business applications in Delphi 6 for small units (departments) and using BDE.
Currently I am using MS Access which resides at shared folder. Each user have installed BDE and connect with DB through ODBC connection. But issue is now when more than 10 user trying to connect to DB they get error "No more Connection made to this remote computer..."
As i have searched that this error is because of Windows XP limitations. Your support and help in this regard will be highly appreciated.
-> Is there any way to have more than 10 connections (Windows XP SP :: Where DB is available).
-> What are the alternatives? Can it be resolved if i will use MS SQL Server / MySQL.
-> Are there any changes are required at application end while using SQL Server or MySQL.
Although I'm not a fan of having many users connecting to Access data file simultaneously, this issue isn't with Access - it is with XP. No matter what database you try to use with XP as the 'server,' you'll still have that 10 client connection limit. I suppose you could install a linux box & add postgresql on the linux platform - then you could handle a thousand concurrent connections or so.
Try having your users connect, load data into a recordset in baqtch update mode, then disconnect the recordset & close the connection.
When you need to update the data, reconnect, perform the update, then disconnect again. In other words, don't have the clients just sitting there, tying up a connection, when they're not actually using the connection.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
If you use linked tables you can just create them on the fly when you need them, then discard them as soon as they are not required any more.
To create such a table:
Set tdf = dbs.CreateTableDef()
tdf.Name = <TableName> ' Name in this database
tdf.SourceTableName = <RemoteTableName> ' Name in the remote database
tdf.Connect = <ConnectionString>