Home > database >  The problem of link in pb server access data
The problem of link in pb server access data

Time:09-24

Problems link server to access the data in the pb
1, first create a view in SQL SERVER2005, which used to link the server view, like
The CREATE VIEW [dbo] [view_zh]
AS
SELECT *
The FROM link server name. The database name. Dbo. Table name

In the query analyzer query this view select * from view_zh, there is no problem;

2, and then create the data window in the PB, I am using PB9 program, select the view, click next, will quote "heterogeneous query requirements set for connection ANSI_NULLS and ANSI_WARNINGS options, this will ensure that the query semantics is consistent, please enable these options, and then issue the query again,", the result is not to create data window, so the problem of how to solve, or no other alternative method? Thank everybody!!!!!!
  • Related