DBPROCESS is dead or not enabled - HELP!

I am using MSDE on a network with multiple PCs. One PC has the MSDE Database
and client applications connected to the database. The other PCs also have
Client applications connected to the database.
When one of the Client PCs is logged off and shut down, the Applications on
the Database's PC get the error "DBPROCESS is dead or not enabled", Error
Code: 10005.
Can anyone help please?
Regards,
Loz Moz
"Loz Moz" <LozMoz@.hotmail.com> ha scritto nel messaggio
news:4125e38e$0$29908$cc9e4d1f@.news.dial.pipex.com ...
> I am using MSDE on a network with multiple PCs. One PC has the MSDE
Database
> and client applications connected to the database. The other PCs also have
> Client applications connected to the database.
> When one of the Client PCs is logged off and shut down, the Applications
on
> the Database's PC get the error "DBPROCESS is dead or not enabled", Error
> Code: 10005.
> Can anyone help please?
The [DBProcess is dead or not enabled message] is a generic error meaning
the client has lost the connection to the server, and, unfortunately,
there's plenty of conditions that can cause this to happen, from network
problems to timeout problems to server down problems.
further ideas at
http://www.winnetmag.com/Article/Art...019/14019.html
http://tinyurl.com/3w37b
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

dbo qualified name error w Access 2003

I am the owner of a database with other users. I have given all users
db_owner role. My server is MSDE 2000.
I use the following code to import a spreadsheet.
docmd.transferspreadsheet acImport, acSpreadsheetTypeExcel97,
"dbo.DL_Funding_Data", "theFilename.xls", True
When I use an adp from Access 2000, this code executes successfully for all
users. When I use an adp from access 2003, this code gets error 3078 and
will only work if I remove the "dbo." from the name of the table.
thanks for any help,
Jerry
As I recall (and it's been a few years) the syntax required for
specifying SQL Server objects changed between A2000 and 2003. In 2000
you had to use the full syntax, ownername.objectname and 2003 is more
lenient. Since many people didn't bother implementing security
correctly, things ended up being owned by dbo, which is *not*
synonymous with db_owner, but is mapped to sysadmin. Something you
definitely don't want users being. FWIW, I definitely wouldn't use
DoCmd for DDL or DML, ever. It's just not a robust way of handling
things.
One tool you should use is SQL Profiler. Creating a trace allows you
to see the calls between Access and SQL Server, and is indispensable
for troubleshooting these things.
--Mary
On Mon, 22 Aug 2005 15:17:03 -0700, JerryWendell
<JerryWendell@.discussions.microsoft.com> wrote:

>I am the owner of a database with other users. I have given all users
>db_owner role. My server is MSDE 2000.
>I use the following code to import a spreadsheet.
>docmd.transferspreadsheet acImport, acSpreadsheetTypeExcel97,
>"dbo.DL_Funding_Data", "theFilename.xls", True
>When I use an adp from Access 2000, this code executes successfully for all
>users. When I use an adp from access 2003, this code gets error 3078 and
>will only work if I remove the "dbo." from the name of the table.
>thanks for any help,
>Jerry
|||Thanks for the recommendations Mary. I'll look into removing DoCmd and
obtaining the SQL Profiler.
I'm waiting to get my users all at Access 2003 to minimize the version
problems.
Thanks!
"Mary Chipman [MSFT]" wrote:

> As I recall (and it's been a few years) the syntax required for
> specifying SQL Server objects changed between A2000 and 2003. In 2000
> you had to use the full syntax, ownername.objectname and 2003 is more
> lenient. Since many people didn't bother implementing security
> correctly, things ended up being owned by dbo, which is *not*
> synonymous with db_owner, but is mapped to sysadmin. Something you
> definitely don't want users being. FWIW, I definitely wouldn't use
> DoCmd for DDL or DML, ever. It's just not a robust way of handling
> things.
> One tool you should use is SQL Profiler. Creating a trace allows you
> to see the calls between Access and SQL Server, and is indispensable
> for troubleshooting these things.
> --Mary
> On Mon, 22 Aug 2005 15:17:03 -0700, JerryWendell
> <JerryWendell@.discussions.microsoft.com> wrote:
>
>

DBMGR2K Download site

Hello!
I've heard about a free tool for msde "dbmgr2k" can someone please help to point me to where can i download the software?
Thanks in advance!

Try this link I am assuming this what you mean. Hope this helps.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en|||Thanks Caddre for the information!
I've seen the tool that im looking for after searching it in google.
It was my mistake that I ommit letter "a". Im searching "dbmgr2k" instead of "dbamgr2k".
thanks again