question

Mistens avatar image
Mistens asked

Linked server stops working after Migration from 2000 2014

After Migrating SQL Server instance from 2000 to 2014. Linked Server queries that were ran against an Oracle database started failing with date time conversion and sometimes returning insufficient rows. Is there a way to make sql server 2014 DNS s stay the same as was in MSSQL 2000? Thanks Mistens
sql-server-2000oraclelinked-servermigrationsql-server-2014
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Mistens avatar image Mistens commented ·
Note the connections are to an oracle database
0 Likes 0 ·
JohnM avatar image JohnM commented ·
Can you post the exact error message? Did anything in the SQL Server database change during the migration?
0 Likes 0 ·
Mistens avatar image Mistens commented ·
Nothing changed. The linked server has issue returning rows from a view with a derived date field and there was no such issue in version 2000. Migrated the database to 2008 and set it to compatible level 80 or 2000 compatible not much luck still. there still appear to be issues returning the date columns This time it just ignores them Thanks for looking at this Mistens
0 Likes 0 ·
JohnM avatar image JohnM commented ·
A query of the linked server returns a result set but without the derived date column?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.