I'm trying to import metadata from SQLServer 2000 into DataStage when the following error occurs. Anyone have a clue what this is?
DSR.MetaGeta(GET.FOREIGNKEYS)(SQLForeignKeys): BCI Error:
SQLSTATE=37000,CODE=7202,[DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'BiogenixV4' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Thanks.
Error Importing Metadata from SQLServer
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
This is an issue with the way access to SQL Server has been set up. As the error message says, there is no entry for BiogenixV4 in sysservers. Get your SQL Server DBA to assist with the sp_addlinkedserver stored procedure which can add the entry.
This is an issue with the way access to SQL Server has been set up. As the error message says, there is no entry for BiogenixV4 in sysservers. Get your SQL Server DBA to assist with the sp_addlinkedserver stored procedure which can add the entry.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.