Odbc - Why Your Mysql Table Is Accessed As Read-only

openSUSE

Quick Links

openSUSE Forums » Odbc - Why Your Mysql Table Is Accessed As Read-only

		openSUSE Forums > Archives > SLS Archives > ARCHIVES - Linux Tweaks > ARCHIVES - Tips, Tricks & Tweaks
Odbc - Why Your Mysql Table Is Accessed As Read-only

ARCHIVES - Tips, Tricks & Tweaks Post your tips, tricks and tweaks about SuSE Linux in here. Please do not ask questions here - this is for factual information

LinkBack

Thread Tools

Display Modes

#1 (permalink)

04-Dec-2006, 07:31

WinPing

Guest

Posts: n/a

MySQL tables that are accessed via an ODBC connection must have a primary key. If you omit the primary key the table will only be accessible as read-only. You might want to remember this when you are testing an ODBC connection with a quickie database you designed in 30 seconds. This one had me banging my head against the wall for hours. Hope it helps someone else.

Bookmarks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules