MSOLEDB Provider for SQL Server: Cannot find data type <whatever>
Posted on 2008-10-30
Recently had to perform an emergency transfer of a SQL Server Database from one server to another - managed to create a virtual drive for the Database files to "live" on, and mounted them to the new server. Made the server "aware" of the new database, and everything seemed to be rolling fine.
Now, for some reason, it cannot find/access User-Defined Data Types, and there they are, plain as day, under the Database->Programmability->Types->User-defined Data Types. Is there some sort of process I'v left out to tell the SQL Server that it needs these data types?
Oh yeah - I almost forgot: we're getting this error from an Access Application that directly "talks" to SQL Server. (Don't laugh too loud - it's supposed to be our Accounting Software.) If this makes any difference, which I don't believe that it does.
I'm not sure where to go from here... ?