473,386 Members | 1,673 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Sybase goes read only

I have an Access97 frontend using linked tables to a sybase database via
ODBC DSN.
Sometimes but not always the linked table becomes read only. After
refreshing the links it may or may not return to being editable.

This happens on several tables in different DB's.
Yes, there is a primary key on the tables
No, exclusive locking is not employed.

I cannot find either on Microsoft or sybase any refernece to this issue.

My work around is to code data updates thru passthru queries, but clearly
takes more coding.
I checked to make sure we have the latest ODBC.dll
Has anyone experienced the same issue and know of the solution ?

Its a tricky one that has plagued me for years.
thanks in advance
Tombsy
Nov 13 '05 #1
0 1076

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Luke | last post by:
Hello! This is the first time I need to connect via PHP to a Sybase DB. I'm working with PHP5 and Apache 2 under WinXP... no problem connecting with Mysql... I enabled in php.ini the correct dll:...
0
by: Dave Cole | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. NOTES: This...
2
by: Jim Douglas | last post by:
Anyone using this .NET provider. Any problems or should I stick with the Sybase OLEDB? Or worse check with the DataDirect folks for their .NET provider for Sybase? Thanks! -- Jim Douglas
3
by: len | last post by:
Before posting I did search through the newsgroup and saw several references to people requesting the binaries to the Sybase module. However I did not see in these requests answers as to where they...
1
by: Shawn | last post by:
Hi. I'm trying to save an image into a Sybase DB. The field (image_1) is of type "Blob". I have found two examples that I've tried, but no luck so far. Here is what I have done: Example 1:...
5
by: pankaj_wolfhunter | last post by:
Greetings, In Sybase, a timestamp column is automatically loaded by the DB engine and its in some hex format. This is shown below id timestamp_value ----------- ------------------ 1...
3
by: Alex Murphy | last post by:
As title, Thanks
26
by: codercode | last post by:
I'm working on a Visual Basic .NET using Access database. However, my client already have a 30MB database with Sybase ASA and Sybase is way too much for that. Is there anyway I can migrate from a...
0
by: =?ISO-8859-1?Q?S=E9bastien_Sabl=E9?= | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. The module is...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.