In my article ORACLESRV1 is the server name. Maybe you should first try to setup the link connection with the GUI. Once you see it working then you can modify the script to fit your needs.

Please verify:

@server = your oracle server name

and

@datasrc = service name located in your tnsnames

One last thing, did you install the Oracle client onto the SQL server that you connected to?

If you are still having issues you may have to talk to your Oracle DBA as I'm not sure what else to say.

Thanks,

Rudy