2 Linked Servers using MSDASQL with conflicting Provider settings
couldn't figure it out so I just solved it using openquery instead of selecting from linked server! not great but time constraints needed it solved.