Error 7314

Troubleshooting SQL Server

Troubleshooting

Error 7314

Severity Level 16
Message Text

OLE DB provider '%ls' does not contain table '%ls'.  The table either does not exist or the current user does not have permissions on that table.

Explanation

Either the specified table or columns do not exist or the login used to connect to the provider does not have the required permissions on the table or columns.

This message occurs on case-sensitive servers.

Action

Verify that the table or columns specified exist. Verify that the appropriate permissions are granted on the table or columns specified.

If the table was originally created in Oracle without quotation marks, specify the table name in the distributed query using all uppercase letters. If the table was originally created in Oracle with quotation marks, specify the table name in the distributed query using all lowercase letters.

See Also

Distributed Queries

Errors 7000 - 7999

OLE DB Providers Tested with SQL Server

sp_addlinkedserver