| View previous topic :: View next topic |
| Author |
Message |
smikolas
Joined: 14 Mar 2006
Posts: 9
Location: Tucson, AZ.
|
 Posted: Tue Mar 21, 2006 3:39 pm Post subject: Database access from a workstation using PG Admin |
 |
|
I am trying to run PG Admin from a workstation instead of the server and I receive an error message. The message is: Excessive database errors: 3051. It's telling me that the database is opened exclusively by another user or I need permission to view the data.
I have mapped a drive to the data and I have given the users of the server all the permissions I can think of. The database does not have any restrictive security and PG Admin is not running on the server at the time I am accessing data from the workstation. The other way I tried to run PG Admin is by navigating to the directory where the executable exists with the same result. The way I can run it is to use remote desktop and run from the tray icon. I’m sure I am overlooking something obvious. Thank you for your help.
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4407
|
| Posted: Tue Mar 21, 2006 4:37 pm Post subject: |
|
|
| Have you done the "Additional Admin" installation on the workstation or are you trying to run the executable from the remote location?
|
|
| Back to top |
|
smikolas
Joined: 14 Mar 2006
Posts: 9
Location: Tucson, AZ.
|
| Posted: Tue Mar 21, 2006 4:45 pm Post subject: |
|
|
| Yes. I have done the "Additional Admin" installation. I have also tried to run the executable from the remote location. Same result in both cases.
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4407
|
| Posted: Tue Mar 21, 2006 4:50 pm Post subject: |
|
|
| Just out of curiosity, what happens if you use the UNC path (\\servername\directory\) instead of the mapped path?
|
|
| Back to top |
|
smikolas
Joined: 14 Mar 2006
Posts: 9
Location: Tucson, AZ.
|
| Posted: Tue Mar 21, 2006 5:24 pm Post subject: |
|
|
| I just removed PG Admin and reinstalled it using "\\server\directory" with the same results. By the way if the app dosn't start is there anyway to change the directory path without an uninstall and a reinstall. I also just realized that I never told you I was using version 5 bata.
|
|
| Back to top |
|
smikolas
Joined: 14 Mar 2006
Posts: 9
Location: Tucson, AZ.
|
| Posted: Tue Mar 21, 2006 5:32 pm Post subject: |
|
|
| It looks like something happened to my post and only a couple of words got through. I removed PG Admin and reinstalled it using "\\servername\directory". By the way, I just realized I never told you I was using version 5 bata.
|
|
| Back to top |
|
OzCom
Joined: 22 Oct 2003
Posts: 1123
Location: US
|
| Posted: Tue Mar 21, 2006 9:18 pm Post subject: |
|
|
I know this sounds simplistic (I have about 9 pgv5 installs in place and have seen this before) - have you powered the PC off and re-started? I believe there are some registry settings that may need to be cleared_________________ Aaron D. Osgood
Streamline Communications, LLC
* Authorized Notepage, Inc. Development Partner and Re-seller
TEL: 207-518-8455
AOsgood@streamline-solutions.net
Creators of AutoPage Spillman CAD interface for PageGate |
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4407
|
| Posted: Wed Mar 22, 2006 5:29 am Post subject: |
|
|
[quote="smikolas"]It looks like something happened to my post and only a couple of words got through. I removed PG Admin and reinstalled it using "\\servername\directory". By the way, I just realized I never told you I was using version 5 bata.[/quote]
When you did this, did it make a difference?
|
|
| Back to top |
|
smikolas
Joined: 14 Mar 2006
Posts: 9
Location: Tucson, AZ.
|
| Posted: Thu Mar 23, 2006 4:00 pm Post subject: |
|
|
Sorry about the delayed answer but I've been out of the office.
As to the questions:
Yes to powering down without improvement.
No to did it make a difference.
|
|
| Back to top |
|
smikolas
Joined: 14 Mar 2006
Posts: 9
Location: Tucson, AZ.
|
| Posted: Tue Mar 28, 2006 3:24 pm Post subject: |
|
|
| The Remote PG Admin problem turned out to be a server rights issue. Thank you all for your help.
|
|
| Back to top |
|
|
