I think the point of my question maybe getting lost a bit.

Essentially, all Im seeking is an answer as to whether I can connect to a Linked server (Oracle) using...

Hi Jo

In a word No 🙂

The situation I have is that I am from a SQL server dev background

I have been given the log on details to an Oracle environment,...

Hi thanks

Unfortunately, that doesn't answer my point

I dont have a problem connecting as a known user (in your example scott/tiger), the problem comes when attempting to connect using the "as...

UPDATE

So guys and girls, no responses

I ended up having to talk to the DBA responsible for the MySQL DB and asked him to alter the casting of the RogueCol from...

....And the ball keeps rolling

I found this solution and tinkered with it for my own needs

I have a Utils DB that I call SPs from therefore I need to be...

Cheers Bhaskar.Shetty

I knew it would be a simple explanation

And a big thanks to Mister.Magoo too 😀

Final solution in case anyone stumbles across this (or wants a dynamic solution to the...

HI there

Just going to start digesting your response, but just for completeness here is SP1 (In reality called sp_RemFlds....)

It's designed to be flexible to return differing outputs depending on what...