Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2006-10-30 : 22:56:27
|
| Hi,Our team is using IBM DataStage tool for some Data linkage and transformation from our SQL Server to our DB2 Server. We use ODBC connectivity to connect to SQL Server database. When we test ODBC connection while setup, it says connection successfull. But when we use DataStage tool it gives error like "DSR.MetaGeta(GET.FOREIGNKEYS)(SQLForeignKeys): BCI Error: SQLSTATE=37000,CODE=7202,[DataStage][SQLClient][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server][Could not find server 'BiogenixV4' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."Now, we are not connecting via a database server to this SQL Server, it is merely an ODBC connection used by this DataStage tool. Any suggestions for this??Thanks,Ujjaval |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-30 : 23:40:39
|
| It sounds like this tool is expecting a linked server named BiogenixV4 to be on the SQL Server. Is this name familiar? Is it the DB2 server or the SQL Server name? |
 |
|
|
ujjaval
Posting Yak Master
108 Posts |
Posted - 2006-10-30 : 23:45:40
|
| That's sql server name. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-31 : 00:02:59
|
Well, this part seems pretty explanatory:quote:
Execute sp_addlinkedserver to add the server to sysservers
See if this works:Execute sp_addlinkedserver 'BiogenixV4', 'SQL Server'Might also need to run:Execute sp_serveroption 'BiogenixV4', 'data access', 'true' |
|
|
|
|
|
|
Problem with DataStage tool with SQL Server