I think I have enlightened myself somewhat: Using .net program suggested on: http://sapdb.2scale.net/moin.cgi/UsingMicrosoftApis
with command "SELECT owner,tablename,type,tabletype FROM tables" I realized that the Database Instance which I was querying was different to the one being shown in SQL studio. That's why the table wasn't there :-] --- Eoghan Murray <[EMAIL PROTECTED]> wrote: > Hi all, > > My specific question is if someone could explain the > difference between 2 icons in the SQL Studio Tables > view... > -system created tables (yellow and white cogs for > the > icon) > -user created tables (tabular like icons with blue > head) > > > Is there any functional difference between two of > these types of tables (are the system created tables > read only?) > > The reason I ask is that I can do a SELECT query on > the system created tables, but an identical query on > the user created tables yields the following error > (using the microsoft-odbc administration-tracing > tool): > > ConsoleApplicat bbc-324 EXIT SQLExecDirectW with > return code -1 (SQL_ERROR) > HSTMT 079A1940 > WCHAR * 0x0494E31C [ -3] "SELECT > * > FROM "DBA"."ANNOUNCEMENTS"\ 0" > SDWORD -3 > > DIAG [42S02] [MySQL MaxDB][SQLOD32 DLL][MaxDB] > Base > table or view not found;-4004 POS(16) Unknown table > name:ANNOUNCEMENTS (-4004) > > Thank you > eoghan > > > > > > ___________________________________________________________ALL-NEW > Yahoo! Messenger - all new features - even more fun! > http://uk.messenger.yahoo.com > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
