Data Admin

J

jacowess

New Member
Hi

I am new to progress. We have an existing progress database, I need to get into the Data Admin prog to change the SQL_WIDTH as I am importing all the data into SQL 2000.
I am unable to connect to the database using Data Admin and keep on getting the error
"** The database C:\Psylvest\data\psylvest is in use in multi-user mode.(276)"
Does anyone have an idea how to get past this?

Thanks
 
I don't know your version of Progress and your OS (always handy to post with every post you make) but since 9.1D sp6 you can use dbtool for that. You can start it from the command prompt.
dbtool <dbname>

The reason why you can't do it with the Data Admin is because then you have to make a schema lock on the databse to achive it. That's only possible when the client is run in single user mode.

Look at Progrss KB 24496 P62676 for dbtool and
KB 21721 for a programm which detects problemetic SQL widhts.

HTH,

Casper.
 
jacowess said:
I am unable to connect to the database using Data Admin and keep on getting the error
"** The database C:\Psylvest\data\psylvest is in use in multi-user mode.(276)"
Does anyone have an idea how to get past this?
Click to expand...
Apart from what Casper said, I'm puzzled you can't get into Data Admin.

And do you mean Data Admin, or the Data Dictionary?

How are you attempting to connect? Which program are you using? What are the properties of any shortcuts you are using?

Have you ticked the Multi-User box in your connect dialog?

Make sure you do not have -1 (single user) in your connection parameters.

By definition, you cannot connect single user to a multi-user database - if you are using a pro command from the prompt, change this to mpro.
 
Hi

I am running progress 9.1B on a Win2k server. I am trying to access both the Data Administration and Data Dictionary apps.
I read that I to change the SQL_WIDTH form the data dictionary.
When I opn the data dictionary I get the following prompt

"Note: Because of the version of PROGRESS you are using, the dictionary is in read-only mode"

When I try to connect to the database I get the following error
" The database is in use in multi user mode (276)"

When I tick the multiple users box I get a 4406 error "The client is not licensed for remote connections".

Thanks
 
jacowess said:
Hi

I am running progress 9.1B on a Win2k server. I am trying to access both the Data Administration and Data Dictionary apps.
I read that I to change the SQL_WIDTH form the data dictionary.
Click to expand...

You can't do that in multi-user mode before V10, as it requires a schema lock. Connect single user, or use dbtool as was suggested.

I'll try and help with the other problems when I have time, if no one else suggests anything. But a quick thought - make sure you have the correct licenses (Client Networking, I think).
 
You must log in or register to reply here.
Back
Top