Thanks Andy! However, no on the permissions as I have Domain Admin privs throughout. The error I recieve is as follows;
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.
If I map the drive it works fine. However, that is annoying. Additionally, I know that it worked in the past. My guess is that something changed causing the UNC to not be recognized. Just hoping someone else has stumbled across this. Weird.
Interested in any thoughts that anyone has on this. Thanks in advance.
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot