Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcordero
Starting Member
2 Posts |
 Posted - 2010-07-21 : 13:53:53
|
| I created a linked server connection from MS SQL 2005 to SQL Anywhere 11 using a read only password, but when trying to query the Sybase Database, I get the error: "An invalid schema or catalog was specified for the provider "SAOLEDB.11" for linked server "HOMEWORKS". The connection tests are successful between the two.From SQL2005, I use: SELECT * FROM [HOMEWORKS].[TEST].[BTI].[ALLERGIES]When I try using a hidden character after the table name i get the same error with: "The table either does not exist or the current user does not have permissions on that table." So far the only solutions i've seen online are for hidden characters and to use server.database.dbo.tableOther suggestions? |
|
|
townslr
Starting Member
1 Post |
Posted - 2010-10-20 : 19:55:58
|
| Try this:SELECT * FROM [HOMEWORKS]..[BTI].[ALLERGIES] |
 |
|
|
|
|
|
MS SQL 2005 to Sybase