OraFAQ Forum: Networking and Gateways » ODBC connection read-only

Home » RDBMS Server » Networking and Gateways » ODBC connection read-only

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ODBC connection read-only [message #367598]

Mon, 01 February 1999 06:05

Olaf
Messages: 7
Registered: February 1999

Junior Member

Im setting up an ODBC connection from MS Access to Oracle 8.
When I access the tables through ODBC (Oracle ODBC driver 8.0.5.2.0) I get them Read-Only. I do not have the Read-Only option checked in the data source configuration. This is very strange since I can load SQLPlus create a dummy table and throw in couple of values, go to MS Access and link the dummy table and it will be modifiable, but the tables already there will still be read-only. Also after a while the dummy table will become read-only. I have not been able to find out what puts it in the Read-Only mode.
Has anybody else experienced this?

Thanks.
Olaf

Report message to a moderator

Re: ODBC connection read-only [message #367599 is a reply to message #367598]

Mon, 01 February 1999 16:18

Bruce
Messages: 21
Registered: November 1998

Junior Member

Olaf,

I've seen this behaviour when the table did not have a primary or unique key. Set up a PK and see if that helps.

Bruce
<CENTER><A ONMOUSEOVER="window.status='Ambassador Consulting - People First!'; return true" HREF="http://www.ateam.com/html/c_vs_c.html" ONMOUSEOUT="status=' ';"><IMG SRC="http://www.ateam.com/assets/images/teamlogo.gif" BORDER="0">[/url]</CENTER>

Report message to a moderator

Re: ODBC connection read-only [message #367600 is a reply to message #367599]

Tue, 02 February 1999 03:51

Olaf
Messages: 7
Registered: February 1999

Junior Member

Yes that was it. Thank you. Of 20+ tables I was importing only one small reference table didnt have a UK/PK, that was enough to get the whole thing read-only.

Olaf

Report message to a moderator

Previous Topic:	Database Links Oracle 8.0.5.1 -> 7.3.3
Next Topic:	Net8 connection has slowed since last week

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 04 10:30:00 CDT 2025