Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What is userid 'dbo' ?

4 posts in General Discussion Last posting was on 2004-04-28 17:07:54.0Z
Geoffrey Chambers Posted on 2004-04-23 20:56:27.0Z
Sender: 7fee.40898281.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: What is userid 'dbo' ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <408982f7.7ff3.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 23 Apr 2004 13:56:23 -0700, 10.22.241.42
Lines: 4
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Apr 2004 13:56:24 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Apr 2004 13:56:27 -0700
X-Trace: forums-1-dub 1082753787 10.22.108.75 (23 Apr 2004 13:56:27 -0700)
X-Original-Trace: 23 Apr 2004 13:56:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3006
Article PK: 6473

I tried to use the version 9 evaluation software, but when I
do it first has to upgrade from version 6. (Even though it
says version 5 to 8). Well when I do I get the error UserID
'dbo' not found. What is wrong?


Nick Elson Posted on 2004-04-23 22:08:50.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <408982f7.7ff3.1681692777@sybase.com>
Subject: Re: What is userid 'dbo' ?
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: 10.25.100.165
X-Original-NNTP-Posting-Host: 10.25.100.165
Message-ID: <408993f2$1@forums-1-dub>
Date: 23 Apr 2004 15:08:50 -0700
X-Trace: forums-1-dub 1082758130 10.25.100.165 (23 Apr 2004 15:08:50 -0700)
X-Original-Trace: 23 Apr 2004 15:08:50 -0700, 10.25.100.165
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3007
Article PK: 6474

'dbo' is the **DataBase Owner** user that ASE uses and
we added it for ASE and TSQL compatibility. It's just
required to be there.

If your database does not have a DBO account (and every
database created in any version since 5.0 should) then you
may have a much older database file than you think. Just
because it runs with the ASA 6 doe not necessarily mean
you have an ASA 6 created database file. It could be a
4.0 or 3.2 or even older file that no one has ever bothered
to rebuild.

My suggestion?

See what happens when you try to rebuild it with the
version 6 software.

If that completes, then try the upgrade to 9 again.

<Geoffrey Chambers> wrote in message
news:408982f7.7ff3.1681692777@sybase.com...
> I tried to use the version 9 evaluation software, but when I
> do it first has to upgrade from version 6. (Even though it
> says version 5 to 8). Well when I do I get the error UserID
> 'dbo' not found. What is wrong?


Geoffrey Chambers Posted on 2004-04-27 20:20:47.0Z
Sender: 46f4.408ec024.1804289383@sybase.com
From: Geoffrey Chambers
Newsgroups: ianywhere.public.general
Subject: Re: What is userid 'dbo' ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <408ec09b.46f8.1681692777@sybase.com>
References: <408993f2$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 27 Apr 2004 13:20:43 -0700, 10.22.241.42
Lines: 34
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Apr 2004 13:20:44 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Apr 2004 13:20:47 -0700
X-Trace: forums-1-dub 1083097247 10.22.108.75 (27 Apr 2004 13:20:47 -0700)
X-Original-Trace: 27 Apr 2004 13:20:47 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3012
Article PK: 6479

Ok, that seem to work to a point. I was able to upgrade to 6
and then upgrading to 9 completed, but when I try to open
the database, version 9 can't read it.

> 'dbo' is the **DataBase Owner** user that ASE uses and
> we added it for ASE and TSQL compatibility. It's just
> required to be there.
>
> If your database does not have a DBO account (and every
> database created in any version since 5.0 should) then you
> may have a much older database file than you think. Just
> because it runs with the ASA 6 doe not necessarily mean
> you have an ASA 6 created database file. It could be a
> 4.0 or 3.2 or even older file that no one has ever
> bothered to rebuild.
>
> My suggestion?
>
> See what happens when you try to rebuild it with the
> version 6 software.
>
> If that completes, then try the upgrade to 9 again.
>
>
> <Geoffrey Chambers> wrote in message
> news:408982f7.7ff3.1681692777@sybase.com...
> > I tried to use the version 9 evaluation software, but
> > when I do it first has to upgrade from version 6. (Even
> > though it says version 5 to 8). Well when I do I get the
> > error UserID 'dbo' not found. What is wrong?
>
>
>


Nick Elson Posted on 2004-04-28 17:07:54.0Z
From: "Nick Elson" <no_spam_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <408993f2$1@forums-1-dub> <408ec09b.46f8.1681692777@sybase.com>
Subject: Re: What is userid 'dbo' ?
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: nicelson-xp.sybase.com
Message-ID: <408fe4e8$1@forums-2-dub>
X-Original-Trace: 28 Apr 2004 10:07:52 -0700, nicelson-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Apr 2004 10:07:53 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Apr 2004 10:07:54 -0700
X-Trace: forums-1-dub 1083172074 10.22.108.75 (28 Apr 2004 10:07:54 -0700)
X-Original-Trace: 28 Apr 2004 10:07:54 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3014
Article PK: 6480

Can't read it?

Rebuild was my recommendation. If you just upgraded,
you may be missing something (like JDBC support ?maybe?).

<Geoffrey Chambers> wrote in message
news:408ec09b.46f8.1681692777@sybase.com...
> Ok, that seem to work to a point. I was able to upgrade to 6
> and then upgrading to 9 completed, but when I try to open
> the database, version 9 can't read it.
>
>
> > 'dbo' is the **DataBase Owner** user that ASE uses and
> > we added it for ASE and TSQL compatibility. It's just
> > required to be there.
> >
> > If your database does not have a DBO account (and every
> > database created in any version since 5.0 should) then you
> > may have a much older database file than you think. Just
> > because it runs with the ASA 6 doe not necessarily mean
> > you have an ASA 6 created database file. It could be a
> > 4.0 or 3.2 or even older file that no one has ever
> > bothered to rebuild.
> >
> > My suggestion?
> >
> > See what happens when you try to rebuild it with the
> > version 6 software.
> >
> > If that completes, then try the upgrade to 9 again.
> >
> >
> > <Geoffrey Chambers> wrote in message
> > news:408982f7.7ff3.1681692777@sybase.com...
> > > I tried to use the version 9 evaluation software, but
> > > when I do it first has to upgrade from version 6. (Even
> > > though it says version 5 to 8). Well when I do I get the
> > > error UserID 'dbo' not found. What is wrong?
> >
> >
> >