Feedback: irt.org FAQ Knowledge Base Q3006

Feedback on: irt.org FAQ Knowledge Base Q3006

Sent by Orlando Correa on May 04, 2000 at 11:48:28: - feedback #1180

Worth:
Very worth reading

Comments:
I wrote the following CF for SQL Server to get all the tables using the system tables:

<CFQUERY NAME="getTables" DATASOURCE="#ds#" DBTYPE="ODBC">
SELECT * FROM INFORMATION_SCHEMA.COLUMNS
<CFIF IsDefined("url.table_name")>
WHERE table_name='#url.table_name#'
<CFELSE>
ORDER BY table_schema, table_name, ordinal_position desc
</CFIF>
</CFQUERY>

Thanks for providing the MS Access version...

Sent by shankar on July 05, 2000 at 06:36:13: - feedback #1457

Comments:

Upon using the abov e mentioned code ..i got the following error..I need help to solve this problem..an d i need it really fast.

ODBC Error Code = 42000 (Syntax error or access violation)

[Microsoft][ODBC Microsoft Access 97 Driver] Record(s) can't be read; no read permission on 'MSysObjects'.

Sent by Matt Fisher on September 26, 2000 at 22:55:41: - feedback #1794

Worth:
Worth reading

Comments:
This example worked great for me, when I used it in Access itself. However, when I tried using it in Cold Fusion with my Access Database via ODBC, I got an access violation that said that I did not have read access to the table MSysObjects. Is there a work around for this? Something I can set in the database itself? Thanks in advance.

Sent by THIS EXAMPLE DOES NOT WORK on October 16, 2001 at 22:40:34: - feedback #3250

Technical:
Not technical enough

Comments:
Sorry but this example does not actually work ~ this is what it generates: "Record(s) cannot be read; no read permission on 'MSysObjects'"

Regards, BB <ben@cfml.net>