There is an article in Oracle's knowledgebase called "metalink". Have your oracle dba log into metalink and look up docID 191368.1 entitled "How to create a sql Server linked server...

What version of Oracle are you connecting to?

And...any reason why you are not using the Oracle Provider for Oracle instead of the Microsoft provider? It's a night and day difference...

My question is this....

Please correct me if I'm wrong, or how to get around the issue, but how about a real-life scenario that I have:

I have been given a...

Thanks everybody for all the help. I tried the attach as described in your instructions, but I found out that the db did not come down cleanly, so it wouldn't...

Steve, you are a genius! Because of what you mentioned, I began to think....maybe it needs to do the name resolution first, before it goes to the info. in the...

It's in the DMZ, so it's locked down good. They've only got port 1433 open at the moment. If I Query Anal. directly to the IP address, that's all it...

I just recently applied the Sp4 for SQL, but to no avail. I'm playing with the "shared memory protocol" now to see if that is any help. Just baffling right...

I'm getting the picture that people are experienced with Litspeed. I've got a few more questions for anybody out there.

1) For you Litspeed users, how has the Tech support been...

The thought did cross my mind that the stored proc was being cached, but I was not aware of how to make it flush the cache. Thanks for the tip.

Very very bizzarre thing today. I had a coworker look over it, and he forced the stored proc to recompile from query analyzer (I was using EM to make changes)...

I changed the statement to this:

SELECT

DEPTID_DEPTCODE_XREF_ID,

x.DEPTID x,

p.deptid p,

DEPARTMENT_NAME,

p.descr,

p.deptid as pdeptid,

DEPT_CODE,

ACTIVE

FROM Intranet.dbo.DEPTID_DEPTCODE_XREF X

left join Intranet.dbo.vw_Adsmgt_PS_RemoteLocations P

 on substring(x.deptid,1,3) = substring(p.deptid, 1,3)

and substring(x.deptid,1,3) NOT in ('021','037')

In...

Fortunately for me, it was a non-production box. The box has since then been formatted and used for something else. I did have an E-ticket into MS for the issue, but...

The version is Oracle 9.2

I still haven't resolved the issue. Since it was working, I got pulled into other stuff and didn't have time to go revisit.

I am the...

You know, you can recreate those logins on the new server so that you don't orphan them. As long as your old server is still running, you can have it...

Update: There must be some type of permissions problem. I normally have all my scheduled jobs run by a network user which has a lot of authority. I changed it...