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.

Read Only Record Set

5 posts in General Discussion Last posting was on 2003-07-25 15:32:39.0Z
Joshua James Posted on 2003-07-21 22:31:36.0Z
From: "Joshua James" <admin@caddadvantage.com>
Subject: Read Only Record Set
Date: Mon, 21 Jul 2003 15:31:36 -0700
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <uOK98j9TDHA.145@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 66-224-40-59.atgi.net 66.224.40.59
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1420
Article PK: 3653

After converting my Access 97 database to Access 2002, then 'upsizing' to
SQL. My VB application (using ODBC) tells me that a record set in my SQL
database is read only. But my old access databases work just fine. Any
ideas???


Greg Fenton Posted on 2003-07-22 21:36:17.0Z
Date: Tue, 22 Jul 2003 17:36:17 -0400
From: Greg Fenton <greg.fenton_NOSPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Read Only Record Set
References: <uOK98j9TDHA.145@forums-2-dub>
In-Reply-To: <uOK98j9TDHA.145@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <ulne#pJUDHA.145@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: vpn-concord-010.sybase.com 158.159.8.10
Lines: 22
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1435
Article PK: 3668


Joshua James wrote:
> After converting my Access 97 database to Access 2002, then 'upsizing' to
> SQL. My VB application (using ODBC) tells me that a record set in my SQL
> database is read only. But my old access databases work just fine. Any
> ideas???

What database are you referring to when you say "SQL" ? If ASA, what
version and BUILD number are you using?

How did you "upsize" to SQL? Did you use a tool to migrate the database
from Access 2000?

Can you post the code that is giving the error about "read only"? This
may be a simple ODBC configuration issue or it may be a cursor-type issue.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Joshua James Posted on 2003-07-23 17:38:38.0Z
From: "Joshua James" <admin@caddadvantage.com>
References: <uOK98j9TDHA.145@forums-2-dub> <ulne#pJUDHA.145@forums-2-dub>
Subject: Re: Read Only Record Set
Date: Wed, 23 Jul 2003 10:38:38 -0700
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <umbDoJUUDHA.130@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 66-224-40-59.atgi.net 66.224.40.59
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1441
Article PK: 3674

When I say SQL I mean Microsoft SQL Server 2000.

I used the upsize tool from Sybase. I think. It may have even been built
into Access 2002/XP
I also used the Import option from MsSQL. (same issue)

Unfortunatly, I did not write the VB application, so I do not have the
source code. But it does work when the access database is the ODBC database
being used.
I only get the error when the SQL database is the ODBC database being used.

"Greg Fenton" <greg.fenton_NOSPAM@ianywhere.com> wrote in message
news:ulne%23pJUDHA.145@forums-2-dub...
> Joshua James wrote:
> > After converting my Access 97 database to Access 2002, then 'upsizing'
to
> > SQL. My VB application (using ODBC) tells me that a record set in my SQL
> > database is read only. But my old access databases work just fine. Any
> > ideas???
>
>
> What database are you referring to when you say "SQL" ? If ASA, what
> version and BUILD number are you using?
>
> How did you "upsize" to SQL? Did you use a tool to migrate the database
> from Access 2000?
>
> Can you post the code that is giving the error about "read only"? This
> may be a simple ODBC configuration issue or it may be a cursor-type issue.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
>


Greg Fenton Posted on 2003-07-23 23:00:51.0Z
Date: Wed, 23 Jul 2003 19:00:51 -0400
From: Greg Fenton <greg.fenton_NOSPAM@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624
X-Accept-Language: en-us, en
MIME-Version: 1.0
Subject: Re: Read Only Record Set
References: <uOK98j9TDHA.145@forums-2-dub> <ulne#pJUDHA.145@forums-2-dub> <umbDoJUUDHA.130@forums-2-dub>
In-Reply-To: <umbDoJUUDHA.130@forums-2-dub>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <u5$eu#WUDHA.346@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: vpn-concord-050.sybase.com 158.159.8.50
Lines: 24
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1449
Article PK: 3682


Joshua James wrote:
>
> I used the upsize tool from Sybase. I think. It may have even been built
> into Access 2002/XP
> I also used the Import option from MsSQL. (same issue)
>

Do you mean the SQLAnywhere Migration Utility?

http://www.ianywhere.com/developer/code_samples/sqlany_migration_utility.html

This tool was designed to migrate from Access to SQL Anywhere. I doubt
that you'll find many people have used it to migrate to other database
platforms.

If you are moving to MSS, why not use one of their tools? Surely they
must have tools to help move from one of their platforms to another one
of their platforms?

Have you considered migrating to ASA instead?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/


Joshua James Posted on 2003-07-25 15:32:39.0Z
From: "Joshua James" <admin@caddadvantage.com>
References: <uOK98j9TDHA.145@forums-2-dub> <ulne#pJUDHA.145@forums-2-dub> <umbDoJUUDHA.130@forums-2-dub> <u5$eu#WUDHA.346@forums-2-dub>
Subject: Re: Read Only Record Set
Date: Fri, 25 Jul 2003 08:32:39 -0700
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <e8D$kMsUDHA.145@forums-2-dub>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 66-224-40-59.atgi.net 66.224.40.59
Path: forums-1-dub!forums-master.sybase.com!forums-2-dub.sybase.com
Xref: forums-1-dub ianywhere.public.general:1466
Article PK: 3699

Come to find out, I used a upsize tool that was built into Office XP. Had
nothing to do with Sybase. But hey, thanks for the help.

It still doesn't work, but we're going to have our VB guy run a debug on the
software.

"Greg Fenton" <greg.fenton_NOSPAM@ianywhere.com> wrote in message
news:u5$eu%23WUDHA.346@forums-2-dub...
> Joshua James wrote:
> >
> > I used the upsize tool from Sybase. I think. It may have even been built
> > into Access 2002/XP
> > I also used the Import option from MsSQL. (same issue)
> >
>
> Do you mean the SQLAnywhere Migration Utility?
>
>
http://www.ianywhere.com/developer/code_samples/sqlany_migration_utility.html
>
> This tool was designed to migrate from Access to SQL Anywhere. I doubt
> that you'll find many people have used it to migrate to other database
> platforms.
>
> If you are moving to MSS, why not use one of their tools? Surely they
> must have tools to help move from one of their platforms to another one
> of their platforms?
>
> Have you considered migrating to ASA instead?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
>