Can't see or access tables through linked server

Apparently I am doing something wrong and I don't know what!

I am needing to link a remote Oracle Server to SQL Server 2005.

I have (I think) followed the steps precisely to create the linked

server both by code or through the SQL Server Management Studio and I

get the same results eith way. I can see the linked server and there are no apparent errors but I can't see or access the tables from Oracle.

If I try a Select statement on a table from the linked server I get the

error "Msg 208, Level 16, Stat 1, Server {servername}, Line 1 Invalid

object name"

I am assuming this is a permissions issue but I don't see it. I

am an admin on both the SQL Server DB and the Oracle DB with full

access and I am using windows authentication.

I have mapped local logons to the remote logon and tried almost every

possible combination of security contexts and other users on the local

and linked server but I always get the same result. The Oracle server shows it is linked but I can't get to any table on the linked server.

Any help on this would be really appreciated. I have already spent two days on this.

Thanks in advance.

This kb should help.

support.microsoft.com/kb/280106

|||

I don't think this applies. This KB article only covers up to Windows 2000 and Oracle 8.i.

We have either 2003 server or XP (happening on two machines) and Oracle 10g.

Also, I am not getting any error messages as the article discusses, I just can't see the tables.

Thanks for the help.

sql

Can't Register Servers in Enterprise Managers

I posted this in the wrong forum, so if you see this in SQL Programming it was a mistake on my part.
I have two users that can't register servers in Enterprise Manager, and they're getting "login failed" when they try.
I've searched the errorlog file for any indication of the failure, but there are no entries being written. I've tried deleting and re-adding the accounts, but no luck.
Suggestions on now to fix?
Thanks,
DaleHow are they trying to authenticate...windows or SQL?
"Dale Chavez" wrote:
> I posted this in the wrong forum, so if you see this in SQL Programming it was a mistake on my part.
> I have two users that can't register servers in Enterprise Manager, and they're getting "login failed" when they try.
>
> I've searched the errorlog file for any indication of the failure, but there are no entries being written. I've tried deleting and re-adding the accounts, but no luck.
>
> Suggestions on now to fix?
>
> Thanks,
> Dale
>

Cant insert enough characters...

I must be doing something wrong, but I cannot imagine what it could be. I made a brand new table and started to enter some data. I am putting the initail data in using Enterprise Manager. This is essentially test data for development. I have several varchar columns set to 8000 for their size. When I try to enter text into them it is getting truncated at 999 characters. I thought that maybe I misunderstood the varchar type and that 1000 characters is 8000 bits and that is what the 8000 means. So, I redid the table with the datatype "text" for my long columns. Same thing. It is being truncated at 999. Is there something I am missing here? I am not trying to do anything tricky or confusing, I am simply trying to put more than 1000 characters into a table column.
I should mention that I have been pasting the text that is copied from Notepad (to remove any extranous formatting). The text cuts cut off and I cannot even type in the column after that.
Any clues would really be appreciated.I believe there is this 1000 odd (may be 1024) limit for entering data through Enterprise Manager.
Don't forget that Enterprise Manager is not the ultimate tool for data entry.
If you run an INSERT or UPDATE statement through SQL Query Analyzer,you should be just fine. Or even submitting more than 1000 charactersfrom an ASP.NET webform and performing an INSERT.
Hope that helps.
Wim
|||Ok, that makes sense. I just wanted to make sure I wasn't going crazy :) Thank-you for the information.