Thread View: borland.public.cppbuilder.database.multi-tier
5 messages
5 total messages
Started by Andreas Schilling
Wed, 12 Jan 2000 00:00
Problem with exclusive access of BDE
Author: Andreas Schilling
Date: Wed, 12 Jan 2000 00:00
Date: Wed, 12 Jan 2000 00:00
9 lines
775 bytes
775 bytes
Hi! I want to access to a Paradox-database with BDE and MS-Access at the same time. But BDE open excluse the database. So I can't access with MS-Access to the database. Is it posible to access with both BDE and MS-Access to the database. At least is it posibly to configure only readonly-access with BDE to the database. Andy
Re: Problem with exclusive access of BDE
Author: Mark Cashman
Date: Wed, 12 Jan 2000 00:00
Date: Wed, 12 Jan 2000 00:00
11 lines
897 bytes
897 bytes
Hi, Andy! You have to configure the BDE administrator to have LocalShare = true, and set the SHAREDMEMSIZE parameter as well. ------ Mark Cashman, TeamB C++ Builder http://www.temporaldoorway.com/programming/index.htm C++ Builder, JBuilder programming information Home of The C++ Builder Programmer's Webring - Join us! ------
Re: Problem with exclusive access of BDE
Author: Andreas Schilling
Date: Fri, 14 Jan 2000 00:00
Date: Fri, 14 Jan 2000 00:00
10 lines
1072 bytes
1072 bytes
Hi Mark, sorry this doesn't work. The parameter LocalShare is set to true and SHAREDMEMSIZE is set to 2048KB. If I opened the database with the database-explorer, I couln'd open the same databse with MS-Access and vice versa. MS-Access break with the error-message: The Microsoft Jet database engine cannot open the file '...'. It is already opened exclusively by another user, or you need permission to view its data. Vice versa. The database-explorer breaks with error: share-error File: ... BDE-Error 11058 [$2B][$32] share-error file ...
Re: Problem with exclusive access of BDE
Author: Jerry Bloomfield (TeamB)
Date: Fri, 14 Jan 2000 00:00
Date: Fri, 14 Jan 2000 00:00
27 lines
1955 bytes
1955 bytes
On 14 Jan 2000 07:58:43 GMT, "Andreas Schilling" <Andreas.Schilling@tigra.de> wrote: >... If I opened the database with the >database-explorer, I couln'd open the same databse with MS-Access and vice >versa. MS-Access break with the error-message: The Microsoft Jet database >engine cannot open the file '...'. It is already opened exclusively by >another user, or you need permission to view its data. Vice versa. The >database-explorer breaks with error: share-error File: ... >BDE-Error 11058 [$2B][$32] share-error file ... Yes, that is MS-Access. When ever you open the database in MS-Access it specifies "exclusive" as the default connection type. One way to get around this is to use an ODBC connection within MS-Acces to link to the MDB file. I know it is quite "hokey", but I have not had the time to go digging through all of the MS crap to find the proper settings to get Access to "share" its files nicely... I am not as familiar with the BDE problem though. Are you using the Native MSACCES driver? I know that I share MS-Access MDB files constantly using ODBC... Jerry Bloomfield (TeamB) -- Jerry Bloomfield JersWork@wwa.com Proud Member of Borland's TeamB "We'll do anything if you don't pay us."
Re: Problem with exclusive access of BDE
Author: Andreas Schilling
Date: Mon, 17 Jan 2000 00:00
Date: Mon, 17 Jan 2000 00:00
56 lines
2597 bytes
2597 bytes
Hi Jerry and Mark! Thank you for your help. Now I fixed the problem!. It was a problem by the configuration of MS-Access. I use the Native-Driver of MS-Access. I had to change the registry. The path was \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Paradox There I had to add ParadoxUserName=Andy ParadoxNetPath=C:\PDOXDB ParadoxNetStyle=4.x the same as I configured the BDE. But I don't know the parameter ParadoxNetStyle. It change the lock-method of 3.x and 4.x. I have to try it. Andy Jerry Bloomfield (TeamB) <JersWork@wwa.com> schrieb im Beitrag <u2jv7s0sles1197b5pqrtc02o1526nbpl1@4ax.com>... > On 14 Jan 2000 07:58:43 GMT, "Andreas Schilling" > <Andreas.Schilling@tigra.de> wrote: > > >... If I opened the database with the > >database-explorer, I couln'd open the same databse with MS-Access and vice > >versa. MS-Access break with the error-message: The Microsoft Jet database > >engine cannot open the file '...'. It is already opened exclusively by > >another user, or you need permission to view its data. Vice versa. The > >database-explorer breaks with error: share-error File: ... > >BDE-Error 11058 [$2B][$32] share-error file ... > > Yes, that is MS-Access. When ever you open the database in MS-Access it > specifies "exclusive" as the default connection type. One way to get > around this is to use an ODBC connection within MS-Acces to link to the MDB > file. I know it is quite "hokey", but I have not had the time to go > digging through all of the MS crap to find the proper settings to get > Access to "share" its files nicely... > > I am not as familiar with the BDE problem though. Are you using the Native > MSACCES driver? I know that I share MS-Access MDB files constantly using > ODBC... > > Jerry Bloomfield (TeamB) > -- > Jerry Bloomfield JersWork@wwa.com > Proud Member of Borland's TeamB > "We'll do anything if you don't pay us." >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads