|
|---|
|
|
|
|
|
|
B***y
发帖数: 138 | 1 My work has a distributed application running on SQL Server.One of the
reports in the application pulls data from a sp named sp_Roster. Currently
the sp_Roster runs properly from the application side.
We have a need to incorporate the some piece of data from a linked Server.
After I wrote codes including the linked server data inside this sp_Roster,
it executes properly through command line but on the application side it
will not display the report properly by prompting database DLL error...
However, if I replace the linked server data with a view it will function
properly so I'm wondering if it has anything to do with application data
connection. Does it matter where I set up the linked server? Does it have to
be done on the Server?
THANKS! | i****a
发帖数: 36252 | 2 Linked server needs to be on the sql server that the SP is.
[发表自未名空间手机版 - m.mitbbs.com] | B***y
发帖数: 138 | 3 The linked server is actually created on the Server...I think the problem is
the report in the application was created by crystal report viewer. Per
some forum I revise the linked server provider from SQL server to OLEDB SQL
and it still gives me "Database DLL error". Since I don't have the source
code the VB application and I cannot open that report in a design view now I
'm wondering if there is nothing else I can do...
【在 i****a 的大作中提到】
: Linked server needs to be on the sql server that the SP is.
: [发表自未名空间手机版 - m.mitbbs.com]
|
|
|
|
|
|
|
